Interested to Buy Any Domain ? << Click Here >> for more details...
A table was given with 3 columns like Manager id,Manager
Name and Employee name.
Question was to create hierarchy.
- 2 Answers
- 8733 Views
- TCS, I also Faced
- E-Mail Answers
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
How is debugging done?
What is the difference between Union and Union all. Which is faster.
What is where clause in sql?
Explain how can you save or place your msg in a table?
Can we use update in sql function?
what happens if you no create privilege in a database? : Sql dba
What is auto increment in sql?
When to use inner join and left join?
How long does it take to learn pl sql?
What does (*) mean in sql?
what is csv? : Sql dba
What is the difference between delete and truncate commands?
How many times can we commit in a loop?
What is the difference between sql, mysql and sql server?
What are the types of variables use in pl sql?
