Answer Posted / amit bhagat
select min(a.sal) from (select disctinct d.sal from emp d
order by sal desc) a where rownum<=2
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is oracle latest version?
In which language oracle has been developed?
How to define an anonymous procedure without variables?
How can you tell how much space is left on a given file system and how much space each of the file systems subdirectories take-up?
ABOUT IDENTITY?
How to run create database statement?
What privilege is needed for a user to create tables in oracle?
How to call a sub procedure?
How to use "for" statements in oracle?
Point out the difference between user tables and data dictionary?
What are the differences between interval year to month and interval day to second?
What is primefaces used for?
What is a system tablespace?
We are using Oracle apps with XML publisher.In that,we are facing some problems while giving a Footer in RTF Template.While giving a footer in RTF Template it is Visible in all the pages,but after the PDF is getiing generated,the Footer are Visible on alternate pages only (like on first page ,third page) and so on. Please provide the Solution for getting the Footer on all the pages.
Please explain compound trigger in oracle?