Oracle PL/SQL/SQL Plus/long

Set long

 
select text
from all_views
where view_name = "USER_TABLES";
set pagesize 1000
set long 10000
 /

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>