Re: URGENT: SQL LOADER Question: Setting multiple columns from one record in dat file

"navneet" <reply1909_at_gmail.com> wrote in message news:1148455474.817981.294110_at_38g2000cwa.googlegroups.com...
> HI ALL
>
> I am in middle of something and any help is sincerely appreciated.
>
> I have a table with 4 cols,
> col1, col2, col3...col4
>
> and dat file is
> ABC|XYZ
>
> Ctl file " LOAD DATA IN ................................(COL1, COL3)
>
> Q..Can anybody suggest how to SET it so that
> ABC goes to both col1, col2
> XYZ goes to both col3 , col4
>
>
> Thanks a lot for help.
> navneet
>

( COL1,
  COL2 ":COL1",
  COL3,
  COL4 ":COL3"
)

For more details check out Oracle Utilities reference guide for your release.

-- 
   Vladimir M. Zakharychev
   N-Networks, makers of Dynamic PSP(tm)
   http://www.dynamicpsp.com