Why do you create or replace procedures rather that drop and recreate.

Question Posted / rahul saxena

No Answer is Posted For this Question
Be the First to Post Answer

More Oracle General Interview Questions

A and B are tables. x is a column. Then What is difference between A.x = B.x(+) and A.x = B.x ?

How to call a stored procedure inside a trigger? Give an example.

How to shutdown your 10g xe server from command line?

Explain an integrity constrains?

how to create a new database in oracle?

Whether Oracle satisfy more codd rules or db2 satisfy more codd rules? How meny of each can satisfy ? Please answer me. Advance thanks

What is the effect of setting the value "ALL_ROWS" for OPTIMIZER_GOAL parameter of the ALTER SESSION command ?

What happens if the imported table already exists?

when do u go for hash partitioning?

what diffrence between function and procedure?

Whats the benefit of dbms_stats over analyze?

What privilege is needed for a user to create indexes in oracle?

For more Oracle General Interview Questions Click Here