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)
- view (on a loop)
- snapshot (on a loop)