Table of Contents
- Title and Copyright Information
- Preface
- Introduction to Oracle REST Data Services
- Developing Oracle REST Data Services Applications
- Introduction to Relevant Software
- Getting Started with RESTful Services
- Automatic Enabling of Schema Objects for REST Access (AutoREST)
- Examples: Accessing Objects Using RESTful Services
- Get Schema Metadata
- Get Object Metadata
- Get Object Data
- Get Table Data Using Paging
- Get Table Data Using Query
- Get Table Row Using Primary Key
- Insert Table Row
- Update/Insert Table Row
- Delete Using Filter
- Post by Batch Load
- Retrieving BLOB or CLOB in AutoREST Requests
- Using REST-enabled Objects for Vector Search Queries
- Filtering in Queries
- Auto PL/SQL
- Support for JSON-Relational Duality View
- Support for VECTOR Datatype
- Examples: Accessing Objects Using RESTful Services
- Manually Creating RESTful Services Using SQL and PL/SQL
- Manually Creating RESTful Services Using Javascript
- About Working with Dates Using Oracle REST Data Services
- Creating RESTful Web Services Using Database Actions
- Configuring Secure Access to RESTful Services
- JWT Profile and JWT Profile RBAC
- JWT Bearer Token Authentication and Authorization Using JWT Profile
- JWT Bearer Token Authentication and Authorization Using JWT Profile RBAC
- Pool Level JWT Profile
- About Oracle REST Data Services User Roles
- Authenticating Against WebLogic Server User Repositories
- Integrating with Existing Group/Role Models
- Integrating Oracle REST Data Services and WebLogic Server
- Using the Oracle REST Data Services PL/SQL API
- Oracle REST Data Services Pre-Authenticated Requests
- Overview of Pre-hook Functions
- Configuring the Pre-hook Function
- Using a Pre-hook Function
- Processing of a Request
- Identity Assertion of a User
- Aborting Processing of a Request
- Ensuring Pre-hook is Executable
- Exceptions Handling by Pre-hook Function
- Pre-hook Function Efficiency
- Using Pre-hook Function with Protected Resources
- Pre-Hook Examples
- Generating Hyperlinks
- About HTTP Error Responses
- Sessionless Transactions
- Using ORDS Model Context Protocol (MCP)
- About ORDS MCP
- About ORDS MCP Server Tools
- Understanding the ORDS MCP Workflow
- Preparing the Environment for ORDS MCP
- Configure MCP Deep Data Security
- Custom SQL Tools and Reports
- MCP Authentication and Discovery
- MCP Protocol Requests
- Connecting to the ORDS MCP Server
- Discover ORDS MCP Tools
- Discover Authorized Databases
- Inspect Schema Metadata
- Execute SQL
- Understanding Authorization Failures
- Monitoring the ORDS MCP Server
- Monitoring the ORDS MCP Server
- Database Session Identity Attributes
- Correlating Database Activity with ORDS Logs
- Implicit Parameters
- List of Implicit Parameters
- ORDS PL/SQL Package Reference
- ORDS.CREATE_ROLE
- ORDS.CREATE_SERVICE
- ORDS.DEFINE_HANDLER
- ORDS.DELETE_HANDLER
- ORDS.DELETE_ALL_HANDLERS
- ORDS.DEFINE_MODULE
- ORDS.DEFINE_PARAMETER
- ORDS.DEFINE_PRIVILEGE
- ORDS.DEFINE_SERVICE
- ORDS.DEFINE_TEMPLATE
- ORDS.DELETE_TEMPLATE
- ORDS.DELETE_ALL_TEMPLATES
- ORDS.DELETE_MODULE
- ORDS.DELETE_PRIVILEGE
- ORDS.DELETE_ROLE
- ORDS.DROP_REST_FOR_SCHEMA
- ORDS.ENABLE_OBJECT
- ORDS.DROP_REST_FOR_OBJECT
- ORDS.ENABLE_SCHEMA
- ORDS.PUBLISH_MODULE
- ORDS.RENAME_MODULE
- ORDS.RENAME_PRIVILEGE
- ORDS.RENAME_ROLE
- ORDS.SET_MODULE_ORIGINS_ALLOWED
- ORDS.SET_URL_MAPPING
- ORDS.SET_SESSION_DEFAULTS
- ORDS.RESET_SESSION_DEFAULTS
- ORDS.SET_PROPERTY
- ORDS.UNSET_PROPERTY
- ORDS.INSTALLED_VERSION
- ORDS.SET_MODULE_PRIVILEGE
- Oracle REST Data Services Administration PL/SQL Package Reference
- ORDS_ADMIN.CREATE_ROLE
- ORDS_ADMIN.DEFINE_HANDLER
- ORDS_ADMIN.DELETE_HANDLER
- ORDS_ADMIN.DELETE_ALL_HANDLERS
- ORDS_ADMIN.DEFINE_MODULE
- ORDS_ADMIN.DEFINE_PARAMETER
- ORDS_ADMIN.DEFINE_PRIVILEGE
- ORDS_ADMIN.DEFINE_SERVICE
- ORDS_ADMIN.DEFINE_TEMPLATE
- ORDS_ADMIN.DELETE_TEMPLATE
- ORDS_ADMIN.DELETE_ALL_TEMPLATES
- ORDS_ADMIN.DELETE_MODULE
- ORDS_ADMIN.DELETE_PRIVILEGE
- ORDS_ADMIN.DELETE_ROLE
- ORDS_ADMIN.DROP_REST_FOR_SCHEMA
- ORDS_ADMIN.ENABLE_OBJECT
- ORDS_ADMIN.DROP_REST_FOR_OBJECT
- ORDS_ADMIN.ENABLE_SCHEMA
- ORDS_ADMIN.PUBLISH_MODULE
- ORDS_ADMIN.RENAME_MODULE
- ORDS_ADMIN.RENAME_PRIVILEGE
- ORDS_ADMIN.RENAME_ROLE
- ORDS_ADMIN.SET_MODULE_ORIGINS_ALLOWED
- ORDS_ADMIN.SET_URL_MAPPING
- ORDS_ADMIN.ENABLE_HOUSEKEEPING_JOB
- ORDS_ADMIN.DROP_HOUSEKEEPING_JOB
- ORDS_ADMIN.PERFORM_HOUSEKEEPING
- ORDS_ADMIN.SET_SESSION_DEFAULTS
- ORDS_ADMIN.RESET_SESSION_DEFAULTS
- ORDS_ADMIN.PROVISION_ADMIN_ROLE
- ORDS_ADMIN.PROVISION_RUNTIME_ROLE
- ORDS_ADMIN.UNPROVISION_ ROLES
- ORDS_ADMIN.CONFIG_PLSQL_GATEWAY
- ORDS_ADMIN.SET_PROPERTY
- ORDS_ADMIN.SET_PROPERTY
- ORDS_ADMIN.UNSET_PROPERTY
- ORDS_ADMIN.INSTALLED_VERSION
- ORDS_ADMIN.SET_MODULE_PRIVILEGE
- OAUTH PL/SQL Package Reference
- OAUTH_ADMIN PL/SQL Package Reference
- ORDS_SECURITY PL/SQL Package Reference
- CREATE_JWT_PROFILE
- REGISTER_CLIENT
- REGISTER_CLIENT
- IMPORT_CLIENT
- IMPORT_CLIENT
- REGISTER_CLIENT_SECRET
- GRANT_CLIENT_ROLE
- GRANT_CLIENT_ROLE
- UPDATE_CLIENT
- UPDATE_CLIENT
- UPDATE_CLIENT
- UPDATE_CLIENT
- UPDATE_CLIENT_LOGO
- UPDATE_CLIENT_PRIVILEGES
- UPDATE_CLIENT_PRIVILEGES
- UPDATE_CLIENT_TOKEN_DURATION
- UPDATE_CLIENT_TOKEN_DURATION
- RENAME_CLIENT
- RENAME_CLIENT
- ROTATE_CLIENT_SECRET
- ROTATE_CLIENT_SECRET
- DELETE_JWT_PROFILE
- DELETE_CLIENT
- DELETE_CLIENT
- REVOKE_CLIENT_ROLE
- REVOKE_CLIENT_ROLE
- REVOKE_CLIENT_SECRETS
- REVOKE_CLIENT_SECRET
- ORDS_SECURITY_ADMIN PL/SQL Package Reference
- CREATE_JWT_PROFILE
- REGISTER_CLIENT
- REGISTER_CLIENT
- IMPORT_CLIENT
- IMPORT_CLIENT
- REGISTER_CLIENT_SECRET
- REGISTER_CLIENT_SECRET
- GRANT_CLIENT_ROLE
- UPDATE_CLIENT
- UPDATE_CLIENT
- UPDATE_CLIENT_LOGO
- UPDATE_CLIENT_LOGO
- UPDATE_CLIENT_PRIVILEGES
- UPDATE_CLIENT_PRIVILEGES
- UPDATE_CLIENT_TOKEN_DURATION
- UPDATE_CLIENT_TOKEN_DURATION
- RENAME_CLIENT
- RENAME_CLIENT
- ROTATE_CLIENT_SECRET
- ROTATE_CLIENT_SECRET
- ROTATE_ALL_SECURITY_KEYS
- ROTATE_SECURITY_KEYS
- DELETE_CLIENT
- DELETE_CLIENT
- REVOKE_CLIENT_ROLE
- REVOKE_CLIENT_SECRETS
- REVOKE_CLIENT_SECRETS
- ORDS_PAR PL/SQL Package Reference
- ORDS_EXPORT PL/SQL Package Reference
- ORDS_EXPORT_ADMIN PL/SQL Package Reference
- Enabling ORDS Database API
- REST-Enabled SQL Service
- REST-Enabled SQL Service Terminology
- Configuring the REST-Enabled SQL Service
- Using cURL with REST-Enabled SQL Service
- Getting Started with the REST-Enabled SQL Service
- REST-Enabled SQL Service Examples
- REST-Enabled SQL Request and Response Specifications
- Supported SQL, SQL*Plus, and SQLcl Statements
- REST-Enabled SQL Service and MySQL Database
- GraphQL in Oracle REST Data Services
- GraphQL Terminology
- Enabling GraphQL in Oracle REST Data Services
- Enabling Objects for GraphQL
- Accessing Objects Using GraphQL queries
- Examples of Filtering in Queries
- Supported Data Types
- Filtering by Primary Key
- Where Filter
- Example: EQUALS (eq) operator
- Example: Greater than (>) Operator and Date Data Type
- Example: LIKE (like) operator
- Example: IN (in) operator
- Example: NOT (not) Operator
- Example: AND (and) operator
- Example: OR (or) operator
- Example: Where Filter in Children Types
- Working with Dates/Timestamps Using Filters
- Accessing REST-Enabled Objects that Contain Special Characters
- Sorting the Data
- Keyset Pagination
- Using Dynamic Arguments in Queries: Variables
- GraphiQL
- Extending ORDS Functionality with Plugins
- PL/SQL Gateway
- Oracle HTTP Server mod_plsql Authentication
- Example Oracle HTTP Server DAD file
- Mapping mod_plsql Settings to ORDS
- Example ORDS Configuration Files
- Example ORDS URL Mapping
- Example ORDS Default Configuration
- Oracle REST Data Services Functionality
- ORDS Features
- Modifying Synonyms
- Setting-up a PL/SQL Gateway User
- Oracle REST Data Services Database Type Mappings
- Troubleshooting Oracle REST Data Services
- Third-Party License Information
- ANTLR4 Java Runtime 4.13.2
- Hack 3.003
- Monaco Editor 0.55.1
- MongoDB bson 5.3.1
- gridstack.js 12.4.2
- Dexie 4.2.1
- react 19.2.3
- react-dom 19.2.3
- requirejs 2.3.7
- hotkeys-js 3.13.15
- Npm/Lodash 4.18.1
- Jetty 12.0.34
- jaxb-runtime 4.0.5
- jackson-core 2.18.6
- Jakarta Servlet 4.0.4
- jakarta.inject-api 2.0.1
- jQuery UI 1.14.1
- jackson-annotations 2.18.6
- jackson-databind 2.18.6
- graphql-js 16.11.0
- graphql-compose 9.1.0
- graphiql 5.2.2
- JavaScript Extension Toolkit (JET) 18.1.5
- Commons FileUpload 1.6.0
- opentelemetry-api 1.54.1
- opentelemetry-context 1.54.1
- Google Guava 33.4.8
- Eclipse Parsson 1.1.7
- commons-io 2.19.0
- Join Monster 4.0.0
- SheetJS 0.20.3
- OCI SDK for Java 3.78.1
- swagger-ui 5.31.0
- swagger-parser-v3 2.1.24
- Commons Compress 1.27.1
- caffeine 3.2.0
- fast-xml-parser 5.3.6