Set long : long « SQL Plus « Oracle PL / SQL

1. Oracle PL / SQL
2. SQL Plus
3. long

Set long

 

select text
from all_views
where view_name = 'USER_TABLES';

set pagesize 1000
set long 10000
 /    

 

Related examples in the same category