AI-Assisted

Show where search words matched, with a highlighted extract from SNIPPET or the full document marked up by MARKUP.

Search text columns with Boolean, proximity, fuzzy, and stem operators, escape special characters, and count hits.

Make new and changed rows searchable in an Oracle Text index with SYNC_INDEX or automatic sync, and keep it optimized.

Register an XML schema in the database under a URL, and check whether XML documents follow its structure and rules.

Parse XML into a DOM tree in PL/SQL, read elements and attributes, add new elements, and write the document back out.

Turn XML in ROWSET and ROW form into inserts, updates, and deletes on a table, with key and update columns.

Turn any query result into an XML document with one element per row, and set the tag names, NULL handling, and row limit.

Work with XML documents in PL/SQL variables: find the root, extract nodes with XPath, test for nodes, and apply XSLT.

Work with JSON documents as a document store in PL/SQL: collections, keys, query-by-example filters, and replacements.

Infer tables and a JSON relational duality view from existing documents, generate the DDL, and import the documents.

Turn the fields of JSON documents into the columns of a relational view, generated from a search index data guide.

Check JSON documents against a schema in PL/SQL, get a report of every error, and generate schemas from tables.

Build JSON arrays element by element in PL/SQL, read them by position, and insert, remove, and check elements.

Read and change JSON documents step by step in PL/SQL, and move them between JSON columns and JSON_OBJECT_T.

Install a new version of PL/SQL code next to the old one in a new edition, test it, and switch sessions over without downtime.

Compare two versions of a table and generate the ALTER statements between them, then review what the script would do.

Script out the DDL of many objects at once, filtered by name or base table, with the DBMS_METADATA open-fetch-close API.

Rebuild the CREATE statement of any object from the data dictionary, with its indexes and constraints, ready to run as a script.