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

Home -> Community -> Usenet -> c.d.o.server -> Re: relative positioning in sql loader

Re: relative positioning in sql loader

From: Mark Malakanov <markmal_at_delete-this-antispammer.home.com>
Date: Thu, 26 Apr 2001 04:41:43 GMT
Message-ID: <bGNF6.62132$_P.16699645@news3.rdc1.on.home.com>

Use CONCATENATE 54 if you want to make 1 logical record from 54 physical rows.
See examples (*.ctl) in $ORACLE_HOME/rdbms/demo

--
-----------------------------------------------------
Thanks,
Mark

"Sanjay K Singh" <sanjay_at_vimich.com> ÓÏÏÂÝÉÌ/ÓÏÏÂÝÉÌÁ × ÎÏ×ÏÓÔÑÈ ÓÌÅÄÕÀÝÅÅ:
news:9c6k0901i1g_at_enews4.newsguy.com...

> I am using sql loader for for loading data from a text file. My physical
> record has 54 record and that will make 1 logical record. I want to use
> relative positoning for that. Otherwise my program will be complex. can
some
> body give me an example of that.
> Thanks
> Sanjay
>
>
Received on Wed Apr 25 2001 - 23:41:43 CDT

Original text of this message

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