What are the advantages of sql? Explain

0 Answers  

---

Delete duplicate records in the emp table.

6 Answers   Oracle,

---

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 events on which a database trigger can be based?

0 Answers  

---

what are all the different types of indexes? : Sql dba

0 Answers  

---

What are the two parts of design view?

0 Answers  

---

can we write stored function in out parameters? how to call through select statement? how to written more than one value plz give the exmple?

1 Answers  

---

Do view contain data?

6 Answers   Ramco,

---

What is nvl?

0 Answers  

---

i have 2 table table one 4 columns respective values a1 7,a2 6,a3 8 ,a4 12 & table two 4 colums respective values a1 7,a2 6,a3 8,a4 15.if table one & table two 3 colums same then 4th column values 1)Qes diff >5 then print 5 * diff value 2)Que diff <5 print 5

1 Answers  

---

What is diff between bulk collect and forall

3 Answers   Metric Stream,

---

What is on delete restrict?

0 Answers  

---