DML Error Logging DBMS_ERRLOG

When you have an enormous load of data to copy/merge from one table to another, you are probably concerned about:

  • Performance: How fast can the program copy/merge all the data?
  • Exception handling: How well does the program deal with errors in the data? Can it highlight bad data if present in the lot, at the same time allow the good data to pass successfully?

Continue Reading …

{ 0 comments }

FORALL INSERT Bulk DML

Oracle PL/SQL gives you the ability to perform DML operations in bulk instead of via the regular row-by-row FOR loop. This article shows you how to use bulk DML and handle exceptions along the way.

Continue Reading …

{ 0 comments }

Thumbnail image for JSON_TABLE Options: Error Handling, Nested Path

JSON_TABLE Options: Error Handling, Nested Path

Various options that can be used with JSON_TABLE query operator to select JSON data as relational rows and columns: ERROR ON ERROR, FOR ORDINALITY, NESTED PATH etc.

Read the Full Article →
Thumbnail image for Unique Constraint vs Unique Index in Oracle

Unique Constraint vs Unique Index in Oracle

A unique constraint and a unique index, on the face of it, look very alike. Dig deeper, and you will see that they differ. A rundown of unique constraint vs unique index in Oracle.

Read the Full Article →
Thumbnail image for How to Lock a Row: SELECT FOR UPDATE

How to Lock a Row: SELECT FOR UPDATE

How to lock a row in Oracle and manage concurrency conflict during database transactions, with the use of the FOR UPDATE clause in SELECT statements.

Read the Full Article →
Thumbnail image for Crop a CLOB with DBMS_LOB FRAGMENT_DELETE

Crop a CLOB with DBMS_LOB FRAGMENT_DELETE

How to delete fragments from a CLOB, from either end, using the procedure DBMS_LOB.FRAGMENT_DELETE in Oracle.

Read the Full Article →
Thumbnail image for Extract Very Long String or CLOB from JSON [pre 12.2]

Extract Very Long String or CLOB from JSON [pre 12.2]

How to extract a very long string or CLOB from JSON CLOB data , where the size to be extracted exceeds MAX_STRING_SIZE (32767), in a pre-12.2 Oracle database.

Read the Full Article →
Convert Relational Data to JSON

Convert Relational Data to JSON in Oracle: PL/JSON Method

How to convert relational data to JSON in the Oracle database, using PL/JSON.

Read the Full Article →
Thumbnail image for JSON Conditionals: JSON_EXISTS, JSON_TEXTCONTAINS

JSON Conditionals: JSON_EXISTS, JSON_TEXTCONTAINS

Implement true/false tests on JSON documents in Oracle database 12c using JSON conditional logic: JSON_EXISTS and JSON_TEXTCONTAINS.

Read the Full Article →
Thumbnail image for Querying JSON Data in Oracle: SQL/JSON Query Functions, Dot Notation

Querying JSON Data in Oracle: SQL/JSON Query Functions, Dot Notation

Querying JSON data in Oracle 12c using various query approaches: simple SQL, SQL/JSON functions (JSON_QUERY, JSON_VALUE, JSON_TABLE), dot-notation syntax.

Read the Full Article →