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

why use cursors?

5 Answers   Oracle,

---

How to read/write files from pl/sql?

0 Answers  

---

source destination distance chennai bangalore 500 bangalore chennai 500 hyd delhi 1000 delhi hyd 1000 bangalore hyd 800 Here chennai to bangalore and bangalore to chennai is same distance. and hyd and delhi also same criteria. Based on the distance i want to display only one row using sql query?

4 Answers   JPMorgan Chase,

---

How many commands are in sql?

0 Answers  

---

What is an index and types of indexes. How many number of indexes can be used per table ?

12 Answers   Accenture, BirlaSoft, Cognizant, CTS, Symphony,

---

---

What does partition by mean in sql?

0 Answers  

---

What is the use of triggers?

0 Answers  

---

Is pl sql better than sql?

0 Answers  

---

how to fetch alternate records from a table? : Sql dba

0 Answers  

---

1 SELECT a.field1, b.field2, c.field3, d.field4 2 FROM atable a, atable b, ctable c, dtable d 3 ? 4 ORDER BY 1 What is the minimum number of joins that must be specified on line 3 in the sample code above to properly link the tables? Notice that the table "atable" is aliased twice: once as "a" and once as "b." 1. One join 2. Two joins 3. Three joins 4. Four joins 5. Five joins

6 Answers   Sonata,

---

What is the use of function "module procedure" in pl/sql?

0 Answers  

---

What is sql lookup?

0 Answers  

---