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)