How to display the hierarchy of employee and managers without using connect by

How to display the hierarchy of employee and managers
without using connect by prior.

Question Posted / pradeeshkumar

1 Answers
3887 Views
I also Faced
E-Mail Answers

How to display the hierarchy of employee and managers without using connect by prior...

Answer / abc

using self join and group by function...

Is This Answer Correct ?

0 Yes

0 No

Post New Answer

More Oracle General Interview Questions

How many objectname will be created for a single table drop function? Why 'flashback' query giving error "ORA-38312: original name is used by an existing object" while getting the table?

0 Answers

How to display First 4 rows From Database Table?

6 Answers

what are the things that you consider while creating indexes on partitioning tables?

1 Answers

How to login to the server without an instance?

0 Answers

What is an oracle database?

0 Answers

Explain what are the uses of rollback segment?

0 Answers

What is the difference between the Oracle ODBC driver and a Microsoft ODBC (Open Database Connectivity) Driver?

0 Answers CGI,

can you write commit in triggers?

4 Answers

i have a question here... As of my knowledge, when we apply an index (b-tree)on a column, internally it arranges the data in b-tree format and do the fetching process correspondingly... and my quetion is... How a bit-map index arranges the data internally when applied on a column?IS it in b-tree format or whatelse?

0 Answers Oracle,

Why use resource manager in Oracle?

0 Answers MCN Solutions,

Find all employees in Dept “Marketing”.

2 Answers

How to write a query with a right outer join in oracle?

0 Answers

For more Oracle General Interview Questions Click Here