Alter view to recompile : Alter View « View « Oracle PL / SQL

1. Oracle PL / SQL
2. View
3. Alter View

Alter view to recompile

  
SQL>
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>  alter view view_t compile;

View altered.

SQL>
SQL>
SQL>  drop table t;

Table dropped.

   
  

Related examples in the same category