Why do you create or replace procedures rather that drop and recreate.
- 1 Answers
- 1104 Views
- I also Faced
- E-Mail Answers
Answer Posted / Vandana Bhargaw
Creating or replacing a procedure instead of dropping and re-creating it is more efficient because it saves the time required to recompile dependencies. When using CREATE OR REPLACE, Oracle only needs to compile the differences between the existing and new procedure; if no changes were made, then the procedure remains unchanged.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
How to put more than 1000 values into an oracle in clause?
What is oracle latest version?
How to start an oracle instance?
How to use values from other tables in update statements using oracle?
Design database draw er diagram for a certain scenario ?
How to select all columns of all rows from a table in oracle?
How to write a left outer join with the where clause in oracle?
Please send me Informatica 8.1 certification dumps, my mail id mona85gupta@gmail.com
