| How to get number of rows deleted from SQL in a shell script [message #124862] |
Tue, 21 June 2005 20:29 |
skandru
Messages: 1
Registered: June 2005
|
Junior Member |
|
|
Hi
I am calling a sql script using sqlplus in a shell script.
It looks like below,
result=`sqlplus $ORA_LOGON@$ORA_SID @ $SCRIPT_FILE < /dev/null > /tmp/clean_event.log 2&`
Basically the SCRIPT_FILE has a sql, which deletes rows from a table basing on a condition.
Question:
How do I get the number of rows deleted from the sqlplus output?
I would like to display the number of rows deleted from the table in the shell script.
Thanks,
Syam
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
