If ORDS alone can expose the data as RESTful service , then what is the need of oracle Apex? What are the benefits that we are getting for using Apex with ORDS ? I am new to ORDS & I am confused why apex is used along with ORDS if ORDS alone can map rest API with SQL queries & return output data in JSON format.
APEX gives you a web-based user interface to administer REST functionality and develop other PL/SQL-based applications and user interfaces. APEX actually runs inside the database (it's all PL/SQL) and uses ORDS (fka the APEX Listener) to present itself through an application server like Tomcat or WebLogic to the web. ORDS by itself requires you to use SQL Developer to administer REST functionality. Here's a high-level description of the architecture: https://apex.oracle.com/en/platform/architecture/ and a FAQ page (if you haven't already seen it): https://www.oracle.com/tools/technologies/faq-rest-data-services.html