How to store SQL output in a variable

atulsh · 09-18-2008, 12:36 PM

Hi,

I am writing a script which has the following SQL query:-
echo -e "select count(*) from aetbs_process_progress where status !='S'and PROCESS!='MarkEoti' and STARTTIME='$DATE1'" >> $PGM1

I am running this query as follows in the later part of script.

sqlplus $ORACLE_USER/$ORACLE_PASSWORD @$PGM1

How can I store the output of @$PGM1 in a variable and match it in the if condition?

Thakns,
Atul

paulsm4 · 09-18-2008, 01:22 PM

Hi -

You can use back-quotes (any shell) or "$()" (Linux BASH), e.g.

Code:

  A=`echo abc`
  echo $A
	Quote:
	
	
		
			
				abc
			
		
	
	
  A=$(echo def)
  echo $A
	Quote:
	
	
		
			
				def

In your case, just substitute "sqlplus" for the "echo abc" in my example. Here are a couple of links:
http://www.linuxtopia.org/online_boo...ommandsub.html
http://rand-mh.sourceforge.net/book/mh/comsub.html