Re: Calling sqlplus or plsql code from ksh

Check out the sqlplus line

sqlplus -s >/dev/null 2>&1 "monitor/oramon" <<EOF

   whenever sqlerror exit 1
   select * from dual;

• If we can not connect or select, we will not return 0!!! exit 0 EOF

More scripts here
http://www.orafaq.com/scripts/index.htm#UNIX

<capitaldog_at_hotmail.com> wrote in message news:cc72d8ab.0402191948.49c839c8_at_posting.google.com...
| Can you guys show me some of the ways to run sql code from ksh scripts.

|