Traverse hierarchical and graph-like structures such as org charts, file systems, and routing paths using recursive SQL. Replace procedural logic and UDFs by expressing loops with standard SQL syntax.

Begins a new interactive transaction that groups multiple SQL statements into a single unit of work that can be committed or rolled back. As an alternative to interactive transactions, you can define ...