SODA Feature Support
The script content on this page is for navigation purposes only and does not alter the content in any way.
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 1 Minimal Client and Server Versions for SODA Features
| Feature | Oracle Database Release | PL/SQL Driver | OCI C Driver1 | Node.js Driver2 | Python Driver2 |
|---|---|---|---|---|---|
| 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 |
JSON Data Type Storage |
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 |
Related Topics