Books for you

User-defined data
Oracle8 and later versions allow users to define their own complex datatypes,
which are created as combinations of the basic Oracle datatypes previously discussed.
These versions of Oracle also allow users to create objects composed of
both basic datatypes and user-defined datatypes. For more information about
objects within Oracle, see Chapter 14.
88 | Chapter 4: Oracle Data Structures
AnyType, AnyData, AnyDataSet
Oracle9i and newer releases include three datatypes that can be used to explicitly
define data structures that exist outside the realm of existing datatypes. Each
of these datatypes must be defined with program units that let Oracle know how
to process any specific implementation of these types.
Type Conversion
Oracle automatically converts some datatypes to other datatypes, depending on the
SQL syntax in which the value occurs.
When you assign a character value to a numeric datatype, Oracle performs an
implicit conversion of the ASCII value represented by the character string into a
number.


Pages:
185 186 187 188 189 190 191 192 193 194 195 196 197 198 199 200 201 202 203 204 205 206 207 208 209