Getting number of affected rows in SQLPLUS..

Posted on 16th Feb 2014 07:03 pm by admin

Hi everyone,
I have a shell script where i am invoking sqlplus, running a query and saving the result in a spool file in a .csv format. Now this file has a trailer that contains
number of rows selected. So i cant use SQL%ROWCOUNT and i dont know how to get that number.
Someone has given me a idea to wc line count the file and append it as a trailer, but i cant do that as in the trailer line i have to display a number that is a oracle
sequence. The file format will be something like this ---

01,Test,5667889,9999999,AXCCRTR1
000001,TESTSOURCE,1 ---------------> This is the trailer (oracle_seq,constant varchar,no of rows selected)

Is there any way i can get the number of rows affected by the previous query in sqlplus. Any help will be greatly appricaited.
I can go ahead and do it with Pl/sql but i'll not quit untill i am absolutely sure thery no way out for this.

Thanks,

Your Answer:

Login to answer

Other forums

order by date not ID number help php
I am trying to orginize the following code to order by date not id number.
any help would be grea

php calculate
this code echoes correctly the sum but the inserted result is 0??
Code: <?php
$TotalNum

search function
HI guys,

if anyone could point us in the right direction of how to do this, or provide some t

imap: how to save a copy of sent emails to sent elements
Hello my friends,

I am writing an online emailing application with inbox outbox/sent elements

Wierd if else problem
Hi guys,

this probably aint wierd for you, but it seems like php is playin up to me. may b i

IS this code correct
The reason i ask is everything underneath it appears to be alink as well, tis blimmin annoying

New Login Script
Hi all, i attempted to create a whole new login script witch isnt working for some reason i dont kno

Find current logon time
Hi,
in my sql script i want to query and find out the logon time of the current session.
<

parameter passing issue on function
Well I thought I had created a pretty slick web page, using ?page and $_GET to load pages which wher

quick question about System Change Number(SCN) in FlashBack Query topic
i know tht we can get the SCN of the database using flashback concept as follows

SQL>