4 Replies Latest reply: Feb 26, 2013 12:36 PM by TSharma-Oracle RSS

    How to validate SQL was run on the database

    Krishna Nazare
      Hi,

      We are looking for validating our product upgrade changes.
      As part of product upgrade, there will be changes to the schema.
      Like addition of tables, addition of columns to existing tables, change the length of character columns, add new index, etc.
      We want to verify on the database, that these SQL are run successfully on the database.
      Is there a table/view, that can be queried to figure out whether such sql was run and the status of the execution, after some time (day or two) after these are actually run on the database.


      Thanks,
      Krishna