-
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
-
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
-
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