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!