23 Full-Text Search Queries

You can use Oracle SQL condition json_textcontains in a CASE expression or the WHERE clause of a SELECT statement to perform a full-text search of JSON data. You can use PL/SQL procedure CTX_QUERY.result_set to perform facet search over JSON data.

• Oracle SQL Condition JSON_TEXTCONTAINS
  You can use Oracle SQL condition json_textcontains in a CASE expression or the WHERE clause of a SELECT statement to perform a full-text search of JSON data.
• JSON Facet Search with PL/SQL Procedure CTX_QUERY.RESULT_SET
  If you have created a JSON search index then you can also use PL/SQL procedure CTX_QUERY.result_set to perform facet search over JSON data. This search is optimized to produce various kinds of search hits all at once, rather than, for example, using multiple separate queries with SQL function contains.