Oracle to Netezza Migration

SQLines provides tools and services to help you transfer data, convert database schema (DDL), views, stored procedures, functions, packages, triggers, queries and SQL scripts from Oracle to Netezza.

  • Oracle 12c, 11g, 10g and 9i
  • Netezza 7.x

We also help convert embedded SQL statements in C/C++ (ODBC, Pro*C, OCI), C#, Java, PowerBuilder, VB/VB.NET, ASP/ASP.NET, Perl/PHP and other applications.

Oracle to Netezza Migration Tools

SQLines tools to help you migrate from Oracle to Netezza:

SQLines SQL Converter Tool

SQLines SQL Converter tool allows you to convert database schema (DDL), queries and DML statements, views, stored procedures, functions and triggers from Oracle to Netezza.

SQLines tool converts SQL scripts and standalone SQL statements.

SQLines tool is available in Online and Desktop editions:

Try SQLines Online or download a Trial Version.

Oracle to Netezza Migration Reference

Technical information on migration from Oracle to Netezza.

Last Update: Oracle 12c and Netezza 7.x

SQL Language Elements

Converting SQL and PL/SQL language elements from Oracle to Netezza:

Oracle Netezza
1 SQLERRM Error message text SQLERRM
2 SQL%ROWCOUNT Number of processed rows ROW_COUNT
3 column%TYPE Derived data type attribute column%TYPE

Data Types

Converting data types from Oracle to Netezza:

Oracle Netezza
1 NUMBER(p,0), NUMBER(p) Fixed-point number, 9 <= p <= 38 NUMERIC(p)

Built-in SQL Functions

Converting built-in functions from Oracle to Netezza:

Oracle Netezza
1 INSTR(string, substring) Get position of substring in string POSITION(substring IN string)
2 TO_CHAR(exp) Convert expression to string CAST(exp AS VARCHAR(30))

SELECT Statement

Converting SQL SELECT statement and its clauses from Oracle to Netezza:

Oracle Netezza
1 SELECT exp FROM dual Calculate expression SELECT exp
SELECT exp FROM _v_dual

CREATE PROCEDURE Statement

Converting CREATE PROCEDURE statement from Oracle to Netezza:

Oracle Netezza
1 CREATE OR REPLACE PROCEDURE CREATE OR REPLACE PROCEDURE
2 param IN | OUT | IN OUT datatype DEFAULT default datatype
param ALIAS FOR $1; …
3 IS | AS RETURNS INT EXECUTE AS CALLER LANGUAGE NZPLSQL AS BEGIN_PROC
4 END proc_name; END;
5 / END_PROC;

PL/SQL Statements

Converting PL/SQL statements and clauses from Oracle to Netezza:

Cursor operations:

Oracle Netezza
1 cur SYS_REFCURSOR Cursor variable cur RECORD
2 CURSOR cur IS select_stmt Cursor declaration cur RECORD
3 OPEN cur; LOOP Open and iterate through a cursor FOR cur IN select_stmt LOOP
4 OPEN cur FOR select_stmt; LOOP
5 OPEN cur FOR sql_var; LOOP FOR cur IN EXECUTE sql_var LOOP
6 FETCH cur INTO v1, v2, … Fetch data v1 := cur.c1; v2 := cur.c2; …
7 EXIT WHEN cur%NOTFOUND Terminate loop when no row found EXIT WHEN NOT FOUND
8 CLOSE cur Close a cursor Removed

Flow of control statements:

Oracle Netezza
1 EXIT WHEN exp Terminate loop when exp is true EXIT WHEN exp

EXCEPTION block:

Oracle Netezza
1 WHEN NO_DATA_FOUND No rows found IF NOT FOUND statement

Built-in PL/SQL Packages

Converting built-in PL/SQL packages from Oracle to Netezza:

Oracle Netezza
1 DBMS_OUTPUT.PUT_LINE(text) Output a message RAISE NOTICE '%', text