In this chapter, we will discuss Object-Oriented PL/SQL. PL/SQL allows defining an object type, which helps in designing object-oriented database…
Read More
PL/SQL – DBMS Output
In this chapter, we will discuss the DBMS Output in PL/SQL. The DBMS_OUTPUT is a built-in package that enables you…
Read MorePL/SQL – Date & Time
In this chapter, we will discuss the Date and Time in PL/SQL. There are two classes of date and time…
Read MorePL/SQL – Transactions
In this chapter, we will discuss the transactions in PL/SQL. A database transaction is an atomic unit of work that…
Read MorePL/SQL – Collections
In this chapter, we will discuss the Collections in PL/SQL. A collection is an ordered group of elements having the…
Read MorePL/SQL – Packages
In this chapter, we will discuss the Packages in PL/SQL. Packages are schema objects that groups logically related PL/SQL types,…
Read MorePL/SQL – Triggers
In this chapter, we will discuss Triggers in PL/SQL. Triggers are stored programs, which are automatically executed or fired when…
Read MorePL/SQL – Exceptions
In this chapter, we will discuss Exceptions in PL/SQL. An exception is an error condition during a program execution. PL/SQL…
Read MorePL/SQL – Records
In this chapter, we will discuss Records in PL/SQL. A record is a data structure that can hold data items…
Read MorePL/SQL – Cursors
In this chapter, we will discuss the cursors in PL/SQL. Oracle creates a memory area, known as the context area,…
Read MorePL/SQL – Functions
In this chapter, we will discuss the functions in PL/SQL. A function is same as a procedure except that it…
Read MorePL/SQL – Procedures
In this chapter, we will discuss Procedures in PL/SQL. A subprogram is a program unit/module that performs a particular task.…
Read MorePL/SQL – Arrays
In this chapter, we will discuss arrays in PL/SQL. The PL/SQL programming language provides a data structure called the VARRAY,…
Read MorePL/SQL – Strings
The string in PL/SQL is actually a sequence of characters with an optional size specification. The characters could be numeric,…
Read MorePL/SQL – Loops
In this chapter, we will discuss Loops in PL/SQL. There may be a situation when you need to execute a…
Read MorePL/SQL – Conditions
In this chapter, we will discuss conditions in PL/SQL. Decision-making structures require that the programmer specify one or more conditions…
Read MorePL/SQL – Operators
In this chapter, we will discuss operators in PL/SQL. An operator is a symbol that tells the compiler to perform…
Read MorePL/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…
Read MorePL/SQL – Variables
In this chapter, we will discuss Variables in Pl/SQL. A variable is nothing but a name given to a storage…
Read MorePL/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…
Read MorePL/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…
Read More
