My requirement is to insert the data to a different table if the two rows are same. So, I need to to compare the data of the two rows. Is this possible?
Is there anyway to compare two rows of data inside the control file of sql loader.
For eg:
I have a data file like this
"Tom","Cat"
"Tom","Cat"
"Jerry","Mouse"
"Pluto","Dog"
In the control file, I want to check...
Is it possible to pass parameters to the sqlloader and use them inside the control file?
something like,
>sqlldr .... empid=123
and inside the control file, i want to use the empid to be inserted to a table.
How can I use it inside the control file along with LOAD DATA?
thanks in advance,
cidoni
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.