SQL*Loader custom command line arguments

[stogpon]

Hi

I want to be able to use SQL*Loader to enter some data in a table. I
want to enter into the table, data supplied from the command line or
taken from the actual datafile filename string.

Is this possible?

Thanks

[DA Morgan]

stogpon wrote: Hi I want to be able to use SQL*Loader to enter some data in a table. I want to enter into the table, data supplied from the command line or taken from the actual datafile filename string. Is this possible? Thanks

No. Wrong solution. One row at a time is hardly appropriate for
SQL*Loader.
--
Daniel A. Morgan
http://www.psoug.org
damorgan@x.washington.edu
(replace x with u to respond)

[Hans Forbrich]

On Mon, 17 Oct 2005 08:42:09 -0700, stogpon interested us by writing:
Hi I want to be able to use SQL*Loader to enter some data in a table. I want to enter into the table, data supplied from the command line or taken from the actual datafile filename string.

Assuming a currently supported version of Oracle, sure. No problem.

It's called 'External Table' and your 'comnmand line' is simply a SQL
statement in SQL*Plus.

More on HOW is available in the Utilities document available for the
version in question.

--
Hans Forbrich
Canada-wide Oracle training and consulting
mailto: Fuzzy.GreyBeard_at_gmail.com
*** I no longer assist with top-posted newsgroup queries ***