| cex2 | cobex2 | forex2 | pasex2 | Single-row SELECT into host variables from PurchDB.Parts |
| cex5 | cobex5 | forex5 | pasex5 | Single-row SELECT into host variables from PurchDB.Parts with implicit
and explicit error handling, including recovery from deadlock |
| cex7 | cobex7 | forex7 | pasex7 | Single-row SELECT, INSERT, UPDATE, and DELETE operations on the PurchDB.Vendors table |
| cex8 | cobex8 | forex8 | pasex8 | Cursor manipulations on the PurchDB.OrderItems
table |
| cex8a* | cobex8a* | forex8a* | pasex8a* | DATE/TIME data types and join operations
on the TestData and SupplyBatches tables. |
| cex9 | cobex9 | | pasex9 | BULK operations on the PurchDB.Orders
and PurchDB.OrderItems tables |
| | cobex10a | forex9a | | Dynamic non-query commands using EXECUTE IMMEDIATE |
| | cobex10b | forex9b | | Dynamic non-query commands using PREPARE and EXECUTE |
| cex10a | | | pasex10a | Dynamic query commands with unknown
Format |
| cex10b | | | pasex10b | Dynamic query commands with known
Format |
| cex12* | cobex12* | forex12* | pasex12* | Using long fields in the PurchDB.Reports
table |
