CHAPTER 7

Introduction to PL/SQL

CHAPTER OBJECTIVES
  • Creating functions in Oracle.
  • Creating procedures in Oracle.
  • Applying validations and security through triggers in Oracle.
  • Overview of packages in Oracle.
7.1 INTRODUCTION

PL/SQL is an abbreviation of Procedural Language/Structured Query Language. We can create small programs using PL/SQL named and unnamed blocks.

By writing SQL update/select/insert/delete statement, we can apply same condition on set of records, but we cannot apply different conditions on different records depending upon the field values. It could be done by declaring cursor and accessing the cursor within the PL/SQL block.

We may also write stored procedure or function which could be called from remote computer. Using ...

Get Concepts of Database Management System now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.