Data Type for Text

[badrinathn]

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

[hrishy]

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

[sambavan]

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