cursor

MySQL Versions Versioning is a process of categorizing either unique version names or numbers to the unique set of software program as…

MySQL Workbench (Download and Installation) MySQL Workbench is a unified visual database designing or graphical user interface tool used for working with…

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…

PL/SQL Exit Loop (Basic Loop) PL/SQL exit loop is used when a set of statements is to be executed at least once…

PL/SQL FOR Loop PL/SQL for loop is used when when you want to execute a set of statements for a predetermined number…

PL/SQL Function The PL/SQL Function is very similar to PL/SQL Procedure. The main difference between procedure and a function is, a function…

PL/SQL GOTO Statement In PL/SQL, GOTO statement makes you able to get an unconditional jump from the GOTO to a specific executable…