Description of the illustration image043.gif

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)