An Armstrong number is a number that is equal to the sum of its own digits raised to the power of the number of digits. Here is a simple PL/SQL program that can be used to find Armstrong numbers: declare ...
Discy Latest Articles
PL/SQL Program to Find the Largest of Two Numbers
To find the largest of two numbers using PL/SQL, you can use a SELECT statement with a comparison expression. The comparison expression can use the GREATER THAN operator (>) to compare the two numbers, and the result of the expression ...
PL/SQL Program to Reverse a String
To reverse a string using PL/SQL, you can iterate over the characters in the string in reverse order and append each character to a new string. This will create a new string that contains the characters of the original string ...
PL/SQL Program to Reverse a Number
To reverse a number using PL/SQL, you can convert the number to a string, iterate over the characters in the string in reverse order, and then convert the reversed string back to a number. Here is an example of how ...
PL/SQL Program to Add Two Numbers
To add two numbers using PL/SQL, you can use a SELECT statement with an arithmetic expression. The arithmetic expression can use the + operator to add the two numbers together, and the result of the expression will be returned by ...
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 ...