Oracle SQL Data Types

Oracle Database 10g Express Edition supports character, numeric, timestamp, binary, and row address data types. These are also known as SQL data types or built-in types because they can be used to define columns in tables and parameter data types in PL/SQL. Table H-2 summarizes these SQL data types and qualifies two widely used data subtypes by groups. While the list is not comprehensive of all subtypes, which can be found in the Oracle Database SQL Reference 10g Release 2 manual, it should cover the most frequently used data subtypes.

Table H-2. SQL Data Types
Data TypeRaw CodeDescription
CHAR96The CHAR data type stores fixed-length character data in bytes or characters. You can override the default by providing a formal ...

Get Oracle Database 10g Express Edition PHP Web Programming now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.