SQL>
SQL>
SQL> set long 5000
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 from t;
View created.
SQL>
SQL> select text from user_views where view_name = 'VIEW_T';
TEXT
--------------------------------------------------------------------------------
select id view_id, data view_data from t
SQL>
SQL> drop table t;
Table dropped.
SQL>
|