Get Started

SQL COMMANDS

CONSTRAINTS

NOT NULL

SQL FUNCTIONS

STRING FUNCTION

NUMERIC FUNCTION

PL/SQL

ADVANTAGES OF PL/SQL

DATATYPES AND DECLARATION

VARIABLES AND CONSTANTS

CONTROL STATEMENTS

ITERAIVE CONTROL

CONDITIONAL CONTROL

ERROR HANDLING

OVERVIEW OF ERROR HANDLING

EXCEPTION TYPES

DATATYPES AND DECLARATION

SUBPROGRAMS

INTRODUCTION

DATABASE TRIGGERS

ERROR WITH TRIGGERS

CONTROL STATEMENTS

INTRODUCTION:

We can change the logical flow of statements within the pl/sql block with a number of control structures

Control structures can be:
*conditional control
*iterative Control
*sequential control