1 Reply Latest reply on Jul 28, 2004 6:58 PM by user148120

    CLOB fields

      I am a total newbie to the Oracle world. I have a table with a field that needs to accomdate possibly 64k of data. I was told to use a CLOB field for this. Now, when I am trying to view the data in the field using a SELECT statement in SQLPlus worksheet, I only get 80 characters of data for that field. Is it possible to retrieve all of the data in that field using a SELECT statement in SQLPlus worksheet? If so, how??

      Any help will be greatly appreciated!


        • 1. Re: CLOB fields
          You are going to have to be creative ...

          select DBMS_LOB.SUBSTR(some_file,1,least(DBMS_LOB.GETLENGTH(some_file),80) from tlob;

          select DBMS_LOB.SUBSTR(some_file,81,least(DBMS_LOB.GETLENGTH(some_file),160) from tlob;