La DDL générée est présentée sur la page Aperçu du fichier DDL dans l'assistant Coller des objets de base de données.
Le tableau 1 présente des exemples de la DDL générée pour la copie des vues d'une base de données source Oracle 11g vers une base de données cible DB2 Version 9.7 for Linux, UNIX, and Windows.
Définition de la vue de la base de données Oracle 11g | DDL générée pour la base de données DB2 Version 9.7 |
---|---|
CREATE VIEW OM_view AS SELECT OM_name, sal*12 OM_sal FROM OM_table WHERE OM_number = 30; |
CREATE VIEW OM_VIEW AS SELECT OM_name, sal*12 OM_sal FROM OM_table WHERE OM_number = 30; |
CREATE VIEW OM_view1 AS SELECT OM_emp_number, OM_name, OM_dept_number, OM_id FROM OM_table WHERE OM_id='VP' OR OM_id='MANAGER' OR OM_id='S/W Eng' WITH check option; |
CREATE VIEW OM_view1 AS SELECT OM_emp_number, OM_name, OM_dept_number, OM_id FROM OM_table WHERE OM_id='VP' OR OM_id='MANAGER' OR OM_id='S/W Eng' WITH check option; |
CREATE VIEW OM_view2 (OM_id, OM_name, OM_email, CONSTRAINT id_pk PRIMARY KEY (OM_id) RELY DISABLE NOVALIDATE ) AS SELECT OM_id, OM_name, OM_email FROM OM_table; |
CREATE VIEW DB2ADMIN.OM_view2 (OM_id, OM_name, OM_email) AS SELECT OM_id, OM_name, OM_email FROM OM_table; |
CREATE VIEW OM_view_instr AS SELECT count(*) AS c1 FROM OM_table6 WHERE instr(ch30, 'character')>0; |
CREATE VIEW OM_view_instr AS SELECT count(*) AS c1 FROM OM_table6 WHERE instr(ch30, 'character')>0; |
CREATE VIEW vw_1 AS SELECT * FROM vw_str_instr; |
CREATE VIEW DB2ADMIN.VW_1 AS SELECT "C1" FROM vw_str_instr |
CREATE VIEW vw_2 AS SELECT * FROM vw_1; |
CREATE VIEW DB2ADMIN.VW_2 AS SELECT "C1" FROM vw_1 |
CREATE VIEW OM2AV010_1 AS SELECT large FROM large_tbl; CREATE VIEW OM2AV010_2 AS SELECT title_1 FROM person; CREATE VIEW OM2AV010_3 AS SELECT * FROM OM2AV010_1,OM2AV010_2; |
CREATE VIEW DB2ADMIN.OM2AV010_1 AS SELECT large FROM large_tbl CREATE VIEW DB2ADMIN.OM2AV010_2 AS SELECT title_1 FROM person CREATE VIEW DB2ADMIN.OM2AV010_3 AS SELECT "LARGE","TITLE_1" FROM OM2AV010_1,OM2AV010_2 |
Le tableau 2 présente des exemples de la DDL générée pour la copie des vues d'une base de données source DB2 Version 9.7 for Linux, UNIX, and Windows vers une base de données cible Oracle 11g.
Définition de la vue de la base de données DB2 Version 9.7 | DDL générée pour la base de données Oracle 11g |
---|---|
CREATE VIEW OM_LEAD AS SELECT OM_NO, OM_NAME, OM_EMP, OM_BASE+OM_BONUS AS OM_PAY FROM OM_table1, OM_table2 WHERE OM_EMP = OM_NAME AND OM_EMPNO > 3; |
CREATE OR REPLACE VIEW SYSTEM.OM_LEAD AS SELECT OM_NO, OM_NAME, OM_EMP, OM_BASE+OM_BONUS AS OM_PAY FROM OM_table1, OM_table2 WHERE OM_EMP = OM_NAME AND OM_EMPNO > 3; |
CREATE VIEW OM_view_proj AS SELECT * FROM OM_table3 WHERE SUBSTR(OM_Name, 1, 2) = 'OM'; |
CREATE OR REPLACE VIEW SYSTEM.OM_view_proj AS SELECT "OM_NO", "OM_NAME", "OM_EMP", "OM_DATE" FROM OM_table3 WHERE SUBSTR(OM_Name, 1, 2) = 'OM'; |
CREATE VIEW OM_VIEW_2 (OM_NO, OM_NAME, OM_TITLE, OM_DATE) AS SELECT OM_NO, OM_NAME, OM_TITLE, OM_DATE FROM OM_table4 WHERE OM_DEPT=2 WITH CHECK OPTION; |
CREATE VIEW SYSTEM.OM_VIEW_2 (OM_NO, OM_NAME, OM_TITLE, OM_DATE) AS SELECT OM_NO, OM_NAME, OM_TITLE, OM_DATE FROM OM_table4 WHERE OM_DEPT=2 |
CREATE VIEW OM_VIEW5 (OM_NO, OM_NAME, OM_TITLE, OM_DATE,OM_email) AS SELECT OM_NO, OM_NAME, OM_TITLE, OM_DATE,OM_email FROM OM_table5 WHERE OM_DEPT=12 WITH LOCAL CHECK OPTION; CREATE VIEW OM_view6 AS SELECT * FROM OM_VIEW5; CREATE VIEW OM_view7 AS SELECT * FROM OM_VIEW6; |
CREATE VIEW OM_VIEW5 (OM_NO, OM_NAME, OM_TITLE, OM_DATE,OM_email) AS SELECT OM_NO, OM_NAME, OM_TITLE, OM_DATE, OM_email FROM OM_table5 WHERE OM_DEPT=12 CREATE VIEW OM_view6 AS SELECT * FROM OM_VIEW5; CREATE VIEW OM_view7 AS SELECT * FROM OM_VIEW6; |