Re: Return value to ksh variable

Just make sure sure headings are off and you use the -s (silent) switch and exit from the script
so :
the following script envvar.sql
set heading off

select * from dual;
exit

and the following commandline ret = (sqlplus -s scott/tiger @envvar) should return an X in $ret.

Hth,

Sybrand Bakker, Oracle DBA

On Sat, 25 Sep 1999 23:20:44 +0800, KC <kcheung_at_poboxes.com> wrote:

>Hi all,
>
>Is it possible to return values queried in SQL*Plus to a korn shell
>variable ?
>
>Thanks,
>Kevin
>
Received on Sat Sep 25 1999 - 10:31:04 CDT