Resources‎ > ‎SQL‎ > ‎

Data Types

This page will show the different data types that exist in the databases such as Oracle, SQL Server.....

Database
Data Types
Oracle

Character

Data Type
Description
VARCHAR2(Size)Variable-length character data (The maximum size must be specified: minimum size is 1; maximum size is 4000)
CHAR(size)
Fixed-length character data of length size in bytes (Default and minimum size is 1; maximum size is 2000)
NUMBER(p, s)
Number having precision p and scale s (Precision is the total number of decimal digits and scale in the number of digits to the right of the decimal point; precision can range from 1 to 38, and scale can range from -84 to 127.)
LONG
Variable-length character data (up to 2GB)
CLOB
Character data (up to 4GB)
RAW (Size)
Raw binary data of length size (A maximum size must be specified: maximum size is 2,000)
LONG RAW
Raw binary data of variable length (up to 2GB)
BLOG
Binary data (up to 4GB)
BFILE
Binary data stored in an external file (up to 4 GB)
ROWID
A base-64 number system representing the unique address of a row in its table.

  • Char -
  • NChar
  • NVarchar2
  • Varchar2
  • Long
  • Raw
  • LongRaw
Numeric
  • Number(p,s)
  • Numeric(p,s)
  • Float
  • Dec(p,s)
  • Decimal(p,s)
  • Integer
  • Int
  • Smallint
  • Real
  • Double Percision
Date/Time

 Data Type
Description
DATE
Date and Time values to the nearest second between January 1, 4712 BC and December 31, 9999 AD
TIMESTAMP
Enables storage of time as a date with fractional seconds.  It stores the year, month, day, hour, minute and the second value of the DATE data type as well as the fractional seconds value.  There are several variations of this data type as WITH TIMEZONE, WITH LOCALTIMEZONE.
INTERVAL YEAR TO MONTH
Enables storage of time as an interval of years and months. Used to represent the differences between two datetime values in which the only significant portions are the year and month.
INTERVAL DAY TO SECOND
Enables storage of time as an interval of days, hours, minutes, and seconds.  Used to represent the precise difference between two datetime values.

Large Object (LOB)
  • Bfile
  • Blob
  • Clob
  • NClob


RowID
  • RowID
  • URowID

SQL Server
Exact Numeric
Approximate Numerics
  • Float
  • Real
Character Strings
  • Char
  • Text
  • Varchar
Unicode Character Strings
  • NChar
  • NText
  • NVarchar
Binary Strings
  • Binary
  • Image
  • Varbinary
Other Data Types
  • Cursor
  • Hierarchyid
  • SQL_Variant
  • Table
  • Timestamp
  • UniqueIdentifier
  • XML