Oracle Built-in Data Types in Oracle

Q

What Are the Oracle Built-in Data Types in Oracle?

✍: FYIcenter.com

A

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

 

Understanding SQL Language Basics for Oracle

⇒⇒Oracle Database Tutorials

2016-10-17, 160👍, 0💬