Answers

Question and Answer:

  Home  Oracle Database Developer

⟩ Explain Oracle Built-in Data Types?

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

 146 views

More Questions for you: