O'Reilly logo

Concepts of Database Management System by Shefali Naik

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required