Re: Pipe some stuff to SQLPLUS

In article <44bjo6$9qd_at_tst.hk.super.net>, 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

In my overnight run, I use:

sqlplus -s user/password <<END!

   _at_sql_script_name
END! Is that what you wanted?

Regards, Nick Received on Wed Sep 27 1995 - 00:00:00 CET