Re: sql*loader and stdin?

From: Volker Hetzer <volker.hetzer_at_ieee.org>
Date: Mon, 09 Jan 2006 21:29:38 +0100
Message-ID: <dpuh3j$4on$2_at_nntp.fujitsu-siemens.com>


Maxim Demenko wrote:
> Volker Hetzer schrieb:
>

>> Hi!
>> Is there any way I can make sql*loader read data from stdin?
>>
>> Lots of Greetings!
>> Volker

>
>
> You have to properly quote the stdin:
> On unix works both
> cat load.dat|sqlldr control=load.ctl userid=user/password data=\"-\"
> cat load.dat|sqlldr control=load.ctl userid=user/password data=\'-\'
>
> On windows
> type load.dat|sqlldr control=load.ctl userid=user/password data=\"-\"
>
> Alternative (for both , unix and windows)- infile syntax:
> --------------
> load data
> infile "-"
> into table...
> --------------
>
> Metalink note 191043.1 may be interesting for you as well.
Wow, that did it!

Thanks a whole lot (and also thanks to all who replied)! Volker Received on Mon Jan 09 2006 - 21:29:38 CET

Original text of this message