Scribd
Upload
4 views4 pages

Oracle

The document provides a comparison of data types between Oracle and PostgreSQL, listing equivalent types for various Oracle data types. It includes mappings for types such as BLOB, CLOB, NUMBER, and TIMESTAMP, among others. Additionally, it highlights the flexibility of PostgreSQL in accommodating different Oracle types with multiple possible mappings.

Uploaded by

mugilan044
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
4 views4 pages

Oracle

The document provides a comparison of data types between Oracle and PostgreSQL, listing equivalent types for various Oracle data types. It includes mappings for types such as BLOB, CLOB, NUMBER, and TIMESTAMP, among others. Additionally, it highlights the flexibility of PostgreSQL in accommodating different Oracle types with multiple possible mappings.

Uploaded by

mugilan044
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
You are on page 1/ 4

Oracle PostgreSQL

BFILE VARCHAR(255)
BINARY_FLOAT REAL
BINARY_DOUBLE DOUBLE PRECISION
BLOB BYTEA
CHAR(n),
CHAR(n), CHARACTER(n)
CHARACTER(n)
CLOB TEXT
DATE TIMESTAMP
DECIMAL(p,s), DEC(p,s) DECIMAL(p,s), DEC(p,s)
DOUBLE PRECISION DOUBLE PRECISION
FLOAT(p) DOUBLE PRECISION
INT, INTEGER INT, INTEGER
LONG TEXT
LONG RAW BYTEA
NCHAR(n) CHAR(n)
NCHAR VARYING(n) VARCHAR(n)
NCLOB TEXT
NUMBER(p,0), NUMBER(p), 1 <= p
SMALLINT
<5
NUMBER(p,0), NUMBER(p), 5 <= p
INT
<9
NUMBER(p,0), NUMBER(p), 9 <= p
BIGINT
< 19
NUMBER(p,0), NUMBER(p), p >= 19 DECIMAL(p)
NUMBER(p,s) DECIMAL(p,s)
NUMBER, NUMBER(*) DOUBLE PRECISION
NUMERIC(p,s) NUMERIC(p,s)
NVARCHAR2(n) VARCHAR(n)
RAW(n) BYTEA
REAL DOUBLE PRECISION
ROWID CHAR(10)
SMALLINT SMALLINT
TIMESTAMP(p) TIMESTAMP(p)
TIMESTAMP(p) WITH
TIMESTAMP(p) WITH TIME ZONE
TIME ZONE
VARCHAR(n) VARCHAR(n)
VARCHAR2(n) VARCHAR(n)
XMLTYPE XML

Oracle type Possible PostgreSQL types

CHAR char, varchar, text

NCHAR char, varchar, text

VARCHAR char, varchar, text

VARCHAR2 char, varchar, text, json

NVARCHAR2 char, varchar, text

CLOB char, varchar, text, json

LONG char, varchar, text

RAW uuid, bytea


Oracle type Possible PostgreSQL types

BLOB bytea

BFILE bytea (read-only)

LONG RAW bytea

NUMBER numeric, float4, float8, char, varchar, text

numeric, float4, float8, int2, int4, int8, boolean, char, v


NUMBER(n,m) with m<=0 text

FLOAT numeric, float4, float8, char, varchar, text

BINARY_FLOAT numeric, float4, float8, char, varchar, text

BINARY_DOUBLE numeric, float4, float8, char, varchar, text

DATE date, timestamp, timestamptz, char, varchar, text

TIMESTAMP date, timestamp, timestamptz, char, varchar, text

TIMESTAMP WITH TIME ZONE date, timestamp, timestamptz, char, varchar, text

TIMESTAMP WITH LOCAL TIME


ZONE date, timestamp, timestamptz, char, varchar, text

INTERVAL YEAR TO MONTH interval, char, varchar, text

INTERVAL DAY TO SECOND interval, char, varchar, text

XMLTYPE xml

MDSYS.SDO_GEOMETRY geometry

You might also like