has the RDBMS the function of dry run
originally posted by User199411 (but as a Document)
Some person in their company only has the query privilege of the production database, while they need assure the correctness of the scripts in production enviornment.
Of course, these scripts will be tested in testing environment before they go into the production. However, there always are some difference between testing enviornment and production enviornment.
If Oracle database has this functionality, we can execute this scripts on the production enviornment to test these scripts while these scripts will not take into effect in fact.
Some person in their company only has the query privilege of the production database, while they need assure the correctness of the scripts in production enviornment.
Of course, these scripts will be tested in testing environment before they go into the production. However, there always are some difference between testing enviornment and production enviornment.
If Oracle database has this functionality, we can execute this scripts on the production enviornment to test these scripts while these scripts will not take into effect in fact.
0