SQL*Loader - deriving column from read rows
From: <hanton32_at_hotmail.com>
Date: 28 Feb 2001 15:55:11 GMT
Message-ID: <97j70v$c5r$1_at_news.netmar.com>
Date: 28 Feb 2001 15:55:11 GMT
Message-ID: <97j70v$c5r$1_at_news.netmar.com>
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
- 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