How to Print 1 to 10 Without Using Loop in PL/SQL?
Here I am giving an example to print 1 to 10 without using the loop in PL You can print up to any number by changing the value 10 to any number, for example, 100. PL/SQL Program to Print 1…
Category PLSQL
PL/SQL (Procedural Language for SQL) is Oracle's proprietary extension to standard SQL. It combines the data manipulation power of SQL with the procedural capabilities of a programming language. PL/SQL allows developers to write complex database-centric applications by incorporating variables, conditions, loops, error handling, and modular programming constructs like procedures and functions. This language is tightly integrated with Oracle databases, enabling efficient data processing and transaction management.
How to Validate Credit Card Number and Identify Its Type Using PL/SQL?
Here I am giving an example of PL/SQL stored function to validate the Credit Card number and identify its type, whether it is a Visa, MasterCard or American Express Credit Card. I am checking the Credit Card number using the…
How To Truncate Table In Oracle Procedure?
In Oracle, TRUNCATE command is a DDL statement, so you can not execute it directly in Oracle Procedure. To execute DDL commands in Oracle procedure, use EXECUTE IMMEDIATE statement. The below is an example of truncating a table in Oracle procedure…
How to Check if File is Image Using PL/SQL?
In this blog post, I am sharing a function with which you can check if a file is an image file or not using PL The program will check the file by reading its header not the extension name of…
How to Save BLOB as File in PL/SQL?
Here I am giving an example to save BLOB data as a file in PL BLOB data you can get it from the table having BLOB column, or you can get it from a file on the disk. PL/SQL Function…
How to Get BLOB from File in PL/SQL?
Below I am giving a function example to get the BLOB from a file in PL PL/SQL Function to Get BLOB from a File The following function will read a file and will return the BLOB data type of the…
How to Create Log File in Oracle Using PL/SQL?
You have a PL/SQL program, and you want to log information in a text file of each step of your code. Here is an example to create a log file in Oracle using PL Create Log File in Oracle Using…
How to Call Oracle Function in Python?
In this tutorial, you will learn how to call Oracle function in Python. I am giving an example by using cx_Oracle library callfunc function in the Python program. The following are the syntax details and the sample programs. CX_Oracle callfunc…
How to Call Oracle Stored Procedure in Python?
In this blog post, I am giving an example to call Oracle stored procedure in Python. Example include calling a stored procedure with IN-OUT parameters. I am using cx_Oracle library callproc function to call the Oracle procedure. To let you test this…
How to Check If File Exists in PL/SQL?
The following is a stored function example to check if a file exists in PL PL/SQL Function Example To Check If a File Exists The below function takes two parameters, one is for Oracle directory object name and the second…
How to Get File From BLOB in Oracle?
In this tutorial, you will learn how to get a file from BLOB column in Oracle. To give an example, I have created a table EXT_FILES in Oracle and following is the structure of the table. CREATE TABLE EXT_FILES ( FILE_NAME…
How to Insert a File in Oracle Database?
In this tutorial, you will learn how to insert a file in the Oracle database. The type of file can be a PDF, an Image, or any document. I am using the BLOB data type in Oracle table to demonstrate…
How to UNZIP a File in PL/SQL?
In my previous post, I have given an example to ZIP a file using PL/SQL in Oracle, and in this post, I am explaining to how to extract a ZIP file, or unzip a file in PL/SQL using the same Alexandria…
How to ZIP a File in PL/SQL?
In this blog post, I am giving an example to ZIP a file in PL I am using Alexandria PL/SQL Util Library to perform this task. The same library I used for the example of export data to Excel from…
Oracle Before Insert OR Update Trigger Example
The following is an Oracle BEFORE INSERT OR UPDATE Trigger example to perform validations while inserting or updating the records in EMP table. Oracle BEFORE INSERT OR UPDATE Trigger Example The below trigger will do the following two checks on…
How to Use Global Temporary Table in Oracle Procedure?
In Oracle, global temporary tables known as session tables and we use global temporary tables to keep the data temporarily in it while processing. The below is an example. Create a Global Temporary Table Here we will create a global…
Oracle Trigger WHEN Clause Example
In this article, you will learn how to use WHEN clause in Oracle trigger to make the trigger fire on the specified condition. Below is an example. You can test this trigger example by creating the following table and trigger…
Table Type in Oracle Stored Procedure Example
The following is an example of Oracle stored procedure, in which table type collection is used to process the data. Process Data Using Table Type in Oracle Stored Procedure Example Create the following tables and insert the data to test…