ORDS enables the Oracle database objects as REST API on which CRUD operations can be performed. However I would like to understand is there any provision there to handle the queries invoving multiple tables via JOINS.
For example, say I have a query like this:
select empname from employee e,dept d where e.deptid=d.deptid and deptname='IT';
Below is the table meta-data:
I do understand that we can create a handler wherein we can mention this query in the source and expose an ORDS API corresponding to this. However, I would like to expose only the database objects as REST APIs instead of creating handlers for each query.
Create a VIEW, and then REST enable that view.