Answer / rao

When table is droped with out drop the objects
(package/procedure/function/view)

Answer / p.rajasekar

When the referenced object's signature is changed the
procedure get invalidated or the referenced object is
changed or droped

Answer / rao

When table is droped with out drop the objects
(package/procedure/function/view)

Answer / 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....

How does cross join work?

0 Answers  

---

What is rename command in sql?

0 Answers  

---

difference between anonymous blocks and sub-programs.

0 Answers  

---

what are sequences

0 Answers  

---

Why does %isopen return false for an implicit cursor?

1 Answers  

---

what is error ora-03113: end-of-file on communication channel?

0 Answers  

---

How many triggers can be applied on a table?

0 Answers  

---

types of exceptions and what is meant by pragma autonomous_transaction ?what is the use.

4 Answers   3i Infotech,

---

What are the advantages of the packages

6 Answers   Oracle,

---

Differentiate between sga and pga.

0 Answers  

---

take one table is t1 and in that column name is f1 f1 column values are 200 5000 3000 7000 300 600 100 400 800 400 i want display the values asc and desc in a single output. sample output is f1.a 100 200 300 400 500 600 etc...... and f1.d is 5000 4000 3000 2000 1000 etc...

9 Answers   Zensar,

---

What is equi join in sql?

0 Answers  

---