Database

Database

Oracle PL/SQL Case Statement

Oracle PL/SQL provides case statement control which is used in decision making. It has similarities with the IF statement control of PL/SQL. In case statement there is a selector,

Read
Database

Oracle PL/SQL Conditions

Controlling the flow of execution is common in programming. It is very much needed to direct the flow of program based on some conditions. This can be done in any programming language by IF statements.

Read
Database

Oracle PL/SQL Blocks

PL/SQL is a block structured language. Everything written in PL/SQL are divided in logical blocks. Each blocks has three parts declaration sections, executable sections and exception handling sections.

Read