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
);