O'Reilly logo

Oracle PL/SQL Programming, 5th Edition by Bill Pribyl, Steven Feuerstein

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

Part III. PL/SQL Program Data

Just about every program you write will manipulate data—and much of that data is “local” to (i.e., defined in) your PL/SQL procedure or function. This part of the book concentrates on the various types of program data you can define in PL/SQL, such as numbers (including the datatypes introduced in Oracle Database 11g), strings, dates, timestamps, records, collections, XML datatypes, and user-defined datatypes. Chapters 7 through 13 also cover the various built-in functions provided by Oracle that allow you to manipulate and modify data.

Chapter 7, Working with Program Data
Chapter 8, Strings
Chapter 9, Numbers
Chapter 10, Dates and Timestamps
Chapter 11, Records
Chapter 12, Collections
Chapter 13, Miscellaneous Datatypes

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