Google Search

Wednesday, October 12, 2011

Conditional Statements in PL/SQL DBMS LAB MANUAL FOR M.E STUDENTS


Conditional Statements in PL/SQL
As the name implies, PL/SQL supports programming language features like conditional statements, iterative statements.
The programming constructs are similar to how you use in programming languages like Java and C++. In this section I will provide you syntax of how to use conditional statements in PL/SQL programming.

IF THEN ELSE STATEMENT:

1)                     IF condition THEN
            statement 1;
ELSE
            statement 2;
END IF;


2)                     IF condition 1 THEN
            statement 1;
            statement 2;
ELSIF condtion2 THEN
            statement 3;
        ELSE
            statement 4;
END IF

0 comments:

Post a Comment