How to Update Large Tables in Chunks with DBMS_PARALLEL_EXECUTE
Run a large UPDATE as many small committed chunks in parallel jobs, and resume the chunks that fail.
PLSQL
PL/SQL (Procedural Language for SQL) is Oracle's proprietary extension to standard SQL. It combines the data manipulation power of SQL with the procedural capabilities of a programming language. PL/SQL allows developers to write complex database-centric applications by incorporating variables, conditions, loops, error handling, and modular programming constructs like procedures and functions. This language is tightly integrated with Oracle databases, enabling efficient data processing and transaction management.
How to Redefine Tables Online with DBMS_REDEFINITION
Partition a table or change its columns while it stays in use, with an interim table and DBMS_REDEFINITION.
How to Sync Tables with DBMS_COMPARISON.CONVERGE
Find the rows that differ between two copies of a table, then make one copy match the other with CONVERGE.
How to Use DBMS_FLASHBACK in PL/SQL
Make every query of a session see the database as it was at an earlier SCN or time, then return to the present.
How to Exchange Values with JavaScript in DBMS_MLE
Send PL/SQL values into JavaScript, compute with them, and read the results back into PL/SQL variables.
How to Run JavaScript Dynamically with DBMS_MLE
Evaluate JavaScript source at run time inside the database, run SQL from JavaScript, and find where JavaScript errors happened.
How to Use Ubiquitous Search with DBMS_SEARCH
Build one search index over several tables and every column, and find matching rows in all of them with one query.
How to Highlight Search Results with CTX_DOC.SNIPPET
Show where search words matched, with a highlighted extract from SNIPPET or the full document marked up by MARKUP.
How to Write Oracle Text CONTAINS Queries (CTX_QUERY)
Search text columns with Boolean, proximity, fuzzy, and stem operators, escape special characters, and count hits.
How to Sync Oracle Text Indexes with CTX_DDL.SYNC_INDEX
Make new and changed rows searchable in an Oracle Text index with SYNC_INDEX or automatic sync, and keep it optimized.
How to Register XML Schemas with DBMS_XMLSCHEMA
Register an XML schema in the database under a URL, and check whether XML documents follow its structure and rules.
How to Parse XML with DBMS_XMLDOM
Parse XML into a DOM tree in PL/SQL, read elements and attributes, add new elements, and write the document back out.
How to Save XML to Tables with DBMS_XMLSTORE
Turn XML in ROWSET and ROW form into inserts, updates, and deletes on a table, with key and update columns.
How to Generate XML from Queries with DBMS_XMLGEN
Turn any query result into an XML document with one element per row, and set the tag names, NULL handling, and row limit.
How to Use XMLTYPE Methods in PL/SQL
Work with XML documents in PL/SQL variables: find the root, extract nodes with XPath, test for nodes, and apply XSLT.
How to Use SODA in PL/SQL (DBMS_SODA)
Work with JSON documents as a document store in PL/SQL: collections, keys, query-by-example filters, and replacements.
How to Generate Duality Views with DBMS_JSON_DUALITY
Infer tables and a JSON relational duality view from existing documents, generate the DDL, and import the documents.
How to Create Views on JSON with DBMS_JSON
Turn the fields of JSON documents into the columns of a relational view, generated from a search index data guide.