Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.tools -> Re: SQL*LOADER different types of records

Re: SQL*LOADER different types of records

From: K <kristofvdw_at_matt.es>
Date: 24 Oct 2004 23:27:23 -0700
Message-ID: <ef74fcf7.0410242227.7b9c398d@posting.google.com>


Hi Turkbear,

Thanks for the suggestion, however there's the possibility the records to be loaded also contain NULL values, so counting those won't work...

K

Turkbear <john.g_at_dot.spamfree.com> wrote in message news:<1098452343.sDm7k0D8L47esTVvBexh2Q_at_teranews>...

> I am not sure you can with SqlLoader..
> You could create an interim table with the number of columns equal to the maximum # of fields that can be in the load file
> and set the default value of all the columns to NULL.
> After loading the data use the NULL values to test as to which table to insert the records into..
>
> Like
> Update table3 select c1,c2,c3 from interim_table
> where c4 is NULL and c5 is NULL;
Received on Mon Oct 25 2004 - 01:27:23 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US