August 2009
Intermediate to advanced
960 pages
21h 21m
English
This appendix lists Oracle’s most commonly used built-in data types. Note that some of the data types mentioned have additional data types to support specific national character sets, such as NCLOB or NVARCHAR2.
Oracle supports intermedia data types (images, audio, video), spacial (geographic) data, the ANY type where a data type is not known and can be dynamically configured, and the XML types. These data types can be used in conjunction with C/C++, Java, or PL/SQL.
Oracle’s PL/SQL language has some of the same data types as listed in Table I.1, but in some cases, PL/SQL places certain restrictions on manipulation and size. If you are working with data types within PL/SQL, refer to Oracle PL/SQL by Example, 4th ...
Read now
Unlock full access