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 current version of sql?

1023

---

List different type of expressions with the example.

935

---

What is a table?

1015

---

When a dml statement is executed, in which cursor attributes, the outcome of the statement is saved?

1116

---

what does the t-sql command ident_current does? : Transact sql

978

---

What is the use of desc in sql?

977

---

what is the difference between undefined value and null value? : Sql dba

1101

---

How can I speed up sql query?

962

---

how to convert character strings to numeric values? : Sql dba

1106

---

what is the difference between $message and $$message? : Sql dba

997

---

how to return query output in html format? : Sql dba

1073

---

What is the use of count (*) in sql?

1053

---

what is a scheduled jobs or what is a scheduled tasks? : Sql dba

960

---

how to shut down the server with 'mysqladmin'? : Sql dba

1012

---

how do you know if your mysql server is alive? : Sql dba

1078

---