Designing and creating APIs with PL/SQL and ORDS

Oracle REST Data Services (ORDS) offers a powerful way to expose Oracle DB functionality over RESTful APIs. During this session, we’ll explore how developers can quickly build secure, high-performance, and scalable APIs using SQL and PL/SQL.

The presentation will include:
- creating ORDS modules, templates and handlers,
- practical patterns for defining REST endpoints,
- use of HTTP methods for CRUD operations,
- JSON design principles and working with JSON payloads,
- using HTTP response codes,
- pagination and filtering,
- adding OAuth2 security, and
- documenting your API with OpenAPI