Answer Posted / m.raghu

answer for 101th record

select * from emp where empno in( select decode
(rownum,&n,empno) from emp);

for 4th highest sal

select distinct sal from(select empno,dense_rank() over
(order by sal desc) rnk from emp) where rnk=&n;

for 5th highest sal give n value=5
for 1-10

select distinct sal from(select empno,dense_rank() over
(order by sal desc) rnk from emp) where rnk<=&n;

Describe types of sql statements?

1062

---

How can we solve sql error: ora-00904: invalid identifier?

1249

---

what are the advantages a stored procedure? : Sql dba

979

---

What are data types in pl sql?

1146

---

What is sqlcommand?

1032

---

How do I view a view in sql?

955

---

Why is there a need for sqlcode and sqlerrm variables?

1053

---

what is a database lock ? : Sql dba

1175

---

How many tables can a sql database have?

980

---

What is the sql*loader? : aql loader

1057

---

Explain the structure of pl/sql in brief.

1095

---

What is bind variable in pl sql?

1057

---

What is nvarchar in sql?

927

---

What are the limitations of sql express?

1072

---

Differentiate between % rowtype and type record.

1311

---