A script-enabled browser is required for this page to function properly.

Condition syntax (Query Builder)

The general format of a condition is:

[expression] [operator] [expression]

 

Parameters

Description

expression

Specifies the values that define the condition.

 

Value Types

Description

Date

When working with dates, the comparison operators refer to relative time. So "less than" (<) means "before."

Date values must be enclosed in single quotes and specified in DD-MON-YY format, where DD represents the calendar day, MON represents the month, and YY represents the year.

Character

With character columns, operators refer to alphanumeric order (A comes before B, so names that begin with A are "less than" names beginning with B, and so forth).

Literal

Literal values must be enclosed in single quotes to distinguish them from column names. Comparison between the database values and the values you specify are case-sensitive.

Number

If the value you enter is a NUMBER datatype, type only the number. That is, do not use formatting such as commas or the currency ($) symbol. Numeric values in numeric columns do not need to be in quotes.

columns, functions, and database columns

The types associated with these values are determined by the column definition or the type of value returned in the case of a function.

operator

Specifies a comparison operator, such as greater than (>), less than (<), and equal to (=). The most common operators are listed in the Data menu and the Icon Bar. There are also a number of special comparison operators such as BETWEEN, LIKE, and IN.

There are also three logical (Boolean) operators (AND, OR, NOT) that enable you to create multiple or negative conditions.

For more information about Oracle syntax for various datatypes, refer to the Oracle9i Server SQL Language Reference Manual.

See also

About conditions (Query Builder)

Adding conditions to a query (Query Builder)