Answer Posted / venubabu
Select level,Max(sal) from emp
Where level=&level connect by prior sal>sal
group by level;
sql>Enter value for level:5
Is This Answer Correct ? | 3 Yes | 1 No |
Post New Answer View All Answers
What happens to the data files if a tablespace is dropped?
How to turn on or off recycle bin for the instance?
what is the difference between functional dependecy and multilevel dependency?
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?
How to enter a new row into a table interactively?
How to retrieve values from data fields in record variables?
In SAP ECC 6.0 , under DB02 tcode , Tablespace name to be explain stepy step all the col
What is an oracle database table?
How to create an oracle database?
Does oracle database need java?
Explain an integrity constrains?
What happens to the current transaction if a ddl statement is executed?
What is meant by a deadlock situation?
Write a trigger example in oracle?
Give the advantages and disadvantages of clusters.