How to get a list of all background sessions in the database?

0 Answers  

---

What is the difference between Sleep and Wait? (Java)

1 Answers   RBS,

---

SELECT * FROM (SELECT TITLE FROM MOVIE ORDER BY RANK DESC) WHERE ROWNUM > 4; when i run the above query .it produces output as NO ROWS SELECTED.why ?plz any one help me

6 Answers   TCS,

---

What are the different approaches used by Optimizer in choosing an execution plan ?

2 Answers  

---

9. Display the client name and order date for all orders using the JOIN . . . USING method.

2 Answers   Wipro,

---

---

What is a view and how is it different from a table?

0 Answers  

---

How to recover a dropped index?

1 Answers  

---

What are various constraints used in SQL?

1 Answers   Polaris,

---

What are the limitations of check constraint?

0 Answers  

---

What is the difference between SQL, DDL, and DML?

7 Answers   BeBo Technologies, Wipro,

---

What is a table index in oracle?

0 Answers  

---

Find all employees in Dept “Marketing”.

2 Answers  

---