Answer / rajesh venati

Yes, we can use global variables in procedure and functions.

What are Global Temporary tables

3 Answers   IBM, TCS,

---

Are stored procedures compiled?

0 Answers  

---

Explain the rollback statement?

0 Answers  

---

What is difference between joins and union?

0 Answers  

---

How do you optimize a query?

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,

---

What packages(if any) has oracle provided for use by developers?

1 Answers  

---

What does inner join mean?

0 Answers  

---

How to run sql statements through the web interface?

0 Answers  

---

Where the Pre_defined_exceptions are stored ?

2 Answers  

---

7. Where would you look for errors from the database design?

1 Answers   Fintellix,

---

how would you write a query to select all teams that won either 2, 4, 6 or 8 games? : Sql dba

0 Answers  

---