Oracle 11.1 vs. SQL Server 2008 – PSOUG.org

Oracle 11.1 vs. SQL Server 2008 – PSOUG.org 

Data Types

SQL SERVER 2008 Oracle 11
String (Character) Types
Fixed length string CHAR   (8K) CHAR   (2K)
Fixed length string NCHAR   (8K) NCHAR   (2K)
Variable length string CHAR   (8K) CHARACTER   (2K)
Variable length string VARCHAR   (8K) VARCHAR2   (32K)
Variable length string NVARCHAR   (8K) NVARCHAR2   (32K)
Variable length string VARCHAR   (8K) STRING   (32K)
Variable length string LONG   (2GB)
Variable length string CLOB   (128 TB)
Variable length string TEXT   (deprecated) CLOB
Variable length string NTEXT   (deprecated) CLOB
Numeric Data Types
Integer BIT NUMBER(1,0)
Integer TINYINT   (1 byte) SMALLINT,   INT, INTEGER, BINARY INTEGER, and PLS_INTEGER
Integer SMALLINT   (2 bytes) (all up to 38   digits)
Integer INT   (4 bytes)
Integer BIGINT   (8 bytes)
Number DECIMAL (1 byte) DEC,   DECIMAL,
NUMERIC, NUMBER
Number NUMERIC   (2 bytes) (up to 38   digits)
Floating point numbers FLOAT FLOAT
Floating point numbers REAL REAL
(63 binary digits)
Floating point numbers DOUBLE_PRECISION
(126 binary digits)
Floating point numbers FLOAT
(126 binary digits)
Floating point numbers using native machine arithmetic BINARY_FLOAT   (32 bit)
Floating point numbers using native machine arithmetic BINARY_DOUBLE   (64 bit)
Non-negative integers NATURAL
Not nullable non-negative integers NATURALN
Only positive integers POSITIVE
Not nullable non-negative integers POSITIVEN
-1, 0 or +1 only SIGNTYPE
Monetary Data Types
SMALLMONEY (user   definable)
MONEY (user   definable)
Date, Interval, Time, and Timezone Data Types
Date-Time (low precision) SMALLDATETIME   & DATE DATE   (to 1 sec)
Date-Time (high precision) DATETIME   & DATETIME2 TIMESTAMP   (to 1 nanosecond)
DATETIMEOFFSET TIMESTAMP   WITH TIMEZONE
TIMESTAMP   WITH LOCAL TIMEZONE
INTERVAL   YEAR TO MONTH
INTERVAL   DAY TO SECOND
hh:mm:ss.nnnnnnn TIME EXTRACT(TIMESTAMP)
Boolean
Boolean TRUE / FALSE BOOLEAN
Binary Data Types
Fixed length binary BINARY RAW   or LONG RAW
Variable length binary VARBINARY RAW   OR LONG RAW
LONG   RAW
(not   relevant) MLSLABEL
IMAGE BLOB
Row Identifiers
UNIQUEIDENTIFIER
(not   relevant) ROWID
(not   relevant) UROWID

http://psoug.org/reference/sqlserver.html

SQL Server 2008 for Oracle DBA

Simple Talk – A technical journal and community hub from Red Gate

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s