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: Logo

You are commenting using your 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