What are the the different Data Types available in Oracle?
Hello Guys,
I am going to start the study of Oracle. So before that I want to be aware about the different data types which are available in the Oracle. To define the any variable you should know the it's data type.
If you have sound knowledge about the data types of Oracle then let me share with me. I would greatly appreciate your help.
Re: What are the the different Data Types available in Oracle?
Hi friend, I am aware about the following data type of Oracle:
- NCHAR
- NVARCHAR2
- LOB Character
- VARCHAR2
- VARCHAR
- LONG
Re: What are the the different Data Types available in Oracle?
CHAR(Size):
This data type is used to define character data Fixed length. It's maximum size is 2000 bytes.
NCHAR(size):
This data type is used to define national character set data. It's maximum size is 2000 bytes.
BINARY_INTEGER:
It is used to define signed integers. It is the older older version of PLS_INTEGER.
DATE:
It is used to define data of date format.
Re: What are the the different Data Types available in Oracle?
Hello friend,
The basic Datatypes of oracle is comprises Numeric, DATE, Character, LOB Datatype. There are number of sub-datatypes are available for these datatypes. The Numeric datatypes divided into NUMBER, BINARY_FLOAT, BINARY_DOUBLE, FLOAT. The Character datatypes divided into VARCHAR2, VARCHAR, NLS_LENGTH_SEMANTICS, SUBSTR, NLS_LENGTH_SEMANTICS, NCHAR, NVARCHAR2. I hope it will depict the basic dataypes available in Oracle.
Re: What are the the different Data Types available in Oracle?
Refer following given oracle datatypes with it's maximum range:- NCHAR(bytes):32,767 bytes
- NVARCHAR2(bytes):32,767 bytes
- NCHAR VARYING(chars):32,767 bytes
- STRING(chars):32,767 bytes
- LONG:32,760 bytes
- CHAR VARYING(chars):32,767 bytes
Re: What are the the different Data Types available in Oracle?
Hi friends, Following are the number of Oracle data types:
- BLOB, CLOB, NCLOB, BFILE
- LONG
- VARCHAR2
- Date (Month, Hour, Minute, Year)
- FLOAT(p)
- NUMBER (p)
- NUMBER(p,s)
- ROWID
- UROWID(n)