Friday, 7 October 2011

Shell Script: SQL:How to Assign value to shell variable

PID=`sqlplus -s $1@$INST <<
whenever sqlerror exit 1
set escape off
set head off
set verify off
select oracle_process_id from fnd_concurrent_requests where request_id=$5;
`

No comments:

Post a Comment