select

Executes an SQL select statement.

Synopsis

Description

The select command selects and lists the objects that are specified by evaluating the entire command as an SQL query. If no argument is specified, the command lists any objects selected by a preceding select command or by the -sqlselect option.

Operand

SQL

An SQL select statement (without the leading select because that is already present as the name of the command).

Examples

The following command lists all ClassificationScheme objects in the Registry:

admin> select s.* from ClassificationScheme s