Return a result from SQL*Plus to Unix variable
$ cat a.sh
#!/bin/sh
var="set pagesize 0
select * from v\$instance;"
nad=$(print "$var" | sqlplus -s "/ as sysdba")
echo $nad
$ a.sh
1 mydb_name myhostname 9.2.0.6.0 16-MAY-06 OPEN YES 1 STARTED ALLOWED NO ACTIVE PRIMARY_INSTANCE NORMAL
0 Comments:
Post a Comment
<< Home