When working with nullable fields, it's important to understand that NULL does not behave like a typical numeric value. If you try to add 1 to a NULL in PL/SQL (null + 1), the resulting value will itself be NULL ...
Discy Latest Articles
Null in PL/SQL: Definition, Uses, and Best Practices
In PL/SQL, null represents the absence of a value or the unknown state. It is not the same as zero or an empty string; rather, it signifies the absence of any defined data. It can be used to indicate missing ...
PL/SQL GOTO Examples
In this tutorial, we will explore the GOTO statement examples in PL/SQL, a procedural extension of SQL used in Oracle databases. The GOTO statement is a control structure used to alter the flow of execution in a program. While it's ...
PL/SQL CASE Examples
The PL/SQL CASE statement is a control structure that allows you to execute a sequence of statements based on a condition or the value of an expression. It's akin to the switch statement in other programming languages and provides a ...
PL/SQL IF Condition Examples
Welcome to a detailed tutorial on using IF conditions in PL/SQL. PL/SQL, Oracle Database's procedural extension to SQL, offers robust control structures like IF conditions. These conditions are essential for decision-making in your PL/SQL programs, enabling you to execute code ...
How to Create a Table in PL/SQL Procedure in Oracle?
In Oracle PL/SQL, you can create a table within a PL/SQL procedure using the EXECUTE IMMEDIATE statement to execute a dynamic SQL statement that contains the CREATE TABLE statement. Here's a step-by-step guide on how to create a table in ...
What is the difference between constraints and triggers in Oracle?
In this tutorial, First, we would be discussing what is constraints and their types, and secondly, about the Oracle triggers and the usages before we could see the major difference between constraints and triggers. CONSTRAINTS: In Oracle, the constraints are ...
Oracle PL/SQL Download BLOB File to Disk
Here is an example of Oracle PL/SQL stored procedure to download BLOB file to disk. Oracle PL/SQL Stored Procedure Example to Download BLOB as File The following PL/SQL procedure takes three arguments. First, Oracle Directory object name, second, file name, ...
Oracle Convert External File to BLOB
Here is an example of the Oracle PL/SQL program to convert an external file to BLOB. Oracle PL/SQL Function Example to Convert an External File to BLOB In Oracle, you can reference an external file using the BFILENAME() function by ...
PL/SQL Character Set
A PL/SQL program is a sequence of statements, contains multiple lines of text. The types of characters available depend on the database character set you’re using. To know your current Oracle Database character set, run the following SQL statement: Get ...