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 the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
