Re: SQL*Loader - deriving column from read rows

On 6 Mar 2001 19:12:24 GMT, hanton32_at_hotmail.com wrote:

>
>I am loading a file using SQL*loader (Personal Oracle 7.2 for Win 95)
>that looks like this :
>
>0header source1
>1details
>1details..
>0header source2
>1details
>.
>
>What I would like to do during the load is add a new column to the detail
>records. So that my loaded table will have source as the first column and I
>can then distinguish the detail records and their source.
>
>
>any ideas appreciated!
>
>thanks
>hani
>
>

This could be accomplished by reading the Oracle Server Utilities Manual or by writing a trigger.

Hth,

> ----- Posted via NewsOne.Net: Free (anonymous) Usenet News via the Web -----
> http://newsone.net/ -- Free reading and anonymous posting to 60,000+ groups
> NewsOne.Net prohibits users from posting spam. If this or other posts
>made through NewsOne.Net violate posting guidelines, email abuse_at_newsone.net

Sybrand Bakker, Oracle DBA Received on Tue Mar 06 2001 - 13:32:49 CST