Re: Pipe some stuff to SQLPLUS

In article <44grcf$rh8_at_newsbf02.news.aol.com>, Kasten10 says...
>In article <1995Sep27.152512.2956_at_lamont.ldgo.columbia.edu>,
>anarayan_at_sctcorp.com (Ananta Narayanan) writes:
>>chichung_at_hk.super.net (Mr Chung Chi Wong) wrote:
>>> I have tried the following, but I can't get anything!!!!
>>> echo "some sql statement;" | sqlplus user/password
>>> sqlplus user/password < "sql statements file"
>>Try sqlplus user/password _at_<sql statement filename instead.
>Actually
> sqlplus user/password _at_filename

some_command | sqlplus should work, if your O/S supports it (does MSDOG?). sqlplus < some_file should work, as above.

sqlplus _at_some_file should work.
sqlplus _at_<some_file is wrong.

The third version is different from the first two in the way that things like accept work: the first two will accept the data from the pipe or file (as appropriate). The third will ask the user.

-- 
 _________________________   __________________________________________
/  Tommy Wareing          \ /  I've been looking for an original sin,  \
|  p0070621_at_brookes.ac.uk  X   One with a twist and a bit of a spin    |
\  0865-483389            / \     -- Pandora's Box, Jim Steinman       /
 ~~~~~~~~~~~~~~~~~~~~~~~~~   ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~