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: Oracle sqlldr, load fields and a constant value?

Re: Oracle sqlldr, load fields and a constant value?

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Fri, 29 Apr 2005 23:20:37 +0200
Message-ID: <q79571t6tr4i8rrc64j4ug0864797ep51r@4ax.com>


On 29 Apr 2005 13:31:05 -0700, "Jackson" <x10deep_at_yahoo.com> wrote:

>Hello,
>
>Using Oracle sqlldr to load values into a table, I would also like to
>load a constant (the filename of the file) into the table as well, is
>this an easy thing to do? Would someone have a quick sample?
>
>Thx!

Not possible without editing the controlfile, for the exact syntax refer to the link Michel Cadot posted.

--
Sybrand Bakker, Senior Oracle DBA
Received on Fri Apr 29 2005 - 16:20:37 CDT

Original text of this message

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