SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Simulation of change code(DDL,DML or Package etc) before execution

3149569Jan 15 2016 — edited Jan 15 2016

Hi All,

I have following requirement:

I want to run any production code change in 2 phases that is either RUN mode or SIMULATE mode.

+ First, I want to run code change in simulate phase and in this phase, I want NO EXECUTION but just to analyse the affect of change code. I want to know what all it is affecting in this phase. If affect looks fine then I will go to next RUN phase.

+ Then I will execute same code in RUN phase which will implement change in Production.

Please provide your suggestions in this regard.

Thanks,

tejinder

Locked Post

New comments cannot be posted to this locked post.

Locked on Feb 12 2016

Added on Jan 15 2016

19 comments

711 views