Skip to content

Instantly share code, notes, and snippets.

@jgilmour

jgilmour/OracleEBS-Employee_IDs.sql

Last active December 11, 2015 14:09
Show Gist options
  • Save jgilmour/4612434 to your computer and use it in GitHub Desktop.
Save jgilmour/4612434 to your computer and use it in GitHub Desktop.
Download ZIP
Oracle EBS SQL Query which will pull down the person_id and full name for all employees in per_all_people_f Outputs as [person_id, full employee name], and orders by full_name
Raw
OracleEBS-Employee_IDs.sql
# Oracle EBS SQL Query which will pull down the person_id
# and full name for all employees in per_all_people_f
# Outputs as [person_id, full employee name], and orders by full_name
SELECT DISTINCT person_id, full_name from hr.per_all_people_f
ORDER BY full_name;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment