Re: Calling sqlplus or plsql code from ksh

ops, I meant how would you retrieve the data not the date.

Thanks Again,
Dog

Stephan Bressler <sbresslerx_no_spam_at_arcor.de> wrote in message news:<c14cn3$kdf$1_at_news.mch.sbs.de>...
> > sqlplus -s >/dev/null 2>&1 <<EOF
> > monitor/oramon
> > whenever sqlerror exit 1
> > select * from dual;
> > -- If we can not connect or select, we will not return 0!!!
> > exit 0
> > EOF
> >
> Or this way:
> sqlplus -s /nolog >/dev/null 2>&1 <<EOF
> connect monitor/oramon
> _your_sql_statements_
> EOF
Received on Sun Feb 22 2004 - 18:10:38 CST