Skip to Main Content

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!

How to query if schema is ords enabled

Mark W WisemanNov 9 2018 — edited Nov 9 2018

Hi,

I would like to execute a query to check if the schema has ords enabled.

Is there a view or table that I can query from to find this out?

I don't want to call ords.enable_schema() to enable or disable.  I just want to see if it is currently enabled or not.

Any ideas?

This post has been answered by thatJeffSmith-Oracle on Nov 9 2018
Jump to Answer
Comments
Post Details
Added on Nov 9 2018
2 comments
5,713 views