ORDS, SODA & JSON in the Database

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Fast API with only specific columns

Conor LynchMar 4 2019 — edited Mar 7 2019

Hi there,

We are currently developing PLSQL packages to return JSON for ORDS web services.

One question that arises again and again is how to write a fast API which will only retrieve the columns required in the web service.

Has anyone come up with a solution for this?

Options I've investigated so far are GraphQL and dynamic SQL.

Thanks,

Conor.

Added on Mar 4 2019

7 comments

1,359 views