PL/SQL

PL/SQL (Procedural Language/Structured Query Language) is Oracle’s procedural extension for SQL. PL/SQL includes features such as conditional statements, loop processing and exception handling.

Thumbnail image for DETERMINISTIC Functions in Oracle

DETERMINISTIC Functions in Oracle

Deterministic functions always produce the same output for a given input. Learn how Oracle uses the DETERMINISTIC clause for optimizing function calls.

Read the Full Article →
Thumbnail image for How to Keep the Response Body with Non-2xx Responses in UTL_HTTP

How to Keep the Response Body with Non-2xx Responses in UTL_HTTP

Web service error handling options in PL/SQL UTL_HTTP, and how to make use of SET_RESPONSE_ERROR_CHECK to keep the response body with non-2xx responses.

Read the Full Article →
Thumbnail image for Running Procedures Asynchronously with Oracle Job Scheduler

Running Procedures Asynchronously with Oracle Job Scheduler

Oracle PL/SQL provides the ability to run procedures asynchronously using Oracle job scheduler DBMS_SCHEDULER. Here’s how to create and run such jobs.

Read the Full Article →
Thumbnail image for Java Stored Procedures in Oracle

Java Stored Procedures in Oracle

On why you would want Java stored procedures in Oracle, and how to store and invoke these stored procedures via call specifications.

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 →
XMLTABLE to convert XML to relational data

XMLTABLE: Convert XML Data to Relational Form

Using the SQL/XML function XMLTABLE in Oracle database 12c, to map XML data into relational rows and columns.

Read the Full Article →
When should we use dynamic SQL

When Should We Use Dynamic SQL?

We know that, if there exists a choice between static SQL vs dynamic SQL, static SQL is the way to go. In that case, why and when should we use dynamic SQL?

Read the Full Article →
Page 1 of 4
1
2
3
4