Set long: query a table or view that has a LONG column : Long « Data Type « Oracle PL / SQL






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

1.Change column type from long to clob
2.Demonstrate a method of converting to a LONG column to CLOB:
3.Conversion of Longs to LOBs
4.Insert char value to long type column
5.Long raw type column
6.Long type column