Hi All,
I am trying to use sqlldr to load a csv file. From this data i need to check if a perticular column say col3 value data exists in a table, if so load this data.
i am trying to call this function to load the data,
The code which i have used. This loads the data but the problem is i am unable to skip the records using col3 for which the there is no records in table.
Can you please help me out on this.
Also is there a way i can use the function or select statement in when clause?
load data
infile '/data/test.dat'
truncate
into table 'test'
fields terminated by ','
trailing nullcols
(
col1
col2
col3 "func_val(:col3)"
col4)