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 set operators in sql? : Sql dba

0 Answers  

---

How to access the current value and next value from a sequence?

6 Answers  

---

Why do we use procedures in sql?

0 Answers  

---

How you will create Toad Function?

1 Answers  

---

what is outer join? what is selef join? what is difference between them? what is cartecion join?

1 Answers   Fiserv, Herbinger, Synechron,

---

What is sql data?

0 Answers  

---

Can we use rowid as primary key?

0 Answers  

---

How long does it take to learn pl sql?

0 Answers  

---

Create table emp (id number(9), name varchar2(20),salary number(9,2)); The table has 100 records after table created.Now i nee to change id's Datatype is to be Varchar2(15). now Alter table emp modify(id varchar2(15),name varchar2(20), salary number(9,2)); Whether it will work or returns error? post answer with explanation.

13 Answers   Oracle, TCS,

---

Can there be more than one function with a similar name in a pl/sql block?

0 Answers  

---

Is sql better than excel?

0 Answers  

---