I have a package in which a table was used in a procedure and compiled later i have dropped the table used in the package what would be the status of package specification and body

1 Answers   TCS,

---

What are basic techniques of indexing?

0 Answers  

---

What is a record in a database?

0 Answers  

---

In testing where do we use sql language and how it helps in testing?

2 Answers  

---

i have a table eno dno sal 1 10 200 2 10 150 3 10 100 4 20 75 5 20 100 i want to get sal which is less than the avg sal of thri dept. eno dno sal 2 10 150 3 10 100 4 20 75

12 Answers   IBM,

---

Is crud a cuss word?

0 Answers  

---

Is pl sql useful?

0 Answers  

---

What is mdb stand for?

0 Answers  

---

What does (*) mean in sql?

0 Answers  

---

What is sql in oracle?

0 Answers  

---

How many database objects (trigger, packages, sequence etc) uses a particular field in a given table. For ex: I want to know how many database object uses the ATTRIBUTE1 in the PO_VENDORS table. What query will give me the result showing the database object name(package, trigger etc), field_name used (in this case ATTRIBUTE1) and table_name (in this case PO_VENDORS).

2 Answers   IBM,

---

What are the types of sql commands?

0 Answers  

---