AppendixOracle Data Types

This appendix contains two tables that document the data types available in Oracle SQL and may be used to define columns in a table, along with the additional types supported by Oracle PL/SQL.

Oracle SQL Types

Table A-1 shows the Oracle SQL types.

Image

Image

Image

Image

TABLE A-1. Oracle SQL Types

Oracle PL/SQL Types

Oracle PL/SQL supports ...

Get Oracle Database 10g SQL 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.