Answer Posted / peter

SQL> select sal
2 from (select sal,
3 row_number() over
4 (order by sal desc ) rn
5 from emp )
6 where rn = 2;

SAL
----------
3000

SQL>

Explain the truncate in oracle?

967

---

What is oracle latest version?

1096

---

What is a named program unit?

1083

---

How to pass parameters to procedures in oracle?

1042

---

How to connect ms access to oracle servers?

1007

---

How does propagation differ between Advanced Replication and Snapshot Replication (read-only)?

2255

---

What is translate in oracle?

1098

---

22. Display the order number, number of lines in the order, total number of items and total value for all orders that have a total value greater than $100

2022

---

What is an oracle database?

1035

---

Is oracle the best database?

963

---

How do you find out from the RMAN catalog if a particular archive log has been backed-up?

2123

---

How to work with data objects interactively?

982

---

How many objectname will be created for a single table drop function? Why 'flashback' query giving error "ORA-38312: original name is used by an existing object" while getting the table?

2261

---

How to set up autotrace for a user account?

1059

---

Is the After report trigger fired if the report execution fails ?

2915

---