Oracle
Countries
Output similar to the COUNTRIES table from the Oracle HR sample database.
API Endpoint (click to try):
Parameters:
| Name |
Type |
Default |
Default Value |
| DIST_REGION_ID |
VARCHAR2 |
Y |
|
Example output:
{
"countries":[
{
"COUNTRY_ID":"TJ"
,"COUNTRY_NAME":"Tajikistan"
,"REGION_ID":1
}
,{
"COUNTRY_ID":"GM"
,"COUNTRY_NAME":"Gambia"
,"REGION_ID":1
}
]
}
Departments
Output similar to the DEPARTMENTS table from the Oracle HR sample database.
API Endpoint (click to try):
Parameters:
| Name |
Type |
Default |
Default Value |
| DIST_LOCATION_ID |
VARCHAR2 |
Y |
|
Example output:
{
"departments":[
{
"DEPARTMENT_ID":192
,"DEPARTMENT_NAME":"Logistics"
,"MANAGER_ID":104
,"LOCATION_ID":1278
}
,{
"DEPARTMENT_ID":202
,"DEPARTMENT_NAME":"Finance"
,"MANAGER_ID":113
,"LOCATION_ID":1278
}
]
}
Dept
Output similar to the DEPT table from the original Scott/Tiger sample database.
API Endpoint (click to try):
Parameters:
| Name |
Type |
Default |
Default Value |
Example output:
{
"dept":[
{
"DEPTNO":21
,"DNAME":"Human Resources"
,"LOC":"Port St. Lucie"
}
,{
"DEPTNO":31
,"DNAME":"Logistics"
,"LOC":"Cambridge"
}
]
}
Emp
Output similar to the EMP table from the original Scott/Tiger sample database.
API Endpoint (click to try):
Parameters:
| Name |
Type |
Default |
Default Value |
| DIST_MGR |
VARCHAR2 |
Y |
|
| DIST_DEPTNO |
VARCHAR2 |
Y |
|
Example output:
{
"emp":[
{
"EMPNO":1194
,"ENAME":"Sanders"
,"JOB":"Decan"
,"HIREDATE":"2022-08-18T16:20:50Z"
,"SAL":2237
,"COMM":0
,"DEPTNO":21
}
,{
"EMPNO":1207
,"ENAME":"Wright"
,"JOB":"Distribution Manager"
,"MGR":1194
,"HIREDATE":"2022-09-29T21:35:30Z"
,"SAL":1976
,"COMM":0
,"DEPTNO":21
}
]
}
Employees
Output similar to the EMPLOYEES table from the Oracle HR sample database.
API Endpoint (click to try):
Parameters:
| Name |
Type |
Default |
Default Value |
| DIST_JOB_ID |
VARCHAR2 |
Y |
|
| DIST_MANAGER_ID |
VARCHAR2 |
Y |
|
| DIST_DEPARTMENT_ID |
VARCHAR2 |
Y |
|
Example output:
{
"employees":[
{
"EMPLOYEE_ID":100
,"FIRST_NAME":"Evelyn"
,"LAST_NAME":"Robinson"
,"EMAIL":"OUDLIBE"
,"PHONE_NUMBER":"782 737 1511"
,"HIRE_DATE":"2006-03-04T20:20:10Z"
,"JOB_ID":"FE_FPI"
,"SALARY":15400
,"COMMISSION_PCT":0.34
,"DEPARTMENT_ID":192
}
,{
"EMPLOYEE_ID":101
,"FIRST_NAME":"William"
,"LAST_NAME":"Diaz"
,"EMAIL":"YKUGT"
,"PHONE_NUMBER":"687 455 7528"
,"HIRE_DATE":"2004-07-11T12:31:51Z"
,"JOB_ID":"FE_FPI"
,"SALARY":5400
,"COMMISSION_PCT":0.28
,"MANAGER_ID":100
,"DEPARTMENT_ID":192
}
]
}
Job_History
Output similar to the JOB_HISTORY table from the Oracle HR sample database.
API Endpoint (click to try):
Parameters:
| Name |
Type |
Default |
Default Value |
| DIST_EMPLOYEE_ID |
VARCHAR2 |
Y |
|
| DIST_JOB_ID |
VARCHAR2 |
Y |
|
| DIST_DEPARTMENT_ID |
VARCHAR2 |
Y |
|
Example output:
{
"job_history":[
{
"EMPLOYEE_ID":101
,"START_DATE":"2010-04-06T12:15:25Z"
,"END_DATE":"2022-04-10T08:15:53Z"
,"JOB_ID":"GP_ZUF"
,"DEPARTMENT_ID":202
}
,{
"EMPLOYEE_ID":101
,"START_DATE":"2009-06-08T06:02:09Z"
,"END_DATE":"2010-05-05T20:37:19Z"
,"JOB_ID":"GP_ZUF"
,"DEPARTMENT_ID":202
}
]
}
Jobs
Output similar to the JOBS table from the Oracle HR sample database.
API Endpoint (click to try):
Parameters:
| Name |
Type |
Default |
Default Value |
Example output:
{
"jobs":[
{
"JOB_ID":"DC_JC"
,"JOB_TITLE":"Receptionist"
,"MIN_SALARY":16700
,"MAX_SALARY":18400
}
,{
"JOB_ID":"GF_HFUEB"
,"JOB_TITLE":"Telemarketing"
,"MIN_SALARY":16100
,"MAX_SALARY":21900
}
]
}
Locations
Output similar to the LOCATIONS table from the Oracle HR sample database.
API Endpoint (click to try):
Parameters:
| Name |
Type |
Default |
Default Value |
| DIST_COUNTRY_ID |
VARCHAR2 |
Y |
|
Example output:
{
"locations":[
{
"LOCATION_ID":1278
,"STREET_ADDRESS":"214 Pidkav Park"
,"POSTAL_CODE":"59750"
,"CITY":"Sacramento"
,"STATE_PROVINCE":"Wyoming"
,"COUNTRY_ID":"SV"
}
,{
"LOCATION_ID":1378
,"STREET_ADDRESS":"229 Memokod Street"
,"POSTAL_CODE":"87401"
,"CITY":"Westerly"
,"STATE_PROVINCE":"Virginia"
,"COUNTRY_ID":"VN"
}
]
}
Regions
Output similar to the REGIONS table from the Oracle HR sample database.
API Endpoint (click to try):
Parameters:
| Name |
Type |
Default |
Default Value |
Example output:
{
"regions":[
{
"REGION_ID":1
,"REGION_NAME":"Georgia"
}
,{
"REGION_ID":2
,"REGION_NAME":"Delaware"
}
]
}