Data Types in Databases

Common Data Types

• VARCHAR2: Variable-length string
• CHAR: Fixed-length string
• NUMBER: Integer or decimal numbers
• DATE: Date and time values
• BLOB: Binary Large Object (e.g., images)

Example:

CREATE TABLE students (
  id NUMBER,
  name VARCHAR2(100),
  dob DATE
);