Search code examples
oracle-databaseoracle-ords

Oracle Rest – filtering by columns (vertical filtering)

I would like to specify in Oracle REST query which columns should be returned in the select statement.

One of the solution would be to use view, however in my case I would like to select columns in a dynamic fashion.

Such functionality is available in PostgREST: http://postgrest.org/en/v6.0/api.html#vertical-filtering-columns

Is there such feature in Oracle REST Data Services?

Solution

  • No, we offer row filtering but not column selection.

    So i can say which rows I want to come back via the URI, but I cannot say which columns I want.

    So if you REST enable a table or view, it will be all of those columns, of it it's a RESTful Service, it will be the columns you have included in your SELECT.

    Something else to keep in mind, we do have a REST Enabled SQL Feature...where you POST your query, and we get you the results. So in the POST you could specify the columns you want.