i want to know about mr.b.kotravel......who has answered
for second maxmium salary from employee table
Answer Posted / mohan
select max(sal) from emp where sal<(select max(sal) from
emp)
Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
How to use values from other tables in update statements using oracle?
How to get execution statistics reports on query statements?
What is a database table in oracle?
What happens if recursive calls get out of control?
How to write numeric literals in oracle?
what happened to the global index when I truncate the data in one of the partition?
Differentiate between post-database commit and post-form commit?
How to turn on or off recycle bin for the instance?
What are ddl statements in oracle?
Where do we use decode and case statements?
Explain the types of exception?
Can you drop an index associated with a unique or primary key constraint?
What is the meaning of recursive hints in oracle?
What is a read only transaction in oracle?
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