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.

Leave a Reply