PLSQL

Here is an example of a PL/SQL program to calculate the factorial of a given number: PL/SQL Program to Calculate Factorial Example DECLARE num INTEGER := 5; factorial INTEGER := 1; BEGIN -- Calculate the factorial of the given number […] More

A procedure is similar to a PL/SQL block, but it has a name and is stored in the database permanently. The schema object is the main way that business logic is implemented on the server side. By breaking up complex […] More

In this tutorial, you will learn about exceptions in PL/SQL and how to write code to handle them. One of the most crucial stages of developing a database application is handling exceptions. Unhandled exceptions pose a threat to application availability, […] More

In this tutorial, I'll show you how to insert records into a table in Oracle using FOR LOOP on the cursor. Suppose you have the following table (emp_Sal): create table emp_sal ( empno number, sdate date, sal number, comm number, […] More

In PL/SQL, FOR loop allows for easy iteration over a cursor object's entire set of records. A CURSOR FOR loop is a FOR loop that initiates the opening of a cursor. The CURSOR FOR loop eliminates the need for the […] More

In this tutorial, you will learn, what is cursor in PL/SQL and how it works. One of the most important aspects of database programming is writing SQL in PL/SQL. All SQL statements contained within a PL/SQL block are processed as […] More