Answer Posted / rajesh

while the user don't have the sufficient privilege to
execute the procedure/package.or else while the owner of
the procedure/package alters the name of the
procedure/package it becomes invalidated....

what is the difference between rownum pseudo column and row_number() function? : Sql dba

1039

---

Which nosql database is best?

945

---

What is your daily office routine?

2231

---

What are the datatypes available in pl/sql ?

1060

---

What are two statement types in sql?

1051

---

Is it possible to include an insert statement on the same table to which the trigger is assigned?

975

---

how to return query output in html format? : Sql dba

1036

---

What is the plv (pl/vision) package offers?

999

---

What's the difference between inner join and left join?

965

---

What is the execution plan in sql?

988

---

How to run sql commands in sql*plus?

1118

---

Is left join inner or outer by default?

986

---

What are sql ddl commands?

1052

---

how to present a past time in hours, minutes and seconds? : Sql dba

963

---

What is difference between db2 and sql?

956

---