A table was given with 3 columns like Manager id,Manager
Name and Employee name.
Question was to create hierarchy.
Answers were Sorted based on User's Feedback
Answer / sharad kumar
select manager name,employee name,level
from table_name
start with manager name is null /* optional*/
connect by prior nocycle employee name = manager name
/*Child = Parent */
Is This Answer Correct ? | 20 Yes | 0 No |
Answer / 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 |
Can we use threading in pl/sql?
Can we use two order by clause in query?
Does access use sql?
What is sql used for?
How do I run a sql script?
I have 2 packages A and B. Now package A references Package B and Package B references Package A. How do you compile such inter-dependent objects in PL/SQL
5 Answers Doyensys, Infosys, Metric Stream,
How many types of literals are available in pl sql?
What is an index in sql with example?
Types of cursors and explanation each of them ?
Where do we use pl sql?
Are stored procedures faster than dynamic sql?
What are Nested Tables? How will u delete 5 rows from Nested Tables