Answer Posted / tulasi

select * from emp x where 1=(select count(distinct sal)
from emp y where x.sal<=y.sal);

query to find nth sal

select * from emp x where &n=(select count(distinct sal)
from emp y where x.sal<=y.sal);

I have a parent program and a child program. I want to write a statement in Exception Block of the parent program so that when the statement in the exception block is executed, the control goes to the next statement in the parent block bypassing the child block.How do i do that?

2468

---

What do the 9i dbms_standard.sql_txt() and dbms_standard.sql_text() procedures do?

4524

---

what is the scenario where you take the database to NoArchivelog mode?

2333

---

HI, Please let me know the syllabus for Oracle OCA and OCP Certification

2502

---

Why does Oracle not permit the use of PCTUSED with indexes?

2427

---

State any two functions of oracle?

1047

---

What is coalesce function?

1078

---

What is the difference between sharding and partitioning?

991

---

Is primary key indexed by default in oracle?

993

---

In not less than 100 words what's the main difference between Rolap and Molap in ORACLE ?

2289

---

How to use "while" statements in oracle?

1330

---

What is flashback in Oracle?

1023

---

What are the differences between date and timestamp in oracle?

1052

---

List out the components of logical database structure of oracle database.

1040

---

If any one has information regarding interview of NIC (National Informatics Centre),it would be of great help...

2232

---