| SQL adaptation guide for Oracle Database 11, 12 / Data dictionary | |
Informix® and ORACLE have different implementations of the ALTER TABLE instruction. For example, Informix allows you to use multiple ADD clauses separated by commas. This is not supported by ORACLE:
Informix:
ALTER TABLE customer ADD(col1 INTEGER), ADD(col2 CHAR(20))
ORACLE:
ALTER TABLE customer ADD(col1 INTEGER, col2 CHAR(20))
No automatic conversion is done by the database interface. There is no real standard for this instruction ( that is, no common syntax for all database servers). Read the SQL documentation and review the SQL scripts or the BDL programs in order to use the database server specific syntax for ALTER TABLE.