Results 1 to 6 of 6

Thread: What are the the different Data Types available in Oracle?

  1. #1
    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.

  2. #2
    Join Date
    Apr 2008
    Posts
    2,010

    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

  3. #3
    Join Date
    May 2008
    Posts
    2,302

    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.

  4. #4
    Join Date
    Oct 2005
    Posts
    2,394

    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.

  5. #5
    Join Date
    May 2008
    Posts
    2,393

    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

  6. #6
    Join Date
    Feb 2008
    Posts
    1,856

    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)

Similar Threads

  1. Different types of data transfers in usb
    By Eru in forum Hardware Peripherals
    Replies: 5
    Last Post: 05-02-2010, 10:22 AM
  2. Different types of data bus in computer
    By CAILYN in forum Hardware Peripherals
    Replies: 5
    Last Post: 29-01-2010, 05:39 AM
  3. Different types of data storage
    By Aloke in forum Hardware Peripherals
    Replies: 5
    Last Post: 06-01-2010, 01:10 AM
  4. What are the types of DATA in a SQL Database
    By Doroteo in forum Software Development
    Replies: 3
    Last Post: 06-11-2009, 09:09 PM
  5. Data Types in MySQL
    By Jacek01 in forum Software Development
    Replies: 2
    Last Post: 10-02-2009, 02:08 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •