Create or replace a view : Create View « View « Oracle PL / SQL






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>

   
    
  








Related examples in the same category

1.Create view without indiating the column name
2.Create OR REPLACE VIEW from selected columns in a table
3.Create a simple view
4.create force view
5.create materialized view
6.Create a view with check option
7.Create view by join three tables
8.Create view on single field of a type
9.Using view to simplify the query
10.User view and object id
11.Use view based on user-defind type