https://www.sqlines.com/ 2026-04-09T06:44:03+00:00 https://www.sqlines.com/ https://www.sqlines.com/lib/images/favicon.ico text/html 2013-04-11T21:34:23+00:00 https://www.sqlines.com/informix-to-oracle/data_validation?rev=1365716063&do=diff SQLines Data tool helps you validate the data transfer from Informix to Oracle after the database migration. Row Count Check The fastest and simplest way that can reveal critical problems in data migration is to check the number of rows in corresponding Informix and Oracle tables. text/html 2013-09-03T08:16:12+00:00 https://www.sqlines.com/informix-to-oracle/execute_os_cmd?rev=1378196172&do=diff In Informix you can use SYSTEM statement to execute a OS command from a SPL stored procedure. In Oracle you can use DBMS_SCHEDULER.CREATE_JOB built-in package procedure to execute a OS command from a PL/SQL stored procedure. SYSTEM Statement in Informix You can use the SYSTEM statement in a stored procedure in Informix as follows: text/html 2013-08-26T08:54:30+00:00 https://www.sqlines.com/informix-to-oracle/null_order_by?rev=1377507270&do=diff In Informix, when you sort columns in ORDER BY clause NULL values go first for ascending order, and last for descending order. In Oracle, the default behavior is different, NULL values go last for ascending order, and first for descending order, but Oracle provides NULLS FIRST and NULLS LAST clauses in ORDER BY to specify sorting for NULL text/html 2022-10-16T17:13:04+00:00 https://www.sqlines.com/informix-to-oracle/outer?rev=1665940384&do=diff Informix supports the specific OUTER clause in the FROM clause of the SELECT statement to define the outer joins. It has to be converted to ANSI SQL outer join syntax in Oracle. Consider the following tables with sample data: CREATE TABLE cities (name VARCHAR(30), country VARCHAR(30)); CREATE TABLE countries (name VARCHAR(30), capital VARCHAR(30), region VARCHAR(30)); CREATE TABLE regions (name VARCHAR(30), continent VARCHAR(30)); -- Cities INSERT INTO cities VALUES ('Malaga', … text/html 2013-04-08T12:53:21+00:00 https://www.sqlines.com/informix-to-oracle/reserved_words?rev=1365425601&do=diff Informix and Oracle have reserved words that cannot be used as an identifier (table or column name i.e.). But the reserved words in Informix and Oracle are different, and when you migrate a table from Informix to Oracle, the table name or a column that is non-reserved word in Informix can be a reserved word in Oracle. text/html 2023-12-19T14:01:12+00:00 https://www.sqlines.com/informix-to-oracle/return_with_resume?rev=1702994472&do=diff In Informix you can create a stored procedure that returns multiple rows using RETURN WITH RESUME statement. This allows you to execute the procedure in the FROM clause of a SELECT statement. When you convert such procedures to Oracle you can use a pipelined function (table function). text/html 2013-08-28T11:44:27+00:00 https://www.sqlines.com/informix-to-oracle/serial_columns?rev=1377690267&do=diff In Informix, you can use the SERIAL data type to automatically generates IDs (auto-increment values) for columns. Informix: CREATE TABLE teams ( id SERIAL NOT NULL, name VARCHAR(70) ); -- Let's insert a few rows INSERT INTO teams VALUES (0, 'AC Milan'); INSERT INTO teams VALUES (0, 'Manchester City'); text/html 2013-09-07T10:08:58+00:00 https://www.sqlines.com/informix-to-oracle/temporary_tables?rev=1378548538&do=diff In Informix, a session can create a temporary table to hold the query results. Both the definition and data of this temporary table are not visible to other users or sessions. The temporary table exists until the end of session, or until DROP TABLE statement is issued on the temporary table. text/html 2013-09-30T13:00:10+00:00 https://www.sqlines.com/informix-to-oracle/to_char_datetime?rev=1380546010&do=diff Informix and Oracle provide TO_CHAR function to convert a datetime value to a string using the specified format, but format strings are different. Informix: -- Convert the current date and time to string (year-month-day) SELECT TO_CHAR(TODAY, '%Y-%m-%d') FROM systables WHERE tabid = 1; # 2013-09-30