9 SODA Feature Support
Features that are supported in different SODA implementations (languages) are listed, along with their required client versions and database releases.
Table 9-1 provides a general idea of the minimal database release and minimal driver version needed for a given feature. The feature names or descriptions are only roughly indicative. Refer to the documentation for a particular implementation for definitive and detailed information about any given feature.
Legend: the following abbreviations are used in the table.
-
X — The feature is not available.
-
NA — The feature is not applicable to the given implementation.
Table 9-1 Minimal Client and Server Versions for SODA Features
Feature | Oracle Database Release | PL/SQL Driver | OCI C DriverFoot 1 | Node.js DriverFoot 2 | Python DriverFoot 2 |
---|---|---|---|---|---|
Basic Collection Operations (Create, Open, List, Drop) |
Java or REST: 12.2 Others: 18.3 |
18.3 |
v18: 18.5 v19: 19.6 |
3.0 |
7.0 |
Metadata Cache |
Java or REST: 12.2 Others: 18.3 |
NA |
v19: 19.11 v21: 21.3 |
5.2 |
8.2 |
Insert Document, Replace Document, Remove Document |
Java or REST: 12.2 PL/SQL: 18.5 Others: 18.3 |
18.5 |
v18: 18.5 v19: 19.6 |
3.0 |
7.0 |
Bulk Insert |
Java or REST: 12.2 Others: 18.3 |
NA |
19.11 |
4.0 |
7.2 |
Save Document |
Java or REST: 12.2 PL/SQL: 19.9 Others: 18.3 |
19.9 |
19.9 |
5.0 |
8.0 |
Truncate Collection |
Java or REST: 12.2 PL/SQL: 19.11 Others: 18.3 |
19.11 |
19.11 |
5.0 |
8.0 |
QBE Filter |
Java or REST: 12.2 PL/SQL:
Others: 18.3 |
v18: 18.5 v19: 19.3 |
v18: 18.5 v19: 19.6 |
3.0 |
7.0 |
Pagination |
Java or REST: 12.2 PL/SQL:
Others: 18.3 |
v18: 18.5 v19: 19.3 |
v18: 18.5 v19: 19.6 |
3.0 |
7.0 |
Optimistic Locking |
Java or REST: 12.2 PL/SQL:
Others: 18.3 |
v18: 18.5 v19: 19.3 |
v18: 18.5 v19: 19.6 |
3.0 |
7.0 |
Iteration Document Cursor |
Java or REST: 12.2 PL/SQL:
Others: 18.3 |
v18: 18.5 v19: 19.3 |
v18: 18.5 v19: 19.6 |
3.0 |
7.0 |
Create Index (B-Tree, Search, Spatial) Drop Index |
Java or REST: 12.2 PL/SQL:
Others: 18.3 |
v18: 18.5 v19: 19.3 |
v18: 18.5 v19: 19.6 |
3.0 |
7.0 |
Data Guide Based on a Search Index |
Java or REST: 12.2 PL/SQL:
Others: 18.3 |
v18: 18.5 v19: 19.3 |
v18: 18.5 v19: 19.6 |
3.0 |
7.0 |
OSON Native JSON Storage Format |
Autonomous Database 19c |
19.1 |
19.1 |
3.0 |
7.0 |
|
21.1 |
21.1 |
21.1 |
5.1 |
8.1 |
Get Index |
v19: 19.13 v21: 21.3 |
v19: 19.13 v21: 21.3 |
v19: 19.13 v21: 21.3 |
X |
X |
List Indexes |
v19: 19.13 v21: 21.3 |
21.3 |
v19: 19.13 v21: 21.3 |
X |
X |
Create View From Data Guide |
Java or REST: 12.2 PL/SQL: 19.1 Others: 18.3 |
19.1 |
NA |
NA |
NA |
Array Fetch Documents |
Java or REST: 12.2 Others: 18.3 |
NA |
19.9 |
5.0 |
8.0 |
Online Redefinition of a Collection |
21.1 |
21.1 |
NA |
NA |
NA |
Pessimistic Locking |
Java or REST: 12.2 PL/SQL: 19.11 Others: 18.3 |
19.11 |
19.11 |
X |
X |
Flashback |
Java or REST: 12.2 PL/SQL: 19.11 Others: 18.3 |
19.11 |
19.11 |
X |
X |
Dynamic Data Guide |
Java or REST: 12.2 PL/SQL: 19.11 Others: 18.3 |
19.11 |
v19: 19.11 v21: 21.3 |
X |
X |
Hint (Monitoring) |
Java or REST: 12.2 PL/SQL: 19.11 Others: 18.3 |
19.11 |
v19: 19.11 v21: 21.3 |
5.2 |
8.2 |
Text Search of Non-JSON Documents |
Java or REST: 12.2 PL/SQL — v19: 19.13, v21: 21.3 Others: 18.3 |
v19: 19.13 v21: 21.3 |
v19: 19.13 v21: 21.3 |
3.0 |
7.0 |
Sampling Documents |
Java or REST: 12.2 PL/SQL — v19: 19.13, v21: 21.3 Others: 18.3 |
v19: 19.13 v21: 21.3 |
v19: 19.13 v21: 21.3 |
X |
X |
Footnote 1 Oracle Call Interface
Footnote 2 Support of Node.js and Python for a feature also requires the relevant minimal OCI driver version for that feature.
Related Topics