Answer Posted / kapil

By using index (not always)
by using bulk fetch
by using exists and not exists in place of in and not in
clause.
by avoiding implicit conversion by oracle
ex: if in employee table emp_no is varchar then
if we query the data from employee table by
where cluase like employee_number = 123 then oracle will
have to implictly convert the number 123 to
varhcar '123'and will require time

What is the difference between a procedure and a function?

1211

---

What is the meaning of disabling a trigger?

1236

---

Can primary key be changed?

951

---

What are hotfixes and patches?

986

---

What is parameter substitution in sql?

1079

---

What are transaction and its controls?

1089

---

What is posting?

1083

---

What is a recursive join sql?

1111

---

How to write a single statement that concatenates the words ?hello? And ?world? And assign it in a variable named greeting?

1144

---

Is pl sql a programming language?

1040

---

1) Synonyms 2) Co-related Subquery 3) Different Jobs in Plsql 4) Explain Plan 5) Wrap 6) Query Optimization Technique 7) Bulk Collect 8) Types of index 9) IF primary key is created then the index created ? 10) Foreign Key 11) Exception Handling 12) Difference Between Delete and Trunc 13) Procedure Overloading 14) Grant Revoke 15) Procedure Argument types. 16) Functions. 17) Joins

1640

---

Can a procedure in a package be overloaded?

1099

---

Determine if oracle date is on a weekend?

1087

---

What is trigger and stored procedure in sql?

1090

---

what is 'mysqlimport'? : Sql dba

1108

---