pl sql

PL/SQL Procedure The PL/SQL stored procedure or simply a procedure is a PL/SQL block which performs one or more specific tasks. It…

PL/SQL Trigger Trigger is invoked by Oracle engine automatically whenever a specified event occurs.Trigger is stored into database and invoked repeatedly, when…

PL/SQL Tutorial PL/SQL tutorial provides basic and advanced concepts of SQL. Our PL/SQL tutorial is designed for beginners and professionals. PL/SQL is…

PL/SQL Variables A variable is a meaningful name which facilitates a programmer to store data temporarily during the execution of code. It…

PL/SQL While Loop PL/SQL while loop is used when a set of statements has to be executed as long as a condition…

PL/SQL Case Statement The PL/SQL CASE statement facilitates you to execute a sequence of satatements based on a selector. A selector can…

PL/SQL Constants A constant is a value used in a PL/SQL block that remains unchanged throughout the program. It is a user-defined…

PL/SQL Continue Statement The continue statement is used to exit the loop from the reminder if its body either conditionally or unconditionally…

PL/SQL Cursor When an SQL statement is processed, Oracle creates a memory area known as context area. A cursor is a pointer…

PL/SQL Exception Handling What is Exception An error occurs during the program execution is called Exception in PL/SQL. PL/SQL facilitates programmers to…