Answer Posted / tejeswara rao potnuru

Find Out The Nth Highest Salary


SELECT MAX(SAL),LEVEL FROM EMP
WHERE LEVEL=&LEVELNO
CONNECT BY PRIOR SAL>SAL
GROUP BY LEVEL;

What spfile/init.ora file parameter exists to force the CBO to make the execution path of a given statement use an index, even if the index scan may appear to be calculated as more costly?

2069

---

What is the usage of save points in oracle database?

962

---

How to assign values to variables?

1098

---

Explain integrity constraint?

1159

---

what is partitioning? Types of partitioning. explain? what is the new kind of partitioning type introduced in 9i?

2263

---

Respected sir, Please send me technical questions related to oracle apps..

1811

---

Is oracle a relational database?

914

---

WHEN CURSOR MOVES FROM ONE FORM TO ANOTHER FORM, HOW MANY TRIGGER WILL BE FIRED AND WHAT ARE THEIR SEQUENCE?

2307

---

What is a snapshot log?

999

---

How remove data files before opening a database?

1066

---

Does oracle partitioning improve performance?

992

---

Why is oracle database so popular?

991

---

How to define a record variable to store a table row?

1056

---

How to rename an index?

1069

---

How to define a data source name (dsn) in odbc manager?

1026

---