| v$table [message #57924] |
Fri, 18 July 2003 23:33 |
EJ File
Messages: 1
Registered: July 2003
|
Junior Member |
|
|
Hi. In this example, it works if the table is a regular one (t1), but when i select from a v$table, for example, v$session, it's giving me error. i tried putting v$session, still it would not work. Thanks for your help.
#!/bin/sh
#!/bin/sh
VALUE=`sqlplus -silent "user/password@instance" <<END
set pagesize 0 feedback off verify off heading off echo off
select max(c1) from t1;
exit;
END`
if [[ -z "$VALUE" ]]; then
echo "No rows returned from database"
exit 0
else
echo $VALUE
fi
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
