Create or replace a view
SQL> SQL> create table t( 2 id number, 3 data varchar2(200) ); Table created. SQL> SQL> SQL> create or replace view view_t as 2 select id view_id, data view_data 3 from t; View created. SQL> SQL> select * from view_t; no rows selected SQL> SQL> drop table t; Table dropped. SQL>