Answer Posted / dinesh a.

you can't use rownum > 4 ( you can use only rownum <
clause). not in inner query or inline view even in normal
query.

select empno from emp where rownum > 5 ..
The output you will get NO ROWS always ....

so the magic is only order by clause asc or desc pls see
below
suppose we have a table x with one column col1 and values
are 1 to 10...

SELECT rownum,rank,col1 FROM
(SELECT rownum rank,col1 FROM x ORDER BY col1 desc)
WHERE ROWNUM <= 6 /* last six rows mean > 4 */
/

ROWNUM RANK COL1
------ ---------- ----------
1 10 10
2 9 9
3 8 8
4 7 7
5 6 6
6 5 5
1 SELECT rownum,rank,col1 FROM
2 (SELECT rownum rank,col1 FROM x ORDER BY col1 asc)
3* WHERE ROWNUM <= 4 /* first 4 rows */
SQL> /

ROWNUM RANK COL1
---------- ---------- ----------
1 1 1
2 2 2
3 3 3
4 4 4

What is the recommended interval at which to run statspack snapshots, and why?

2964

---

How would you go about verifying the network name that the local_listener is currently using?

2109

---

What exactly do quotation marks around the table name do?

1027

---

What do you mean by merge in oracle and how can we merge two tables?

1095

---

Can we use bind variables in oracle stored procedure?

987

---

What happens to the current transaction if a ddl statement is executed?

1060

---

what is normalisation?what are its uses?

2334

---

Explain the use of file option in exp command.

1177

---

How to loop through a cursor variable?

1128

---

what is the use of system.effective.date variable in oracle?

1163

---

What are the parameters that we can pass through a stored procedure?

1118

---

What is oracle instant client?

1070

---

Explain joins in oracle?

1094

---

What is proxy method?

1024

---

How to display row numbers with the records?

1139

---