Answer Posted / esha gautam

SELECT SAL FROM EMP E WHERE &N-1 =(SELECT COUNT(*) FROM EMP
WHERE E.SAL<SAL);

HERE N FOR NTH SALARY!!!!!!!!!!!!!!!!!!!!

What is merge statement used for?

571

---

How to speed up webrick?

599

---

What is connection pool in oracle?

560

---

Explain how you would restore a database using RMAN to Point in Time?

1640

---

How we can able to import our own template (users designed MS-Word templates) which has many tabular columns; need to pass some values generate by Oracle-reports9i? Actually need to import more than 400 MS-Word templates into Oracle Reports-9i to minimize layout design in Reports.

1615

---

---

What happens if you set the sga too low in oracle?

559

---

what are the advantages of running a database in archive log mode?

1736

---

Can we commit inside a function in oracle?

562

---

Explain overloading. Can functions be overloaded?

577

---

What is the meaning of recursive hints in oracle?

532

---

What is an oracle wallet?

516

---

defination of bitmap index

1631

---

How to create a new table in oracle?

594

---

How to list all user accounts in oracle?

616

---

How to loop through a cursor variable?

570

---