| loading data into multiple tables , help [message #228134] |
Sun, 01 April 2007 06:02  |
aboodlardy
Messages: 80
Registered: November 2006
Location: India
|
Member |
|
|
HI
i am trying to load data from a flat csv file into two different tables using when clause but it gives me the error
CONTROL FILE:
load data
infile 'e:\softwares\inr_rates.csv'
insert into table scott.bti
when(rupeeval < 0)
fields terminated by ','
(country_name,rupeeval,inind)
TARGET TABLE:
Name Null? Type
----------------------------------------- -------- ----------------------------
COUNTRY_NAME VARCHAR2(25)
RUPEEVAL NUMBER
ININD NUMBER
ERROR:
E:\>SQLLDR SCOTT/TIGER CONTROL=AA.CTL
SQL*Loader: Release 9.0.1.1.1 - Production on Sun Apr 1 16:31:00 2007
(c) Copyright 2001 Oracle Corporation. All rights reserved.
SQL*Loader-350: Syntax error at line 4.
Illegal combination of non-alphanumeric characters
when(rupeeval < 0)
^
I WANTED TO INSERT THOSE ROWS ONLY WHOSE RUPEEVAL IS less THAN ZERO.
please help
regards
abood
[Updated on: Sun, 01 April 2007 06:03] Report message to a moderator |
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
