Set long: query a table or view that has a LONG column
SQL> -- you try to query a table or view that has a LONG column
SQL>
SQL> set pagesize 1000;
SQL> set long 100;
SQL>
SQL> select text from all_views where view_name = 'USER_TABLES' and rownum < 20;
TEXT
--------------------------------------------------------------------------------
select o.name, decode(bitand(t.property, 2151678048), 0, ts.name, null),
decode(bitand(t.prop
SQL>
Related examples in the same category