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
4053 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 parameter file in oracle.

How to name query output columns in oracle?

candidate key is subset of super key but not vice-verse explain

How to select some columns from a table in oracle?

How can we find out the duplicate values in an oracle table?

Table1- have two column filename data AFGDFD-20112011 hi how r u bsdasd-23042011 name shoud be in bold Now i want output like filename data AFGDFD hi how r u bsdasd name shoud be in bold Kindly answer this

How to check database size in Oracle?

0 Answers MCN Solutions,

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

What is tns name?

How to join two tables in a single query using oracle?

what diffrence between function and procedure?

What is a synonym? What are its various types?

For more Oracle General Interview Questions Click Here

Categories

Oracle General (1803)
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)