Simple SELECT statements are built from a select-specification optionally followed by either an ORDER BY or a FOR UPDATE OF clause. More complex statements can combine two or more select-specifications with the UNION operator.
Select statements are used in embedded SQL (including Procedural usage contexts) to define cursors and as the input to dynamic PREPARE statements.
The embedded SELECT statement is syntactically equivalent to the interactive data retrieval SELECT statement. In embedded contexts however, the statement cannot be used to retrieve data directly but must be implemented through a cursor.
See SELECT for the full syntax of the SELECT statement.
Upright Database Technology AB
Voice: +46 18 780 92 00
Fax: +46 18 780 92 40