Commands

SELECT

The SELECT command, like a standard SQL Select statement, selects and retrieves rows from a database based on the given criteria. Standard SQL syntax is supported for the SELECT command, along with the Omnidex extensions to the SQL standard.

See SELECT Statement for details about valid statements.

Syntax

SELECT statement [ON [CURSOR] cursor] [WITH options]

SELECT
Required

statement
Required.

ON [CURSOR] cursor
Optional - Specify which cursor to perform this command on.

[WITH options]
Optional - Specify options to be used for this command.

Options

Example

See SELECT Statement for examples of various types of SQL SELECT statements.

Top