Oracle Magazine, September/October 2018

Database Developer PL SQL BY STEVEN FEUERSTEIN ORACLE DATABASE Streaming Table Functions Transform your data on the way to your data warehouse A table function is a function you can use like a table in the FROM clause of a SELECT statement A common usage of table functions is to stream data directly from one process or transformation to the next process without intermediate staging and a table function used in this way is called a streaming table function As you might be able to tell from the reference to transformation above this technique is most often used in data warehouses as part of extract transform and load ETL operations My previous article When Is a Function Like a Table When Its a Table Function includes an overview of table functions In this article I will show you the basic steps needed to create a streaming table function but before diving into the details lets look at a streaming table function example ORACLE MAGAZINE SEPTEMBER OCTOBER 2018 48 INSERT INTO tickers SELECT

View the Covers and the Table of Contents pages from every issue of this publication, all gathered together for easy browsing. Just flip pages and zoom as you normally do to see each issue's Cover and Table of Contents, then follow links directly to interesting content.