Data Type for Text
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: Data Type for Text

  1. #1
    Join Date
    Jan 2001
    Posts
    642
    Hi,

    For one of the applications, I need to store the entire article/writeup about each product it the table. The write up will contain number of paragraphs and will be given to me as a text file.

    1)Can I use the SQL loader for this kind of data loading
    2) WHat should be the datatype of the field which should contain this text data.

    Badrinath

  2. #2
    Join Date
    Jan 2001
    Posts
    2,828

    Talking

    Hello

    Yes you can use sql loader for loading thsi kinda of data.you should be using CLOB data type.

    http://www.dbasupport.com/forums/sho...?threadid=8170

    regards
    hrishy

  3. #3
    Join Date
    Oct 2000
    Location
    Saskatoon, SK, Canada
    Posts
    3,925
    Yes, you can use the SQL loader and the datatype could be CLOB or BFILE( if you are planning to maintain the files externally, under some directory).

    Sam
    Thanx
    Sam



    Life is a journey, not a destination!


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