sql data types in dbms code example
Example 1: sql data types
# Numeric Types
BIT TINYINT SMALLINT INT BIGINT DECIMAL NUMERIC FLOAT REAL
# Date & Time Types
DATE TIME DATETIME TIMESTAMP YEAR
# Char & String Types (N) Denotes Unicode Versions
CHAR VARCHAR TEXT NCHAR NVARCHAR NTEXT
# Binary Data Types
BINARY VARBINARY IMAGE
# Misc
CLOB BLOB XML JSON
Example 2: sql data types
• number(num) - whole numbers up to num digits
• number(num,num2) - num whole numbers up to num2 decimals
• char(num) - fixed length character/string
• varchar2(num) - used for varying length data
• date - full date
• currency - used for prices