A table was given with 3 columns like Manager id,Manager
Name and Employee name.
Question was to create hierarchy.
Answer Posted / sankar
select manager name,employee name,level from table_name
start with manager_name is null/* optional */ connect by prior
no cycle employee name=manager name/*child=parent*/
Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What are the differences between in and exists clause?
How to look at the current sql*plus system settings?
What is cursor explain with example?
what are the types of join and explain each? : Sql dba
what are different types of keys in sql?
What is trigger in sql?
What is latest version of sql?
Can we rollback delete command?
how to use like conditions? : Sql dba
What is native sql query?
What are user defined functions?
Is null operator in sql?
What trigger means?
Difference between global and parameter variables?
what is index? : Sql dba