Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> WHEN OTHERS DO NOTHING
Hi,
I d like to load a table with sqlloader.
The file has a header and a footpage.
So, what i am looking for is a thing like
DEFAULTIF
DO NOTHING
I managed to write the when statement that checks if is the body,
the footpage or the header. But i do not know how to ask him to do
nothing.
Obviously, if i only write the when statement for the body, the exit code won't be zero, and i need to know if the load has been successful.
Thx in advance
Antoine
Received on Sun Jul 07 2002 - 04:27:58 CDT