| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> Re: Shell scripting
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 <ORACLE-L_at_fatcity.com>
<cyril_thank_at_redif cc:
fmail.com> Subject: Shell scripting
Sent by:
root_at_fatcity.com
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: cyril_thank_at_rediffmail.com 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: ListGuru_at_fatcity.com (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: okhalid_at_lmkr.com 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: ListGuru_at_fatcity.com (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).Received on Mon Oct 07 2002 - 00:53:27 CDT
 |
 |