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

Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

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

Question Posted / pradeeshkumar

1 Answers
3992 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

Explain the blob datatype?

What is flashback Query ? And Use ?

4 Answers Thermotech,

What are the differences between date and timestamp in oracle?

What is currency type in database ?

how the Oracle Prepares the Execution Plan and how it chooses the Optimal one?

0 Answers Oracle,

How to convert raw data type into text in oracle? Explain

What is a subquery in oracle?

What is raw datatype in oracle?

two tables are there emp(eno,ename,sal,deptno),dept(deptno,dname).how form the query in deptno,ename,max(sal)

22. Display the order number, number of lines in the order, total number of items and total value for all orders that have a total value greater than $100

0 Answers Wipro,

What is a proxy class?

What is a tns file?

For more Oracle General Interview Questions Click Here

Categories

Oracle General (1809)
Oracle DBA (Database Administration) (261)
Oracle Call Interface (OCI) (10)
Oracle Architecture (90)
Oracle Security (38)
Oracle Forms Reports (510)
Oracle Data Integrator (ODI) (120)
Oracle ETL (15)
Oracle RAC (93)
Oracle D2K (72)
Oracle AllOther (241)