-
Sql Loader issue - loading 2 values into a column
i have a .csv file as below:
john,australian
smith,australian
mary,"australian,irish"
this needs to be loaded into the table with 2 columns
firstname nationality
--------- ----------
john australian
smith australian
mary australian
mary irish
my control file is as below:
load data
infile '/home/oracle/sample.csv'
insert into abc
(firstname,nationality)
which gives me the result:
firstname nationality
--------- ----------
john australian
smith australian
mary "australian
Is it possible to insert 2 records for mary, 1 for australian and 1 for irish using sql *loader.
please advise....Thanks!
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|