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

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

using self join and group by function...

Is This Answer Correct ?

0 Yes

0 No

More Oracle General Interview Questions

How to see the table columns used in an index?

1. Display all the rows and columns in the CLIENT table. Sort by client name in reverse alphabetical order.

what is main def between plsql/table and array?

How to define an anonymous procedure without variables?

What is Trace File ?

How to find no of saturdays in a month using single sql ?

Can anyone give me information about oracle certification

HOW TO DISPLAY MAXIMUM SALARIES FROM EMP DEPARTMENT VISE ALONG WITH DEPARTMENT NAMES? E.g EMP,DEPT

What is the difference between a user and a schema in oracle?

13. Display the second to fifth characters in each client name.

How to create a new oracle data file?

What are the different pseudo commands? Explain in general?

For more Oracle General Interview Questions Click Here