Author: B D

Relational operators compare two expressions or values and return a Boolean result. The following table shows all the relational operators supported by PL/SQL. Let us assume variable A holds 10 and variable B holds…

The following table shows all the arithmetic operators supported by PL/SQL. Let us assume variable A holds 10 and variable B holds 5, then − OperatorDescriptionExample+Adds two operandsA + B will give 15-Subtracts second…

In this chapter, we will discuss operators in PL/SQL. An operator is a symbol that tells the compiler to perform specific mathematical or logical manipulation. PL/SQL language is rich in…

In this chapter, we will discuss constants and literals in PL/SQL. A constant holds a value that once declared, does not change in the program. A constant declaration specifies its name, data type, and…

In this chapter, we will discuss Variables in Pl/SQL. A variable is nothing but a name given to a storage area that our programs can manipulate. Each variable in PL/SQL…

In this chapter, we will discuss the Data Types in PL/SQL. The PL/SQL variables, constants, and parameters must have a valid data type, which specifies a storage format, constraints, and…

In this chapter, we will discuss the Basic Syntax of PL/SQL which is a block-structured language; this means that the PL/SQL programs are divided and written in logical blocks of code. Each…

In this chapter, we will discuss the Environment Setup of PL/SQL. PL/SQL is not a standalone programming language; it is a tool within the Oracle programming environment. SQL* Plus is an interactive…

The PL/SQL programming language was developed by Oracle Corporation in the late 1980s as a procedural extension language for SQL and the Oracle relational database. Following are certain notable facts…

PL/SQL is a combination of SQL along with the procedural features of programming languages. It was developed by Oracle Corporation in the early '90s to enhance the capabilities of SQL.…