El DDL generado se muestra en la página Vista previa de DDL del asistente Pegar objetos de base de datos.
La Tabla 1 muestra ejemplos del DDL que se genera para copiar vistas de una base de datos de origen Oracle Database 11g en una base de datos de destino DB2 Versión 9.7 para Linux®, UNIX® y Windows®.
| Definición de vista de Oracle Database 11g | DDL generado para la base de datos DB2 Versión 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 |
La Tabla 2 muestra un ejemplo del DDL que se genera para copiar vistas de una base de datos de origen DB2 Versión 9.7 para Linux, UNIX y Windows en una base de datos de destino Oracle Database 11g.
| Definición de vista de la base de datos DB2 Versión 9.7 | DDL generado para Oracle Database 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;
|