Create View
CREATE OR REPLACE VIEW person_view AS
SELECT first_name, last_name, ssn
FROM person
WHERE title IS NOT NULL;
SELECT * FROM person_view;
CREATE OR REPLACE VIEW person_view AS
SELECT first_name, last_name, ssn
FROM person
WHERE title IS NOT NULL;
SELECT * FROM person_view;
Drop View
DROP VIEW <view_name>;
DROP VIEW <view_name>;
List Source of a View
SET HEAD OFF
SET LONG 4000
SELECT owner, text
FROM all_views
WHERE owner = <schema_name>
AND view_name = <view_name>;
SET HEAD OFF
SET LONG 4000
SELECT owner, text
FROM all_views
WHERE owner = <schema_name>
AND view_name = <view_name>;
List Columns (and Information) of a View
SELECT view_name
FROM user_views;
COL data_type FORMAT a30
SELECT column_name, data_type, data_length
FROM user_tab_columns
WHERE view_name = <view_name>;
SELECT view_name
FROM user_views;
COL data_type FORMAT a30
SELECT column_name, data_type, data_length
FROM user_tab_columns
WHERE view_name = <view_name>;