CREATE,UPDATE AND DROP VIEWS IN ORACLE
In oracle, views are stored objects which reside virtually as tables in memory(data dictionary) and has no data. View are used during the execution call and it can also created with a join of other table
Create view:
kish@exdbx<>create view STB1 as select * from sales_t;
View created.
Update view:
kish@exdbx<>create or replace view STB as
2 select order_id from sales_t
3 where order_id < 3000;
View created.
Drop view:
kish@exdbx<>drop view STB;
View dropped.