Constants

The constants allowed in query clauses are shown in the following table. The class of attribute types that are found are determined by the specified constant.

For example, if the constant is a string, only string attributes, or attributes that are a subtype of string, are found.

Table 1. Constants allowed in query clauses
Constant Type Comments
string Enclose strings in single quotation marks.
integer Integer values can be zero to +-2147483647.
boolean Boolean values can be TRUE or FALSE.
time Time values must be in the form time(’time_string’). See Date formats.

Feedback