| 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
|
