Answer Posted / yaseen syed

select *
from
(select empno,ename,sal,rank() over(order by sal desc)
ranking from emp)
where ranking=2;

and u can find the nth highest sal by replacing 2 by your
number

What is a system tablespace?

1008

---

How to create a new oracle data file?

972

---

Can we store pictures in the database and if so, how it can be done?

986

---

How to create a server parameter file?

1081

---

How do you bind variables in oracle?

931

---

What is a user account in oracle?

1069

---

Please explain oracle left join with an example?

960

---

Explain the use of consistent option in exp command.

974

---

How many types of tables supported by oracle?

1020

---

Explain a private synonyms?

983

---

In SAP ECC 6.0 , under DB02 tcode , Tablespace name to be explain stepy step all the col

4115

---

Explain what are the characteristics of data files?

1031

---

How to view the data files in the current database?

1045

---

What is a database table in oracle?

954

---

how to use select statement as formal parameter in procedure specification?(someone said that using string) ex:-procedure(a in number,select ename from emp ) i am asking syntax like this?

1950

---