This illustration shows the following syntax on a horizontal line:
EXEC SQL SELECT
select_list
AT
db_name (on a loop)
:host_variable (on a loop)
INTO FROM
table_list
:host_variable (on a loop)
:indicator_variable (on a loop)
INDICATOR
(on a loop)
WHERE
condition (on a loop)
CONNECT BY
condition (on a loop)
START WITH
condition (on a loop)
GROUP BY
expr (on a loop)
HAVING
condition (on a loop)
UNION SELECT
command (on a loop)
UNION ALL
(on a loop)
INTERSECT
(on a loop)
MINUS
(on a loop)
ORDER BY
expr (on a loop)
position (on a loop)
ASC
(on a loop)
DESC
(on a loop)
FOR UPDATE
(on a loop)
NOWAIT
(on a loop)
OF
column (on a loop)
table (on a loop)
schema (on a loop)
snapshot (on a loop)
view (on a loop)