top button
Flag Notify
    Connect to us
      Site Registration

Site Registration

Why "create or Replace" but not the "drop and recreate" while creating procedures?

+1 vote
212 views
Why "create or Replace" but not the "drop and recreate" while creating procedures?
posted Dec 5, 2014 by Archana

Share this question
Facebook Share Button Twitter Share Button LinkedIn Share Button

1 Answer

+1 vote
 
Best answer

So that Grants are not dropped

answer Dec 8, 2014 by Arun Gowda
Similar Questions
+2 votes

Its a very basic question but it would be good if anyone can answer with some explanations. When we type select * from dba_users; in sql plus it will show N rows selected and total records whereas when we type select * from employee it would show only records but not the total count.

+1 vote

If we delete the base table whether the synonym will exists or not? If we use that synonym what type of error we will get?

...