Author: Dev

An PL/SQL anonymous block consists of a sequence of instructions, the block will be executed only once. The PL/SQL anonymous block is not normally stored in the database for reuse later. Syntax DECLARE — Declarative part (optional) — Declarations of local types, variables, subprograms BEGIN — Executable part (required) — SQL statements — PL/SQL statements…(Continue Reading)

Oracle PL/SQL offers a variety of operators that can be used in various situations. These include: Arithmetic operators are used to perform mathematical operations such as addition (+), subtraction (-), multiplication (*), division (/), and modulus (MOD). Logical operators are used to evaluate Boolean expressions and return either TRUE or FALSE. The logical operators in…(Continue Reading)

Oracle PL/SQL provides a mechanism for deleting data from database tables. The DELETE statement is used to delete one or more rows from a table. The DELETE statement is part of Data Manipulation Language and allows the user to delete a single record or multiple records in a table. The syntax of the DELETE statement…(Continue Reading)

The Update statement is part of Data Manipulation Language and allows the user to update a single record or multiple records in a table. PL/SQL update statements can be used to update data in a database table. You can update a single row, multiple columns, or all rows in a table. You can also use…(Continue Reading)

INSERT statement in PL/SQL is used to insert new rows in a table. The INSERT statement is part of Data Manipulation Language and  allows the user to insert a single record or multiple records into a table. The syntax for insert statement is as follows: Syntax: INSERT INTO table VALUES (value1, value2, value3, …); INSERT INTO…(Continue Reading)