Results 1 to 2 of 2
  1. #1
    Join Date
    Nov 2002
    Posts
    1

    Unanswered: Inserting text into clob column in a table

    Hi..
    How do I insert text into a clob column in a table?
    just I want the text to be inserted using a simple insert statement.

    Thanks in advance

    Srinivas

  2. #2
    Join Date
    Sep 2002
    Location
    UK
    Posts
    5,171
    Provided Answers: 1

    Re: Inserting text into clob column in a table

    Originally posted by vegisrinivas
    Hi..
    How do I insert text into a clob column in a table?
    just I want the text to be inserted using a simple insert statement.

    Thanks in advance

    Srinivas
    If the text is no more than 4000 characters long you can simply do:

    INSERT INTO tab ( clobcol ) VALUES ('value');

    For more than 4000, you would need to use the DBMS_LOB package, not a simple insert.

Posting Permissions

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