Skip to Main Content
Forums

SQL Developer

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How to get the manager details below the top most manager

2662398Aug 8 2016 — edited Aug 8 2016

Hi Team,

I have a below requirement where i need to get the manager name who reports to top manager.

For ex:

-------

Employee-->Manager-->Next Level Manager-->Next Level Manager-->Next Level Manager (Top Manager)

1. John           David          Michael                              Johnson                  Paul

2. Andy           Rock          Murray                                Debbie                    Paul

In Select statement I need to display data like below

Employee Name   Employee Number   Job   Manager

John                        1234                     xyz     Johnson

Andy                        7890                    abc      Debbie

Please suggest.

Thanks,

Poli

Comments

Maris Gabalins

Hi,

To make it more exciting ...

Starts working correctly after executing "Reset sample data"

Stops working after re-creation of APEX workspace schema.

Sincerely

Maris

patfmnd

Hi, Maris,

Did you get any resolution to this issue?  We started getting this message after a recent clone of our database.  We had cloned our database in past and then restored the schema that was providing our RESTful services with no issues.  Now when we try to call the RESTful services we are getting this error.  Most recently, it happened after a TEST clone from PROD.  DEV was working fine.  We just cloned DEV from PROD and now DEV is also giving this same error message -- as a result our RESTFul service calls end with this error message!

Any suggestions would be appreciated.

Pat

1 - 2
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Sep 5 2016
Added on Aug 8 2016
#sql-developer
2 comments
428 views