PL SQL

Hi Everyone, Today's topic is Iterative Processing with(LOOP,WHILE LOOP,CONTINUE).

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.

Types of Loop in PL/SQL:

1. Basic Loop

2. While Loop

Hi Everyone, Today's topic is conditional control(if,ifelse,case,goto,null).

PL/SQL supports the programming language features like conditional statements and iterative statements.

Its programming constructs are similar to how you use in programming languages like Java and C++.

Conditional Statements are basically used when condition occurs and we choose one statements.

IF

It allows you to either execute or skip a sequence of statements, depending on a condition.

Hi Everyone, Today's topic is datatypes used in PL/SQL.

Each value in PL/SQL such as a constant, variable and parameter has a data type that determines the storage format, valid values, and allowed operations.

Types of Datatypes in PL/SQL:

1. Scaler : store single values such as

a. Number

b. Boolean

Hi Everyone, Today's topic is PL/SQL block.

PL/SQL is a block-structured language whose code is organized into blocks.

A PL/SQL block consists of three sections:

Declaration,

Executable,

and Exception-handling sections.

Hi Everyone, Today's topic is PL/SQL introduction.

PL/SQL stands for “Procedural Language extensions to the Structured Query Language”.

SQL is a popular language for both querying and updating data in the relational database management systems (RDBMS).

PL/SQL adds many procedural constructs to SQL language to overcome some limitations of SQL. Besides, PL/SQL provides a more comprehensive programming language solution for building mission-critical applications on Oracle Databases.

PL/SQL = PL(procedure Language(Programming language)) + SQL(structured Query Language)

Features of PL/SQL: