29. PL/SQL INTRODUCTION

Introduction:

·         This is a procedural language or programming language

·         It consist of unit blocks

·         Makes the application design easy

·         Provides security and is portable

·         It is used to handle multiple statements

·         To define our own logics we use Pl/sql

·         It supports control statements like IF conditions, Loops, go to.. etc.

·         By using pl/sql we can handle runtime errors

·         Explicitly we can define our own cursors in pl/sql. It allows Boolean data types

·         PL/SQL has tight integration with oracle data types.