Interested to Buy Any Domain ? << Click Here >> for more details...
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
Why packages are used in oracle?
What is the usage of analyze command in oracle?
Explain the use of rows option in exp command.
How to drop a stored procedure in oracle?
11. Display the client number and name and the client number and name of the person who referred that client.
I am using an Oracle 8i Database my data contains Clob data. I am using toad version 7.6 i am able to get the data in toad but unable to extract the data in excel.when trying to extract the data into the excel the toad error says out of memory. Can any body please help me to extract the data through the same toad version. Thanks in advance
How to build data dictionary view an new database?
What is integrity and what is constraint??Explain with example
How to drop an index?
How to change user password in oracle?
Why cursor variables are easier to use than cursors?
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.
What are the major difference between truncate and delete?
Which dictionary view(s) would you first look at to understand or get a high-level idea of a given Advanced Replication environment?
What is meant by an index?
