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 is the sql query to display the current date?

0 Answers  

---

How does left join work in sql?

0 Answers  

---

How to execute OS(operating system) command from pl/sql?

3 Answers  

---

Is merge a dml statement?

0 Answers  

---

---

Which one of the following join types will always create a Cartesian Product? 1. CROSS JOIN 2. LEFT OUTER JOIN 3. RIGHT OUTER JOIN 4. FULL OUTER JOIN 5. INNER JOIN

2 Answers  

---

What does pl sql stand for?

0 Answers  

---

Advantages and disadvantages of stored procedure?

0 Answers  

---

Delete the emps whose salaries are lowest sals of their own dept.

5 Answers  

---

What is string join?

0 Answers  

---

What is the criteria while applying index to any column on any table.

1 Answers   Infogain,

---

How to make a copy values from one column to another in sql?

0 Answers  

---