top button
Flag Notify
    Connect to us
      Facebook Login
      Site Registration

Facebook Login
Site Registration

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

+1 vote
76 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?

Contact Us
+91 9880187415
sales@queryhome.net
support@queryhome.net
#280, 3rd floor, 5th Main
6th Sector, HSR Layout
Bangalore-560102
Karnataka INDIA.
QUERY HOME
...