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

Filling gaps in dates
So i'm doing a query for sales data and my return array looks like this

('date' => '20

php and downloading
I want to use a php script to create two files. Then I want it to redirect (or whatever) to have tho

Printing a webpage
I use this to print the webpage: o

Help: problem with Headers to download PDF file
Hi,

I'm trying to implement a script where when a user clicks a link he gets a PDF file to op

keeps going back to index.html ???????
ok so i started making my site using mostly.html files now i have added a fair chunk of php. My inde

cookie problem
I hv a website url
In this site main menu functionality based on cookie when user click on parti

php redirecting
i wont open a new thread but i have a question about redirecting....
i wonder why my code doesnt

DirectoryIterator and Hacked Website
Hi Everyone.

My problem:
Some one has been sneaking in to my website hidden Iframes. I've

php require help needed
Ok i tried to use the search funtion but the word require is everywhere.

i'm really new to cr

Not Inserting into DB
I can't get my Add new Division form to submit to the database. Anyone see my issue?

Code: &a