Results 1 to 2 of 2

Thread: CLOB issue

  1. #1
    Join Date
    May 2007
    Posts
    11

    Unanswered: CLOB issue

    Hi ALL,
    I have a doubt regarding Clob data type ..

    If I tried to insert a 100 or 200 characters into a CLOB data type column (I am using SQL PLUS) it will say Insertiion is successfull..

    But when I try to retrieve it using the SELECT Query it will only display upto
    80 characters only.. remaining are not visible ...

    Is that an INSERTION problem or SELECT problem ...?

    could you please guide me in this issue...?


    Thanks in advance,
    Nivin

  2. #2
    Join Date
    Dec 2007
    Posts
    253

    WRAP it

    Code:
    SQL> SELECT X FROM LOB1;
    
    X
    --------------------------------------------------------------------------------
    AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA
    
    SQL> SET WRAP ON
    SQL> /
    
    X
    --------------------------------------------------------------------------------
    AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA
    AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA
    AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •