-- https://docs.oracle.com/en/database/oracle/oracle-database/23/adjsn/data-type-considerations-json_value-indexing-and-querying.html
SELECT count(*) FROM j_purchaseorder po
  WHERE json_value(po_document, '$.PONumber' RETURNING NUMBER) > 1500;