Re: Conditional Import with SQL LOADER
Date: Wed, 11 Apr 2001 10:34:18 GMT
Message-ID: <Xns908075B813E5ETweetiePooh_at_62.253.162.109>
"Jeff Boyer" <jdboyer_at_(remove)icomproductions.ca> honoured comp.databases.oracle.tools on Tue 10 Apr 2001 03:23:59p with <9av5fk$i3$1_at_news3.cadvision.com>:
> Here is a good questions I hope someone can answer. Is it at all possible
> to import a file with SQL Loader (or any other tool) but put conditions on
> the import. For example, I have been given a database from a client that
> they want imported into my Oracle database. However, this database has a
> field that is Called SIC_CODES. The client wants me to map the SIC_CODES
to
> the existing Categories. What this means is that during an import I need
to
> be able to say If SIC_CODE = 4456 then Category = Applience Repair. Is
this
> at all possible to do? I have never done something like this in the past
> and don't even know if it can be done.
>
> Thanks again,
> Jeff
>
>
Sound more like a job for using the relational part or RDBMS.
Use a second table to map SIC_CODE to category then don't bother with category in the table. Received on Wed Apr 11 2001 - 12:34:18 CEST