What Are the Oracle Built-in Data Types?
Page 1 of 1
What Are the Oracle Built-in Data Types?
There are 20 Oracle built-in data types, divided into 6 groups:
Character Datatypes - CHAR, NCHAR, NVARCHAR2, VARCHAR2
Number Datatypes - NUMBER, BINARY_FLOAT, BINARY_DOUBLE
Long and Row Datatypes - LONG, LONG RAW, RAW
Datetime Datatypes - DATE, TIMESTAMP, INTERVAL YEAR TO MONTH, INTERVAL DAY TO
SECOND
Large Object Datatypes - BLOB, CLOB, NCLOB, BFILE
Row ID Datatypes - ROWID, UROWID
What Are the Differences between CHAR and NCHAR?
Both CHAR and NCHAR are fixed length character data types. But they have the following
differences:
CHAR's size is specified in bytes by default.
NCHAR's size is specified in characters by default. A character could be 1 byte to 4 bytes long
depending on the character set used.
NCHAR stores characters in Unicode.
What Are the Differences between CHAR and VARCHAR2?
The main differences between CHAR and VARCHAR2 are:
CHAR stores values in fixed lengths. Values are padded with space characters to match the
specified length.
VARCHAR2 stores values in variable lengths. Values are not padded with any characters.
Character Datatypes - CHAR, NCHAR, NVARCHAR2, VARCHAR2
Number Datatypes - NUMBER, BINARY_FLOAT, BINARY_DOUBLE
Long and Row Datatypes - LONG, LONG RAW, RAW
Datetime Datatypes - DATE, TIMESTAMP, INTERVAL YEAR TO MONTH, INTERVAL DAY TO
SECOND
Large Object Datatypes - BLOB, CLOB, NCLOB, BFILE
Row ID Datatypes - ROWID, UROWID
What Are the Differences between CHAR and NCHAR?
Both CHAR and NCHAR are fixed length character data types. But they have the following
differences:
CHAR's size is specified in bytes by default.
NCHAR's size is specified in characters by default. A character could be 1 byte to 4 bytes long
depending on the character set used.
NCHAR stores characters in Unicode.
What Are the Differences between CHAR and VARCHAR2?
The main differences between CHAR and VARCHAR2 are:
CHAR stores values in fixed lengths. Values are padded with space characters to match the
specified length.
VARCHAR2 stores values in variable lengths. Values are not padded with any characters.
Similar topics
» SQL Oracle data types
» What Are the ANSI Data Types Supported in Oracle?
» How Many Data Types Are Supported?
» How Many Categories of Data Types?
» How Many Types of Tables Supported by Oracle?
» What Are the ANSI Data Types Supported in Oracle?
» How Many Data Types Are Supported?
» How Many Categories of Data Types?
» How Many Types of Tables Supported by Oracle?
Page 1 of 1
Permissions in this forum:
You cannot reply to topics in this forum
Sun Jan 31, 2010 12:35 am by Micheal
» Accessing tables of other users in SQL
Sun Jan 31, 2010 12:34 am by Micheal
» Grouping commands in SQL
Sun Jan 31, 2010 12:32 am by Micheal
» Operations on Result Sets in SQL
Sun Jan 31, 2010 12:31 am by Micheal
» Subqueries in SQL
Sun Jan 31, 2010 12:30 am by Micheal
» Joining Relations in SQL
Sun Jan 31, 2010 12:28 am by Micheal
» Delete comand in SQL
Sun Jan 31, 2010 12:27 am by Micheal
» Update command in SQL
Sun Jan 31, 2010 12:26 am by Micheal
» Insert command in SQL
Sun Jan 31, 2010 12:23 am by Micheal