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 does an inner join do?
What are sql indexes?
How many columns should be in an index?
What is a sql*loader control file?
What is sorting in sql?
Can we insert delete data in view?
Can we use rowid as primary key?
What is normalization in sql?
What is nested table in pl sql?
How do I find sql profiler?
What is the difference between cluster and non-cluster index?
What is the current version of sql?
What are sql commands?
What does varchar include?
What is a procedure in pl sql?