Thumbnail image for FORALL INSERT: Exception Handling in Bulk DML

FORALL INSERT: Exception Handling in Bulk DML

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

Read the Full Article →
Thumbnail image for JSON_TABLE Options: Error Handling, Nested Path

JSON_TABLE Options: Error Handling, Nested Path

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

Unique constraints and unique indexes, on the surface, seem very alike. Dig deeper, and you will see that they differ. Let’s see how.

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 , 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 →
JSON in the database

Storing JSON Data in Oracle: Why and How

Storing JSON data in Oracle has been made easy in version 12c. A demo of how JSON can be stored in Oracle and validated using the IS JSON check.

Read the Full Article →
Page 2 of 13
1
2
3
4
5
6
...
13