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|