set long 5000 : long « SQL Plus « Oracle PL / SQL






set long 5000

 
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>

 








Related examples in the same category

1.Set long