Skip to Main Content
Beginning Oracle PL/SQL, Second Edition
book

Beginning Oracle PL/SQL, Second Edition

by Donald J. Bales
May 2015
Beginner content levelBeginner
492 pages
11h 48m
English
Apress
Content preview from Beginning Oracle PL/SQL, Second Edition

CHAPTER 3

image

Types, Variables, and Scope

This chapter is all about how to keep track of variables in a PL/SQL program. Before this chapter ends, you’ll learn about PL/SQL data types, variables, scope, types, and parameters. Let’s get started.

PL/SQL Data Types

Given that PL/SQL is the Procedural Language extension for SQL, you would think that it supports and uses the same data types as SQL does for the database, right? Right! It turns out that is almost the case, but not quite. PL/SQL can handle any database data type and also some data types of its own.

Do you remember the “Data Definition Language (DDL)” section in Chapter 1? In it, I talked about ...

Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Start your free trial

You might also like

Oracle PL/SQL Language Pocket Reference, 5th Edition

Oracle PL/SQL Language Pocket Reference, 5th Edition

Steven Feuerstein, Bill Pribyl, Chip Dawes
Oracle PL/SQL Programming: A Developer's Workbook

Oracle PL/SQL Programming: A Developer's Workbook

Steven Feuerstein, Andrew Odewahn

Publisher Resources

ISBN: 9781484207376Purchase book