Re: UNIX and sqlplus

"Mike Tinney" <michael_tinney_at_hp.com> wrote in message news:<aokbtn$b3n$1_at_web1.cup.hp.com>...
> I looking for the correct syntax or a easy way to do a select from a remote
> system on UNIX to be used via a sqript.
>
> Listed below is the current syntax that I have but I can't get it to work.
>
> Is there an easier way to include the sql script file in the original
> script? or should I have it on the remote system ?
>
>
>
>
> remsh entorap -l ods_dba -n ". /u01/entitle/app/oracle/.profile \;
> sqlplus -s system/passwd < queue_count.sql" >

You need sqlplus -s system/passwd @queue_count.sql

> /opt/apache_sd/cgi-bin/count.log 2>&1
>
> Thanks
> Mike

There is also shell trick like:

sqlplus -s system/passwd << EOF
sqlplus commands
and/or sql statements
EOF I think this is the answer to your question. Received on Fri Oct 18 2002 - 09:49:57 CDT