Japanese

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!

Details all employees that have changed their job title/role and/or have left the company within the

1046792Jan 14 2016 — edited Jan 14 2016

Team,

Can anyone help me to get the sql query to get the below output:

Employee_name- Employee_number -Old_org_name-New_org_name - Old_Job_Title,-New_Job_Title

ABC - 101-Company1-Company2-Engineer- Sr.Engineer

This is apart of Oracle HRMS module where we are using common tables like per_all_people_f, hr_organisations_all.. etc.

Do let me know if required more details

Thanks

Locked Post

New comments cannot be posted to this locked post.

Locked on Feb 11 2016

Added on Jan 14 2016

#sqlとpl-sql, #データベース

1 comment

4,441 views