Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / venki
SELECT LEVEL,MAX(SAL) FROM EMP WHERE LEVEL=&LEVEL
CONNECT BY PRIOR SAL>SAL GROUP BY LEVEL;
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
Tab A A B ------ 1 A 2 B 3 C Tab B A B ----- 4 D 5 E 6 F Generate the value into B table from A table. Only table A has the value. Write the SQL query to get B table value.
What is raw datatype?
What are the set operators union, union all, minus & intersect meant to do?
How to get execution path reports on query statements?
What is oracle sid?
What is the difference between alert log file and tarce file ?
What is clustered table in Oracle?
What are the limitations oracle database 10g xe?
How many categories of data types in oracle?
What query tells you how much space a tablespace named test is taking up, and how much space is remaining?
What is the implicit cursor in oracle?
What is save point in oracle database?
How to start a specific oracle instance?
In which language oracle has been developed?
What are oracle functions?
