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


Please Help Members By Posting Answers For Below Questions

How to use values from other tables in update statements using oracle?

568


How to get execution statistics reports on query statements?

572


What is a database table in oracle?

572


What happens if recursive calls get out of control?

550


How to write numeric literals in oracle?

615






what happened to the global index when I truncate the data in one of the partition?

1520


Differentiate between post-database commit and post-form commit?

543


How to turn on or off recycle bin for the instance?

611


What are ddl statements in oracle?

592


Where do we use decode and case statements?

563


Explain the types of exception?

654


Can you drop an index associated with a unique or primary key constraint?

587


What is the meaning of recursive hints in oracle?

532


What is a read only transaction in oracle?

596


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

1847