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.
|Data Type||Raw Code||Description|
|CHAR||96||The CHAR data type stores fixed-length character data in bytes or characters. You can override the default by providing a formal ...|