Cookbook

Task-oriented recipes for common problems. Each recipe is self-contained and shows the full pell source plus the PL/SQL it lowers to — copy, paste, adapt.

Recipes

• Validate an email address
• Parse a phone number into a typed record
• Bulk-insert with forall
• Retry on deadlock
• Stream rows with a pipelined function
• Upsert with MERGE
• Extract typed fields from a JSON document

---

Table of contents

• Validate an email address
• Parse a phone number into a typed record
• Bulk-insert with FORALL
• Retry on deadlock
• Stream rows with a pipelined function
• Upsert with MERGE
• Extract typed fields from a JSON document