Go Back   TechArena Community > Software > Software Development
Become a Member!
Forgot your username/password?
Register Tags Active Topics RSS Search Mark Forums Read

Sponsored Links



What are the the different Data Types available in Oracle?

Software Development


Reply
 
Thread Tools Search this Thread
  #1  
Old 09-01-2010
Member
 
Join Date: Dec 2009
Posts: 59
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.

Reply With Quote
  #2  
Old 09-01-2010
Member
 
Join Date: Apr 2008
Posts: 1,993
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
Reply With Quote
  #3  
Old 09-01-2010
Member
 
Join Date: May 2008
Posts: 2,283
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.
Reply With Quote
  #4  
Old 09-01-2010
Member
 
Join Date: Oct 2005
Posts: 2,385
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.
Reply With Quote
  #5  
Old 09-01-2010
Member
 
Join Date: May 2008
Posts: 2,373
Re: What are the the different Data Types available in Oracle?

Refer following given oracle datatypes with it's maximum range:
  1. NCHAR(bytes):32,767 bytes
  2. NVARCHAR2(bytes):32,767 bytes
  3. NCHAR VARYING(chars):32,767 bytes
  4. STRING(chars):32,767 bytes
  5. LONG:32,760 bytes
  6. CHAR VARYING(chars):32,767 bytes
Reply With Quote
  #6  
Old 09-01-2010
Member
 
Join Date: Feb 2008
Posts: 1,842
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)
Reply With Quote
Reply

  TechArena Community > Software > Software Development
Tags: , , , ,



Thread Tools Search this Thread
Search this Thread:

Advanced Search


Similar Threads for: "What are the the different Data Types available in Oracle?"
Thread Thread Starter Forum Replies Last Post
Different types of data transfers in usb Eru Hardware Peripherals 5 05-02-2010 10:22 AM
Different types of data bus in computer CAILYN Hardware Peripherals 5 29-01-2010 05:39 AM
Different types of data storage Aloke Hardware Peripherals 5 06-01-2010 01:10 AM
What are the types of DATA in a SQL Database Doroteo Software Development 3 06-11-2009 09:09 PM
Data Types in MySQL Jacek01 Software Development 2 10-02-2009 02:08 PM


All times are GMT +5.5. The time now is 07:57 AM.