Literals

• Numeric
  • 123
  • 123d
  • 123f
  • 123.456
  • 123.456f
  • 123.456d
• Alphanumeric / String
  • 'Hello'
  • '123'
• Date / Interval
  • DATE '2017-03-30'
  • TIMESTAMP '2017-03-30 13:45:59'
  • INTERVAL '3' MINUTE
  • INTERVAL '2' MONTH

Variable

• System Variable
  • SYSDATE
  • CURRENT_DATE
  • SYSTIMESTAMP
  • LOCALTIMESTAMP
  • USER

Operators

Arithmetic Operators

• +
• -
• *
• /

Comparison Operators

• =
• >
• <
• >=
• <=
• <>
• !=

Logical Operators

• AND
• OR
• NOT

Data Type

Numeric

• NUMBER

String

• VARCHAR2
• CHAR
• CLOB

Date

• DATE
• TIMESTAMP
• INTERVAL