Tutorial

A narrative walk-through of pell, from “hello world” to the more advanced features. Each chapter shows pell source on top and the emitted PL/SQL below.

Read in order if you’re learning the language; otherwise jump to whatever you’re working on.

Chapters

1. Getting started
2. Modules and functions
3. Records and types
4. SQL blocks
5. Iteration: lists, for loops, FORALL
6. Errors and @retry
7. Types, sealed types, aggregates
8. Pipelined and parallel functions
9. Dynamic SQL: unsafe, exec_dyn, @touches
10. JSON
11. Regex with re:: and /pattern/
12. jq!{} for JSON queries
13. Pivot — typed and dynamic
14. pell exec and pell repl
15. The compilation model
16. REPL deep dive — variable persistence, auto-stringify, JSON/regex workflows, slash commands, debugging patterns

---

Table of contents

• Getting started
• Modules and functions
• Records and types
• SQL blocks
• Errors and @retry
• Types, sealed types, and aggregates
• Pipelined and parallel functions
• JSON
• jq!{} for JSON queries
• Pivot — typed and dynamic
• pell exec and pell repl
• The compilation model
• REPL deep dive