Oracle Magazine, September/October 2018
Database Developer PL SQL ORACLE MAGAZINE SEPTEMBER OCTOBER 2018 64 tion will consume PGA memory so very large datasets passed into the function via the cursor variable may result in errors What can you do about that Make that streaming table function a pipelined streaming table function which Ill cover in the next article in this series Steven Feuerstein is a developer advocate for Oracle specializing in PL SQL Feuersteins books including Oracle PL SQL Programming videos and more than 1500 quizzes at the Oracle Dev Gym devgym oracle com provide in depth resources for Oracle Database developers ILLUSTRATION BY WES ROWELL NEXT STEPS READ more about table functions LEARN more about PL SQL table functions a Dev Gym class EXPLORE the code used in this article at Oracle Live SQL
You must have JavaScript enabled to view digital editions.