What are Oracle data types?

Character

• CHAR(size)
  
• NCHAR(size)
• VARCHAR2(size)
• NVARCHAR2(size)

Number

• NUMBER(precision=total number of digits, scale=number of digits after decimal point)

Long and raw

• LONG
• RAW(size)
• LONG RAW

Date and time

• DATE - year-month-day-hour-minute-second
  
• TIMESTAMP(fractional_seconds_precision) - year-month-day-hour-minute-second-fractional second
• TIMESTAMP WITH {LOCAL} TIME ZONE(fractional_seconds_precision)
• INTERVAL YEAR(year_precision) TO MONTH
• INTERVAL DAY(day_precision) TO SECOND(fractional_seconds_precision)

Larges

• CLOB - character large object
  
• NCLOB - national ...
  
• BLOB - binary large object
  
• BFILE - pointer of binary file on the disk

Row IDs

• ROWID - hexadecimal string representing address of the row
  
• UROWID - universal row id: hexadecimal string representing logical address of the row

XML

• XMLType

1
2