How to update CLOB field
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: How to update CLOB field

  1. #1
    Join Date
    Nov 2003
    Posts
    6

    Unhappy How to update CLOB field

    Hi,

    one of the field in a table is having CLOB data type. There is big text in that field. Now I want to modify the value of the field (add some line of text in the same value)
    How to do this?

    thanks in advance

  2. #2
    Join Date
    Nov 2000
    Location
    Pittsburgh, PA
    Posts
    3,997

    Re: How to update CLOB field

    Originally posted by mp417
    Hi,

    one of the field in a table is having CLOB data type. There is big text in that field. Now I want to modify the value of the field (add some line of text in the same value)
    How to do this?

    thanks in advance
    If it were me, I would become familar with PL/SQL and the DBMS_LOB package.
    this space intentionally left blank

Posting Permissions

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



Click Here to Expand Forum to Full Width