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
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 reading the file and loading
the data in the file into shell variables.
/* here is sample code to redirect the output of sql
On Thu, 22 Feb 2001,John Dailey scribbled on the wall in glitter crayon:
-so I do not have to manually type in the password? Here's the command:
-
-rexec nt_machine -l user e:\\top_dir\\ev00_07\\run\\batch_script.bat
have you tried:
rexec nt_machine -l user
check out this link for some info
www.datafocus.com/docs/man1/rexec.1.asp
-Original Message-
Sent: Thursday, February 22, 2001 7:36 PM
To: Multiple recipients of list ORACLE-L
Forgive me if this a stupid question and unrelated to Oracle but it pulls
data from an Oracle database and i
Yep... that's what I get for taking someone's word. I got handed this
problem after everybody else gave up on it... all I heard was "man pages
didn't tell us anything"... HAHAHAHAHA -- my insane laughter now
Anyway, thanks to all who responded to my query... Bill, Ganti, and the user
below