Variables, Assignments, and Operators

Data types in PL/SQL include all SQL data types and subtypes qualified in Table D-1, plus there are five PL/SQL specific data types covered in Table E-1. There are a number of implicit casting operations performed by Oracle, and they generally follow the common rule of programming: cast implicitly when there is no loss of precision. A loss of precision does occur when Oracle casts real numbers to integers, where it truncates the decimal portion of the number. Likewise, there are a series of functions to let you cast explicitly when there is risk of losing runtime precision. You should choose carefully when you explicitly downcast variables.

There are several other product-specific types created to support ...

Get Oracle Database Ajax & PHP Web Application Development 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.