Oracle8i JDBC Developer's Guide and Reference Release 3 (8.1.7) Part Number A83724-01 |
Library | Service | Contents | Index

## Supported SQL and PL/SQL Datatypes

The tables in this section list SQL and PL/SQL datatypes, and whether the Oracle JDBC drivers and SQLJ support them. Table 21-2 describes Oracle JDBC driver and SQLJ support for SQL datatypes.

##### Table 21-2 Support for SQL Datatypes

SQL Datatype | Supported by JDBC Drivers? | Supported by SQLJ?
--- | --- | ---
BFILE | yes | yes
BLOB | yes | yes
CHAR | yes | yes
CLOB | yes | yes
DATE | yes | yes
NCHAR | no | no
NCHAR VARYING | no | no
NUMBER | yes | yes
NVARCHAR2 | no | no
RAW | yes | yes
REF | yes | yes
ROWID | yes | yes
UROWID | no | no
VARCHAR2 | yes | yes

Table 21-3 describes Oracle JDBC driver and SQLJ support for the ANSI-supported SQL datatypes.

##### Table 21-3 Support for ANSI-Supported SQL Datatypes

ANSI-Supported SQL Datatype | Supported by JDBC Drivers? | Supported by SQLJ?
--- | --- | ---
CHARACTER | yes | yes
DEC | yes | yes
DECIMAL | yes | yes
DOUBLE PRECISION | yes | yes
FLOAT | yes | yes
INT | yes | yes
INTEGER | yes | yes
NATIONAL CHARACTER | no | no
NATIONAL CHARACTER VARYING | no | no
NATIONAL CHAR | no | no
NATIONAL CHAR VARYING | no | no
NCHAR | no | no
NCHAR VARYING | no | no
NUMERIC | yes | yes
REAL | yes | yes
SMALLINT | yes | yes
VARCHAR | yes | yes

Table 21-4 describes Oracle JDBC driver and SQLJ support for PL/SQL datatypes. Note that PL/SQL datatypes include these categories:

- scalar types

- scalar character types (includes boolean and date datatypes)

- composite types

- reference types

- LOB types

  ##### Table 21-4 Support for PL/SQL Datatypes

  PL/SQL Datatype | Supported by JDBC Drivers? | Supported by SQLJ?
  --- | --- | ---
  Scalar Types: |  |
  binary integer | yes | yes
  dec | yes | yes
  decimal | yes | yes
  double precision | yes | yes
  float | yes | yes
  int | yes | yes
  integer | yes | yes
  natural | yes | yes
  naturaln | no | no
  number | yes | yes
  numeric | yes | yes
  pls_integer | yes | yes
  positive | yes | yes
  positiven | no | no
  real | yes | yes
  signtype | yes | yes
  smallint | yes | yes
  Scalar Character Types: |  |
  char | yes | yes
  character | yes | yes
  long | yes | yes
  long raw | yes | yes
  nchar | no | no
  nvarchar2 | no | no
  raw | yes | yes
  rowid | yes | yes
  string | yes | yes
  urowid | no | no
  varchar | yes | yes
  varchar2 | yes | yes
  boolean | yes | yes
  date | yes | yes
  Composite Types: |  |
  record | no | no
  table | partially | no
  varray | yes | yes
  Reference Types: |  |
  REF CURSOR types | yes | yes
  object REF types | yes | yes
  LOB Types: |  |
  BFILE | yes | yes
  BLOB | yes | yes
  CLOB | yes | yes
  NCLOB | no | no

  Notes: The types `NATURAL`, `NATURAL` `n`, `POSITIVE`, `POSITIVE` `n`, and `SIGNTYPE` are subtypes of `BINARY INTEGER`. The types `DEC`, `DECIMAL`, `DOUBLE PRECISION`, `FLOAT`, `INT`, `INTEGER`, `NUMERIC`, `REAL`, and `SMALLINT` are subtypes of `NUMBER`.

| Copyright © 1996-2000, Oracle Corporation. All Rights Reserved. |
Library | Service | Contents | Index