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
- 8680 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
what is a relationship and what are they? : Sql dba
Mention what is the plv (pl/vision) package offers?
in oracle 10g sw after compiling procedure how to pass parameter values ,if we (v_empid out number)how to give empid after successful compilation program.This site exact suitable for 10g with respect to question & answer same format , im trying sql browser & sql command prompt using exec procedure name & respective parameters.
What does trigger mean in psychology?
What is auto increment in sql?
How to use distinct and count in sql query? Explain
How many sql core licenses do I need?
How can I make sql query run faster?
What is the meaning of disabling a trigger?
What are system versioned tables?
What is clustered and nonclustered index in sql?
What is nosql example?
What is full join?
how many columns can be used for creating index? : Sql dba
Can we create table inside stored procedure?
