O'Reilly logo

Oracle® PL/SQL® Interactive Workbook, Second Edition by Elena Silvestrova, Benjamin Rosenzweig

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 2. PL/SQL Concepts

Chapter Objectives

In this Chapter, you will learn about:

PL/SQL in Client-Server Architecture

PL/SQL in SQL*Plus

In the previous chapter, you were introduced to some elements of computer programming languages. In this chapter, you will be introduced to the elements of a specific programming language, PL/SQL, and how it fits in the client-server architecture.

PL/SQL stands for “Procedural Language Extensions to SQL.” PL/SQL extends SQL by adding programming structures and subroutines available in any high-level language. In this chapter, you will see examples that will illustrate the syntax and the rules of the language.

PL/SQL is used for both server-side and client-side development. For example, database triggers ...

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