Answer / guest

Correlated subquery process is an outside-inside-outside
subquery. For every row in the outer query the inner query
is evaluated and results passed to the outer query to
complete the final result row.

Answer / aditya

a query in which there is reference of inner query into
outer query and that of outer query into inner
query...means they can't run independently.

What is a NULL value? What are the pros and cons of using NULLS?

2 Answers  

---

Explain an outer join?

1 Answers  

---

What is meant by the attachment facility?

3 Answers  

---

Mention the location where the output received from explain statement is stored.

0 Answers  

---

What are the various locking levels available?

3 Answers  

---

Shall i use this query to retrieve first 4 records, Select empno, sal from emptbl where empno < 5. like this can we fetch first 100 records?

3 Answers  

---

Explain the EXPLAIN statement?

1 Answers  

---

when does the SQL statement gets executed when you use cursor in the application programming ?

3 Answers   IBM,

---

Which component is used to execute the sql statements?

0 Answers  

---

in my table i will update only 100 record among 1000 records i need to display recently updated record'.....can u tell me where those records are stored how can i display those records...?if there is any sql query pls let me know....?

3 Answers   Infosys,

---

When reorg is used?

0 Answers  

---

what is + sign and -ve sign for sql code ?

1 Answers   TCS,

---