⚡ v1.0.3 — Now Available

The SQL Client Oracle Fusion Developers Deserve

|

0Installation steps
1-ClickQuery results
100%On-premise secure
sql_worksheet.sql — Fusion Query Tool Pro
1-- Oracle Fusion HCM Query
2SELECT
3    ppnf.FULL_NAME,
4    per.EMPLOYEE_NUMBER,
5    asg.ASSIGNMENT_STATUS_TYPE
6FROM
7    PER_PERSON_NAMES_F ppnf
8    JOIN PER_ALL_PEOPLE_F per
9      ON ppnf.PERSON_ID = per.PERSON_ID
10WHERE ROWNUM <= 100
FULL_NAMEEMPLOYEE_NUMBERSTATUS
Ahmed Al-RashidEMP-00142ACTIVE
Sarah ConnorEMP-00143ACTIVE
John DoeEMP-00144INACTIVE
100 rows returned in 0.42sOracle Fusion Cloud · prod