I'm not a sqlloader expert, so take with a large grain of salt. If you are
using conventional path, a series of 'insert' statements are executed. This
may cause the & to be interpreted as the variable indicator. If you are
using direct path, it may create a block of rows and then directly place
th
Terry,
I tried the following in 817 and it worked fine:
LOAD DATA
INFILE *
INTO TABLE test
REPLACE
FIELDS TERMINATED BY ',' TRAILING NULLCOLS
( col1 char ,
col_seq "test_seq.nextval"
)
BEGINDATA
'o&ne',
'two',
(sorry about the first email - fingers slipped!)
Do you get an error in the
Thanks for all the help. It turns out there was a problem with the data and
the field seperator was part of the data in one of the fields.
-Original Message-
Sent: Friday, July 26, 2002 10:33 AM
To: Multiple recipients of list ORACLE-L
I am trying to load data via sqlldr (8.1.6.3 on S
Fax to:
Subject: Re: SQLLDR
Question
05/24/2001 11:31 AM
You can combine two data fields into one column with sqlldr, but I think both
fields have to be in the table.
Example:
SQL> desc x
Name Type
-
TRANS_DATEDATE
F1CHAR(8)
LOAD DATA
INFI
Since those are the last two fields in the data file, I think you can
use TERMINATED BY WHITESPACE on the field definition. Something like:
trans_date date(14) "mm/dd/yy,hh:mi" terminated by whitespace
> -Original Message-
> From: srcdco [mailto:[EMAIL PROTECTED]]
> Sent: Wedne
Thank you to everyone who responded to my request. I guess it's just a
limitation of sqlldr that it can't handle this without modifying the data.
Unfortunately, I can't have the source change their download, so I have to deal
with the data as I get it.
I did come up with a way to get arou
Can you remove the comma between date and time to make it 1 field?
Simon Fox
Room 205, CRH
01270 533997
-Original Message-
Sent: 23 May 2001 22:41
To: Multiple recipients of list ORACLE-L
I am trying to load a file that has the fields comma-delimited,
variable length. A sample l
Instead of trying to do this in SQL Loader, why not just
try to clean up the data?
This can be done at least 2 methods:
1. Get the sender to send it to you properly
2. clean it up yourself.
The following Perl script will do it
Jared
#!/usr/bin/perl
m