October 2006
Intermediate to advanced
720 pages
17h 56m
English
Data types in PL/SQL include all SQL data types and subtypes described in Table H-2, plus you have five PL/SQL-specific data types covered in Table I-1. There are a number of implicit casting operations performed by Oracle, and they follow the common rule of programming: implicitly cast when there is no loss of precision. Likewise, there are a series of functions to let you explicitly cast when there is risk of losing run-time precision. You should choose carefully when you explicitly downcast variables.
| Data Type | Description |
|---|---|
| Associative Array PL/SQL Tables | The associative array type is a user-defined collection of scalar variables, user-defined PL/SQL record types, or user-defined ... |
Read now
Unlock full access