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;
|