Re: Pipe some stuff to SQLPLUS

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:
>
>>Hi,
 

>> I would like to know how can I use sqlplus non-interactively......
 

>> I have tried the following, but I can't get anything!!!!
 

>> echo "some sql statement;" | sqlplus user/password
 

>> sqlplus user/password < "sql statements file"
 

>> Thanks
 

>>Chi-Chung
>
>Try sqlplus user/password _at_<sql statement filename instead.
>
>

Actually

       sqlplus user/password _at_filename

will be just fine...(don't need the '<' )

Chris Received on Fri Sep 29 1995 - 00:00:00 CET