Answer Posted / asr

Avoid the sub queries.
Where condition should be based on primary key and index,
use primary column for join.
Try to avoid more tables.
Use temp tabels.
Create procedure.

Any attempt to navigate programmatically to disabled form in a call_form stack is allowed?

1037

---

How does one load ebcdic data? : aql loader

1088

---

What does where 1 1 mean in sql?

976

---

How do I create a sql script?

1046

---

What programs use sql?

940

---

What is a function in oracle pl sql?

972

---

What is duration in sql profiler trace?

1017

---

What is benefit of creating memory optimized table?

905

---

What is the usage of when clause in trigger?

987

---

Why do we need cursor in pl sql?

1076

---

explain commit and rollback in mysql : sql dba

931

---

Can ddl statements be used in pl/sql?

1065

---

What is a full join sql?

980

---

Explain 3 basic parts of a trigger.

1251

---

How can you load microsoft excel data into oracle? : aql loader

1127

---