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, NATURALn, POSITIVE, POSITIVEn, and SIGNTYPE are subtypes of BINARY INTEGER. The types DEC, DECIMAL, DOUBLE PRECISION, FLOAT, INT, INTEGER, NUMERIC, REAL, and SMALLINT are subtypes of NUMBER.

---