Oracle Data types

type
char (length)
varchar2 (length)
number (p,s)
date
timestamp
clob
blob

Example of a number type:

Format	The number entered	The actual storage
Number	1234.567	1234.567
Number (6,2)	123.4567	123.46
Number (4,2)	12345.67	The number entered exceeds the specified precision and the database cannot be stored

For date types, you can use the sysdate built-in function to get the current system date and time, return a date type, and use the Systimestamp function to return the current date, time, and time zone.

Oracle Data types