«
»

Oracle : Built-in Data Types

Share
The built-in data types is twenty types but these divide in to six group in oracle :
  1. Character Datatypes           : CHAR, NCHAR, NVARCHAR2, VARCHAR2
  2. Number Datatypes               : NUMBER, BINARY_FLOAT, BINARY_DOUBLE
  3. Datetime Datatypes             : DATE, TIMESTAMP, INTERVAL YEAR TO MONTH, INTERVAL DAY TO SECOND
  4. Row ID Datatypes                 : ROWID, UROWID
  5. Long and Row Datatypes   : LONG, LONG RAW, RAW
  6. Large Object Datatypes      : BLOB, CLOB, NCLOB, BFILE
Share

Comments

comments

Tags: , , , , , , ,

This entry was posted on Monday, January 14th, 2013 at 12:01 am and is filed under Oracle. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.

Leave a Reply