Search results
Learn PL/SQL tutorial for beginners and professionals with examples on cursors, triggers, functions, procedures, strings, exceptions, arrays, collections, packages, transactions etc.
PL/SQL procedure example for beginners and professionals with examples on cursors, triggers, functions, procedures, strings, exceptions, arrays, collections, packages, transactions etc.
PL/SQL Loop. The PL/SQL loops are used to repeat the execution of one or more statements for specified number of times. These are also known as iterative control statements. Syntax for a basic loop: LOOP. Sequence of statements;
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 must always return a value, and on the other hand a procedure may or may not return a value.
PL/SQL is one of three key programming languages embedded in the Oracle Database, along with SQL itself and Java. In this tutorial, we'll give you a great understanding of PL/SQL to proceed with the Oracle database and other advanced RDBMS concepts.
PL/SQL Variables. A variable is a meaningful name which facilitates a programmer to store data temporarily during the execution of code. It helps you to manipulate data in PL/SQL programs. It is nothing except a name given to a storage area. Each variable in the PL/SQL has a specific data type which defines the size and layout of the variable's ...
PL/SQL Cursor. When an SQL statement is processed, Oracle creates a memory area known as context area. A cursor is a pointer to this context area. It contains all information needed for processing the statement. In PL/SQL, the context area is controlled by Cursor.
