Why do you create or replace procedures rather that drop and recreate.
- 1 Answers
- 1108 Views
- I also Faced
- E-Mail Answers
Answer / 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 |
Please explain oracle data types with examples?
What are cursor?where are they used?
Difference between hot backup vs. Cold backup?
What is oracle update statement with inner join ?
1:-How to write to update command in a procedure in oracle which update two different table at a time 2:-How to write the select command in a procedure in oracle which give multiple records
Explain the use of inctype option in exp command.
A USER HAVING CREATE SESSION PREVILAGE CAN ALTER PASSWORD/CHANGE PASSWORD?
What is a public synonym?
what is the exact diiference between DBMS and RDBMS
What is the function of Optimizer ?
How to use "startup" command to start default instance?
what is primary key and foreign key when and where have to use
Oracle General 
