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.