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 ...
Home/PLSQL
Discy Latest Articles
Oracle PL/SQL Download BLOB File to Disk
VinishHere 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
VinishHere 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
VinishA 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 ...