Variables, Assignments, and Operators
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 ... |
Get Oracle Database 10g Express Edition PHP Web Programming now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
