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!

Thanks,
Anto

Comments

  • 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.
Sign In or Register to comment.