PL/SQL – Operators
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…
PL/SQL – Constants and Literals
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…
PL/SQL – Variables
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…
PL/SQL – Data Types
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…
PL/SQL – Basic Syntax
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…
PL/SQL – Environment Setup
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…
PL/SQL – Overview
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
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.…