Oracle PL/SQL/SQL Plus/long

Set long

   <source lang="sql">

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

/    
</source>
   
  

set long 5000

   <source lang="sql">

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>

</source>