Oracle REST Data Services (ORDS) provides REST APIs for Oracle Database & the JSON Document Store (SODA) plus the Database Actions (SQL Developer Web) App.
- Tweets 767
- Following 71
- Followers 3,125
- Likes 164
![GraphQL query for Oracle - top 5 paid employees per department
{
locations {
city
departments_location_id {
department_name
employees_department_id(sort : [ { salary : "desc" } ], limit:5 ) {
first_name
last_name
salary
}
}
}
}](/pic/orig/media%2FF_-AJP_XcAAMYaN.jpg)
ALT GraphQL query for Oracle - top 5 paid employees per department { locations { city departments_location_id { department_name employees_department_id(sort : [ { salary : "desc" } ], limit:5 ) { first_name last_name salary } } } }
ALT The definition and implementation of our POST REST API to add an employee to our EMPS table
ALT Calling our POST REST API to add an EMP to our EMPS table, and the response which has a link to our new employee
ALT If we follow the link from our 201 response, we can see the new employee that has been added to the system, or our EMPS table
ALT A sample REST API with GET handler to test your Oracle Database configuration with REST Data Services (ORDS), begin ORDS_METADATA.ORDS.create_service( p_module_name => 'day_zero', p_base_path => 'day0', p_pattern => 'greeting/', p_method => 'GET', p_source_type => 'json/item', p_source => 'select ''Hello!'' from dual', p_status => 'PUBLISHED', p_module_comments => 'see if we can create a module', p_template_comments => 'see if we can create a template', p_handler_comments => 'see if we can say Hello!'); COMMIT; END; /
ALT Defining and calling an Oracle Database REST API that is implemented via PL/SQL and generates a LINK in the JSON response payload
