How to return top 5 rows in oracle?

0 Answers  

---

What are temporal data types in oracle?

0 Answers  

---

Table E: Name dept month sal 1 A JAN 800 2 B APR 1000 3 A JAN 300 4 A JAN 600 5 C JUN 400 1) SELECT HIGHEST SAL PAID DEPT IN JAN MONTH? 2) WRITE QUERY GET MAX SAL DEPT NO?

6 Answers   IBM,

---

How to use "in out" parameter properly?

0 Answers  

---

What is DTS and purpose of DTS ?

1 Answers   TCS,

---

Explain the function of optimizer in oracle?

0 Answers  

---

What are the different pseudo commands? Explain in general?

0 Answers  

---

How can we manage the gap in a primary key column created by a sequence? Ex:a company has empno as primary key generated by a sequence and some employees leaves in between.What is the best way to manage this gap?

2 Answers   Infosys,

---

How many categories of data types?

0 Answers  

---

I am using an Oracle 8i Database my data contains Clob data. I am using toad version 7.6 i am able to get the data in toad but unable to extract the data in excel.when trying to extract the data into the excel the toad error says out of memory. Can any body please help me to extract the data through the same toad version. Thanks in advance

0 Answers   Cisco,

---

does the query needs a hint to access a materialized view?

1 Answers  

---

I know that i can create a table without a primary key.But is there any significance for that table???? while creating an application.

6 Answers  

---