DROP VIEW "MyUser"."MyView";
CREATE VIEW "MyUser"."MyView" AS
SELECT MyTable.name
FROM MyUser.MyTable
WHERE MyTable.number = 'A123';
文章標籤
全站熱搜
- 1月 13 週二 200909:48
[oracle]CREATE VIEW
DROP VIEW "MyUser"."MyView";
CREATE VIEW "MyUser"."MyView" AS
SELECT MyTable.name
FROM MyUser.MyTable
WHERE MyTable.number = 'A123';