OraFAQ Forum: Unix » How to send an sqlplus output to shell variable

Home » Infrastructure » Unix » How to send an sqlplus output to shell variable

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

How to send an sqlplus output to shell variable [message #137767]

Fri, 16 September 2005 11:59

sinbyrne
Messages: 2
Registered: September 2005

Junior Member

Hi I am running the following bsh script.

sqlplus -S $elw_id/$elw_password@uat << STOP > S1

set heading on pagesize 100 linesize 100 tab off
set feedback off
Select count(*) from cv_welcome where market = 'SFE'
/
quit
STOP

this sends the output to a file S1 in my working directory.
What I really want is to send this to a shell variable.

Any ideas?

Thanks

[Updated on: Fri, 16 September 2005 12:00]

Report message to a moderator