'How Do I Update/Use Clob Column Data Type'
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: 'How Do I Update/Use Clob Column Data Type'

  1. #1
    Join Date
    Feb 2003
    Location
    UK
    Posts
    1

    Question 'How Do I Update/Use Clob Column Data Type'

    Hi Guys,

    I need to Update, Text Entries into the Database Table Columns,
    Where the Text Entries Some thing like 10 to 15 lines may come.
    So, Should I Prefer to use clob or Something else for Database Table
    Column Data Type. Then If I use Clob, I am Using PB as Front End
    Then How can I update, the column Values thr'o sql Statement or I can Use Datawindow Update Itself.


    Pls. Revert me back Guys.


    /Sivan...

  2. #2
    Join Date
    Sep 2000
    Location
    Chennai, India
    Posts
    865
    If we assume each line to have 100 characters, it amounts to 1500 characters, which is not much for you to use CLOB. You can have a limit of 4000 characters with VARCHAR2(4000).

    HTH.

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