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 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).
--
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).
