APPENDIXOracle Data Types

This appendix contains two tables documenting the data types that are available in Oracle SQL and that 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

Table A-1 Oracle SQL Types

Oracle PL/SQL Types

Oracle PL/SQL supports all the types previously shown in Table A-1, plus the following additional Oracle PL/SQL specific types shown in Table A-2.

TABLE A-2 Oracle PL/SQL Types

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

Start your free trial