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,
Content-Disposition: attachment; filename=... not working as i thought it should
taken the following code from the php.net site the script is not working.what is not happening is the file does not show and also the file download does not show the correct file name it seems to have
Undefined variable: adHTML
Hello:While checking my site error logs, I've noticed one repetitive error that fills the log file. The error is "PHP Notice: Undefined variable: adHTML in /.../bot_jrheader.php on line
Problem with array max size.
Hi to everyone,
how to get sn motherboard
Hello.
subtract 1 from value entered in text field
HiHow do I subtract 1 from the vaue entered into a text field?Thanks
Recode Abap Dynpro into Web Dynpro
Hi All,
shift numbers with paging
HiHow would i be able to display 10 numbers 1 2 3 4 5 6 7 8 9 10 and when I click next then 2 3 4 5 6 7 8 9 10 11 and click next then 3 4 5 6 7 8 9 10 11 12are displayed.i am using a for loop to echo
Consuming third party Payment Gateway API from Procedure.
Hi All,
Undefined index on my form
ok im getting Undefined index on this line.. print_r($_REQUEST['form']);below is the full script its formCode: <?phpini_set("display_errors",
Results from Db outputted twice
Hey guys.. for come reason my data is outputted twise shown in the image below and i cant figure out why.Code: [Select]<html><head><title>Month
