What is a natural join sql?

0 Answers  

---

What are the different ways to optimize a sql query?

0 Answers  

---

what is the difference between a web-garden and a web-farm? : Sql dba

0 Answers  

---

What is indexes?

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,

---

---

Why do we create views in sql?

0 Answers  

---

What is the clause we need to add in function body to return variable?

0 Answers  

---

What does select * from mean in sql?

0 Answers  

---

What is audit logout in sql profiler?

0 Answers  

---

Explian rowid, rownum?

0 Answers  

---

What is left join in sql?

0 Answers  

---

Is pl sql a scripting language?

0 Answers  

---