EXEC SQL [AT { db_name | :host_variable }] SELECT select_list INTO :host_variable [[INDICATOR] :indicator_variable] [, :host_variable [[INDICATOR] :indicator_variable]]... FROM table_list [WHERE condition] { [START WITH condition] CONNECT BY condition | CONNECT BY condition [START WITH condition] | GROUP BY expr [, expr]... [HAVING condition] } [ [START WITH condition] CONNECT BY condition | CONNECT BY condition [START WITH condition] | GROUP BY expr [, expr]... [HAVING condition] ]... [ WITH READ ONLY | WITH CHECK OPTION ] [{ UNION | UNION ALL | INTERSECT | MINUS } SELECT command]