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 query to OS file */
#!/bin/sh
CMD_FILE=sql_input.sql
LOC_FILE=output.log
SQLCMD="connect internal ;
select * from sys.dba_users ;"
echo "$SQLCMD" > ${CMD_FILE}
svrmgrl < ${CMD_FILE} > ${LOC_FILE} /* redirecting the out of
svrmgrl to OS file */
regards
'_-_'_-_'_-_'_-_'_-_'_-_'_-_'_-_'_-_'
Omar Khalid
Software Engineer
LMK Resources
Voice: 111-101-101*780
Mobile: 0333-510-4465
Web: www.lmkr.com
'_-_'_-_'_-_'_-_'_-_'_-_'_-_'_-_'_-_'
"Cyril
Thankappan" To: Multiple recipients of list
ORACLE-L <[EMAIL PROTECTED]>
<cyril_thank@redif cc:
fmail.com> Subject: Shell scripting
Sent by:
[EMAIL PROTECTED]
10/04/2002 09:18
PM
Please respond to
ORACLE-L
Hi
I wanted to select a column from a v$ table
struggled with it
and finally came with a workaround as follows
------------------------------------
archived_log='$archived_log'
begin_seq=`sqlplus -s /nolog <<EOF
connect / as sysdba
set head off
set echo off
set feedback off
set verify off
select max(sequence#)-1 from v$archived_log ;
exit
EOF`
echo $begin_seq
---------------------------------------
However, the question is how to
'directly' take the output into a shell variable?
there 'shud be' a better workaround than this !
Thanks
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Cyril Thankappan
INET: [EMAIL PROTECTED]
Fat City Network Services -- 858-538-5051 http://www.fatcity.com
San Diego, California -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Omar Khalid
INET: [EMAIL PROTECTED]
Fat City Network Services -- 858-538-5051 http://www.fatcity.com
San Diego, California -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
