List of Examples

• 2-1        Enabling the PL/SQL Function
• 2-2        Enabling the PL/SQL Procedure
• 2-3        Generating an Endpoint for the Stored Procedure
• 2-4        Package Procedure and Function Endpoints
• 2-5        Nested JSON Purchase Order with Nested LineItems
• 2-6        PL/SQL Handler Code Used for a POST Request
• 2-7        GET Handler Code using Oracle REST Data Services Query on Relational Tables for Generating a Nested JSON object
• 2-8        PL/SQL API Call for Creating a New test/:id Template and GET Handler in the demo Module
• 2-9        
• 2-10      ACL Rule in the Database
• 2-11      Setting the Duser.timezone Java Environment Variable in a Standalone Mode
• 2-12      Setting the Duser.timezone Java Environment Variable in a Java Application Server
• 2-13      Creating a Scope-Based Pool-Level JWT Profile
• 2-14      Creating a Role-Based Pool-Level JWT Profile
• 2-15      Executing as a REST-enabled schema called ordstest
• 3-1        Automatic Binding on Query Parameters
• 3-2        Example
• 5-1        
• 5-2        
• 5-3        
• 5-4        
• 5-5        
• 6-1        Example to Add Multiple Privileges
• 8-1        
• 8-2        
• 8-3        
• 8-4        
• 8-5        
• 8-6        
• 8-7        
• 8-8        
• 8-9        
• 8-10      
• 8-11      
• 8-12      
• 8-13      
• 8-14      
• 8-15      
• 8-16      
• 8-17      
• 8-18      
• 8-19      
• 8-20      
• 8-21      
• 8-22      
• 8-23      
• 8-24      
• 8-25      
• 8-26      
• 8-27      
• 8-28      
• 8-29      
• 8-30      
• 8-31      
• 8-32      
• 9-1        
• 9-2        
• 9-3        
• 9-4        
• 9-5        
• 9-6        
• 9-7        
• 9-8        
• 9-9        
• 9-10      
• 9-11      
• 9-12      
• 9-13      
• 9-14      
• 9-15      
• 9-16      
• 9-17      
• 9-18      
• 9-19      
• 9-20      
• 9-21      
• 9-22      
• 9-23      
• 9-24      
• 9-25      
• 9-26      
• 9-27      
• 9-28      
• 9-29      
• 11-1      Export schema
• 11-2      Customizing content using parameters
• 11-3      Export REST module
• 11-4      Export customizing content using parameters
• 11-5      Exporting OAuth Client
• 12-1      Exporting with defaults
• 12-2      Exporting with parameters
• 12-3      Exporting with defaults
• 12-4      Exporting with parameters
• 12-5      Exporting with Defaults
• 12-6      Exporting with Parameters
• 14-1      Example cURL Command
• 14-2      Binds in POST Request
• 14-3      Complex Bind in POST Request
• 14-4      Batch statements
• 14-5      Batch bind values
• 14-6      Oracle REST Data services Time Zone Set as Europe/London
• 14-7      PL/SQL Statement
• 14-8      Script
• 14-9      Query
• 14-10    Export
• 15-1      Use of REST-enabled Object name with Special Character
• 15-2      cURL Command
• 15-3      Use of REST-Enabled Object whose columns contain a column with a special character in their name
• 15-4      Use of REST-enabled object whose columns contains a column with a special character in their name in GraphQL filter expression
• 16-1      Dependency Injection Example
• 17-1      dads.conf file
• 17-2      ords_conf/databases/basic_auth/pool.xml
• 17-3      ords_conf/databases/basic_dynamic_auth/pool.xml
• 17-4      ords_conf/databases/custom_auth/pool.xml
• 17-5      ords_conf/databases/basic_auth/paths
• 17-6      ords_conf/databases/basic_dynamic_auth/paths
• 17-7      ords_conf/databases/custom_auth/paths
• 17-8       ords_conf/global/settings.xml
• 17-9      security.requestValidationFunction
• 17-10    procedure.preProcess
• 17-11    procedure.postProcess
• 17-12    Table upload
• 17-13    Procedure upload
• 17-14    Curl command for file upload