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

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s