List of Examples

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