Re: SQL Loader question
Date: Wed, 03 Mar 1999 14:44:39 GMT
Message-ID: <7bjhsk$3sb$1_at_nnrp1.dejanews.com>
In article <36dc297b$0$24066_at_newton>,
"Arjan van Bentem" <avbentem_at_DONT-YOU-DAREdds.nl> wrote:
> Scott Mattes wrote
> >Here is the line where I get the error
>
> > "EST-LABOR-COST-01" POSITION (209:217)
> > Decimal External ":EST-LABOR-COST-01 / 100"
>
> It seems to me you have dashes in the column names? Did I miss something, or
> are dashes simply not allowed in a column name?
<SNIP>
I was very surprised to read that this is a legal name in Oracle. Ya learn something new every day...
You need the quotes around the field name, but preceded by an escape character. Try:
"EST-LABOR-COST-01" POSITION (209:217) DECIMAL EXTERNAL
":\"EST-LABOR-COST-01\"/100"
Howard Parks
1 Peter 4:10
-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Wed Mar 03 1999 - 15:44:39 CET