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
kish@exdbx<>create view STB1 as select * from sales_t; View created.
kish@exdbx<>create or replace view STB as 2 select order_id from sales_t 3 where order_id < 3000; View created.
kish@exdbx<>drop view STB; View dropped.