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 using JSON_TEXTCONTAINS, for example, searching with wildcards.