Sql Loader - input data
Date: Wed, 15 Sep 1999 14:11:33 -0400
Message-ID: <37DFE155.DF32BFA8_at_tstnet.com>
Oracle 8.0.5
I am familiar with Oracle from a development standpoint but I do not use the tools very often. We are porting a process/application from Sybase to Oracle. Sybase has the bcp (bulk copy) utility that allows me to do the following - I have been investigating Sql Loader and need help with these:
Can Sql Loader recognize a delimiter that is more than one character? I have an input file that uses a three character delimiter between each field.
I need to read a record that is variable length, no assumptions can be made about carriage return/line feed (not necessarily end of record), and uses the three character delimiter as stated above. The records do not have the character count at the beginning of the record like Sql Loader wants with the variable record format (these files are provided to me, I do not create them). Is there any way to get the data in without having to change the file?
One field in the record can be very long ( >1024 characters) and will should be inserted into a long char or clob field. Can Sql Loader handle fields of that length?
I am using the html and pdf documentation provided on the Oracle CD. Any help or hints will be appreciated.
Bret Received on Wed Sep 15 1999 - 20:11:33 CEST