Answer / Gaurav Mathur

"To use a subquery with the EXISTS operator in Oracle, you can write it like this:

```
SELECT * FROM table_1
WHERE EXISTS (
SELECT * FROM table_2
WHERE table_1.id = table_2.id
);

Please explan Why static query is more faster than dynamic query ?

2 Answers  

---

What is Index Cluster ?

2 Answers  

---

How to change program global area (pga) in oracle?

1 Answers  

---

Which is better Oracle or MS SQL? Why?

3 Answers   Bally Technologies,

---

How to define and use table alias names in oracle?

1 Answers  

---

What is the difference between truncate & delete command?

1 Answers  

---

How to check the oracle tns settings?

1 Answers  

---

What is a database schema in oracle?

1 Answers  

---

how to convert .db (extention) database file into .dmp (extention ) for oracle database ?

1 Answers   EDC,

---

How do I recompile a procedure in oracle?

1 Answers  

---

What are the differences between date and timestamp in oracle?

1 Answers  

---

State the various uses of dbcc command?

1 Answers  

---