Sure
THanks Omar
But I was looking for a
'non-file based' solution :)
Thanks anyway
On Mon, 07 Oct 2002 Omar Khalid wrote :
hi
well i think i did this once, you can read
the output of the SQL query into shell variables by
first redirecting the output of the SQL query to an
OS file and then
Omar,
If what you mean is:
How do I send a value from sqlplus plus directly
to a variable in my shell environment?
You can't.
What you've done is the way it is usually done.
Another way to do it is to use the '|' korn shell mechanism.
e.g.
sqlplus -silent scott/tiger@$ORACLE_SID |
This
Actually Jared, you can by setting up a sqlplus coprocess and using unix
pipes. The routine below will get a parameter from the v$parameter table
using sqlplus.
Kevin
===
get_db_parm()
{
unset vRETURNED_PARM
unset vRESPONSE
typeset -u vPARM
ORACLE-L [EMAIL PROTECTED]
cc:
Subject:RE: Re: Shell scripting
Actually Jared, you can by setting up a sqlplus coprocess and using unix
pipes. The routine below will get a parameter from the v$parameter table
using sqlplus.
Kevin
: Shell scripting
Actually Jared, you can by setting up a sqlplus coprocess and using unix
pipes. The routine below will get a parameter from the v$parameter table
using sqlplus.
Kevin
===
get_db_parm()
{
unset vRETURNED_PARM
unset vRESPONSE