D.Z.Memo

1. Create View
CREATE VIEW [view name] AS
SELECT ... ... ;

CREATE VIEW [view name] ( [column alias name], ... , [column alias name]) AS
SELECT ... ... ;

2. Modify View
CREATE OR REPLACE VIEW [view name] AS
SELECT ... ... ;

元表がないと、新規Viewを作成する場合、
CREATE OR REPLACE FORCE VIEW [view name] AS
SELECT ... ... ;

3. Constraint
Viewを作成時のWhere文の制約を、Viewを通じてデータ挿入／更新時にも有効にする場合は、
CREATE VIEW [view name] AS
SELECT ... FROM ...
WHERE ...
WITH CHECK OPTION CONSTRAINT [constraint name];

挿入／更新／削除できないように、ReadOnly制約をかけることもできる
CREATE VIEW [view name] AS
SELECT ... ...
WITH READ ONLY CONSTRAINT [constraint name];

4. Delete View
DROP VIEW [view name];

5. View View
The information of View can be obtained from Data Dictionary View:
USER_VIEWS

The construction of view can be gotten by
DESC [view name]