Search Results

Hi,
I have a unix varaible called as account which hold values which i want to use in a PL/SQL block in a shell script.
This variable value is being used in multiple places in the PL/SQL block and...

Hi all,
I have written a script which stores data along with requisite dates in a file.
I need to compare the stored date values in the file to obtain the row with the highest date value i.e. the...

Hi Smith,
Sorry for the late response.
First things first i need to thank you for the timely help.
Yes you are write it works and the reason for the same is cause sqlplus runs in silent mode i.e....

i tried the script attached by you.
And it worked thanks a lot!!!!!!!!
By the way Jsmithstl i would be highly obliged if you can tell me what part of the code provided by you prevented the query...

Hi Jsmithstl,
I am using spool command to write the output of the query in a file
But Query appears in the file along with the Query output.
I just want the output of the query in the file.
Ex:...

Hi all,
I am executing a Oracle SQL statement in a shell script and spooling the output of the query into a File with spool command.
I want to ensure that only output of the query appears in file...