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
3988 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 to loop through a cursor variable?

0 Answers

I need to get the values of the previous quarter.how to do this?eg: if my cuurent month is may i need to get the datas of the month jan,feb,march.Can it be done in oracle.I tried with date function q but for the month jan its not retriving the previous quarter(oct-dec).how to solve this.plpz anyone help me?

2 Answers Philips,

How to define an anonymous procedure with variables?

0 Answers

How would you best determine why your MVIEW couldnt FAST REFRESH?

0 Answers

Why do we need oracle client?

0 Answers

Can a View based on another View ?

3 Answers

What are the commands youd issue to show the explain plan for select

2 Answers

What is the difference between count (*), count (expression), count (distinct expression)?

0 Answers

acname actype amount ac1 credit 300 ac2 credit 4000 ac1 debit 4000 ac2 debit 455 ac1 credit 500 how to get sum of credit and sum of debit for each account

2 Answers Polaris,

difference between oracle8i and oracle9i

4 Answers NIIT,

Hi All, Recently I attended a interview for a developer position in an educational university. They asked me the a question, I answered somehow but I was not not satisfied myself. Can anybody reply for it? The question is: A business user comes to you directly with an urgent request:: there is a problem with some students not being able to re-enrol. It appears that ?something has gone wrong with the end-dating of some previous courses they had enrolled in, and this is preventing them from completing their on-line re-enrolments?. Fortunately the user has done some analysis on the situation, and has developed some code to change the end dates. They tell you that they have tested this code in the ?dev? environment, and it works fine. They are asking you to please get this implemented in production as soon as possible. What steps would you take in response to their request ? Thanks

2 Answers

How to use group functions in the select clause using oracle?

0 Answers

For more Oracle General Interview Questions Click Here