Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: SQL LOADER - CONDITIONALLY LOADING DATA
Karla D. McGhee wrote:
> I need to load a text file into Oracle conditionally based on the
> contents of a one-byte character field. When this field is equal to
> 'E' or 'F', the data should be loaded. The When clause does not permit
> the use of OR conditions. If someone has a suggestion, please email
> me. Thank you.
Does your Oracle have a version? If 9i ... use an external table instead.
-- Daniel Morgan http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp damorgan_at_x.washington.edu (replace 'x' with a 'u' to reply)Received on Tue May 04 2004 - 18:10:14 CDT