Long Raw data type

[tamilselvan]

"Select * from table" will work if the table has clob data type.

SQL> desc my_table ;
 Name                     Null?    Type
 ----------------------- -------- ------------------------------------
 ID                                NUMBER
 MY_CLOB                           CLOB

SQL> L
  1* select * from my_table
SQL> /

        ID MY_CLOB
---------- ----------------
         1 Test clob

Tamil