How to connect to oracle DB and validate the results

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!



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.