When we give SELECT * FROM EMP; How does oracle respond?

24 Answers   Accenture, HCL, Infosys,

---

How do you retrieve set of records from database server. {Set max records = 100 & use paging where pager page no or records = 10 & after displaying 100 records again connect to database retrieve next 100 }

2 Answers   DELL,

---

Suppose a student column has two columns, name and marks. How to get name and marks of the top three students.

0 Answers  

---

What are the Diff B/W Cursor and REF Cursor

3 Answers   CTS,

---

i don't want the message as 14 rows updated just it should update what it will do

4 Answers  

---

What is triggering circuit?

0 Answers  

---

how to calcuate the second highest salary of he employee

13 Answers   Synechron,

---

What does pl sql developer do?

0 Answers  

---

what is mean by forward declaration and where we'll use it.

4 Answers   TCS,

---

Which normal form is best?

0 Answers  

---

What is Materialized View? In What Scenario we Use Materialized View?

2 Answers   Dinesh, Marlabs,

---

How to combine two stored procedures in sql?

0 Answers  

---