Hi ,
We are using Oracle 10g DB in our project,i would like to validate the results from the application against the DB.
Could you please provide a sample code to do this.
Appreciate your help!
Thanks,
Anto
Hi ,
We are using Oracle 10g DB in our project,i would like to validate the results from the application against the DB.
Could you please provide a sample code to do this.
Appreciate your help!
Thanks,
Anto
Anto-
I would think you would want to execute a query from the command line and redirect the output to a flat file. You can then diff this file with a known file or you may be able to loop through the file and validate the file from there as well.
From the command-line you can redirect your sql file into a sqlplus command that will cause it to execute and exit sqlplus leaving you just the output in a file.