SQL Script Examples
This section contains several examples illustrating the use of the SQL Script language. All the examples assume a user named test in the domain composite.
• | Example 1 (Fetch All Rows) |
• | Example 2 (Fetch All Categories) |
• | Example 3 (User-Defined Type) |
• | Example 4 (User-Defined Type) |
• | Example 5 (Pipe Variable) |
• | Example 6 (Dynamic SQL Extract with Individual Inserts) |
• | Example 7 (Dynamic SQL Inserts by Variable Name) |
• | Example 8 (Prepackaged Query) |
• | Example 9 (Exception Handling) |
• | Example 10 (Row Declaration) |
• | Example 11 (Avoiding Division-by-Zero Errors) |
Subtopics