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

    CLOB fields

    272219
      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!

      Thanks.

      Barbara
        • 1. Re: CLOB fields
          user148120
          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;

          etc.