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 synonyms?

0 Answers  

---

How will you select unique values from a list of records?

7 Answers   Cap Gemini,

---

Write a query to find the names of users that begin with "um" in sql?

0 Answers  

---

What is data profiling in sql?

0 Answers  

---

What are the difference between Functions/Stored Procs and Triggers and where are they used.

1 Answers   CGI, TCS,

---

What is sql and how does it work?

0 Answers  

---

How many types of normalization are there?

0 Answers  

---

what is ref cursor in pl/sql?

3 Answers  

---

How does index help in query performance?

0 Answers  

---

what is query cache in mysql? : Sql dba

0 Answers  

---

I m giving Source, Destination and Age. Write a procedure or function, it will give to u this source to destination tickets are available or not, if available then check this person is senior citizen or not,if this person is senior citizen then give some discount. PLZ give this answer...... Thanks advance.....

3 Answers  

---