Full-Text Search Queries
The PL/SQL package DBMS_CLOUD
enables you to build a text index on the object store files, which allows you to search the text and use wildcards with your search. You can use JSON_TEXTCONTAINS
to do full-text JSON search on files stored in Object Storage.
- Use Full-Text Search on Files in Object Storage
The PL/SQL package DBMS_CLOUD enables you to build a text index on the object store files, which allows you to search the text and use wildcards with your search. - Use JSON Search on Documents in Object Storage
You can build a JSON search index on documents residing in files stored in Object Storage, which allows you to search fields in your JSON documents usingJSON_TEXTCONTAINS
, for example, searching with wildcards.
Parent topic: Features