www.mimer.com/developer

Basic SQL Syntax Rules

---

This chapter presents the basic units of the SQL language and the simplest relationships between them.

The following units are considered:

Syntax unit	Summary	Section
Characters	Basic language symbols: letters, digits, special characters.	Characters
Identifiers	SQL identifiers, host variable names.	Identifiers
Data types	Character, exact numeric, approximate numeric, date, time, timestamp, interval. Datetime and interval arithmetic.	Data Types in SQL Statements
Literals	Character, integer, decimal, floating point, date, time, timestamp, interval.	Literals
Assignments	Character, numeric, datetime and interval assignments. Data type conversions.	Assignments
Comparisons	Character, numeric, datetime and interval comparison rules.	Comparisons

Upright Database Technology AB Voice: +46 18 780 92 00 Fax: +46 18 780 92 40 dbtechnology@upright.se