1 Reply Latest reply on Dec 26, 2018 5:11 PM by thatJeffSmith-Oracle

    Provision in ORDS for handling queries involving joins across multiple tables

    Iqb

      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:

      employee:

      empid

      empname

      deptid

       

      dept:

      deptid

      deptname

       

       

      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.