Shell Programming and Scripting

Hi,
Could anybody help me how can I assign the value of "select count(*) from table1" to a variable in an unix shell script. Thanks.

Hi,

Please show us a little example scripture.
Don't know exact what you want

input= `shell statement `

for i in $input
do
....

done

Is a handout.


Regs David

You can pass back the value from a PL/SQL block by setting a variable equal to the count from your table. You then exit your block with the variable. Search the boards for PL/SQL and you will find a few examples.

If you want a quick way to do this, after you log into your database and before you execute your Select statement, spool a file. After you close your session you can then have your shell script parse the spool file for the count. Also note that there are a number of options in Oracle (assuming your using it) to turn off headings and such so your spool file is a bit more clean.

#!/bin/sh
COUNT=`sqlplus -s system/manager <<ABC
set head off;
select count(*) from table1;
exit;
ABC`

That script works, but it assumes that he is using Oracle. Anyway, this type of assignment should work for most databases. You just replace the "sqlplus" line with whatever database command line tool you use. For example, in mysql, it would be something like 'mysql -Ddbname -u username -ppassword'. The concept is the same, thought.