Streaming table functions are functions executed in the FROM clause of a query as part of a sequence of data transformations, all occurring within a single SQL statement. This video shows how to define a streaming table function and use it in Oracle SQL.
Part of the Getting Started with PL/SQL Table Functions class at the Oracle Dev Gym: https://devgym.oracle.com/pls/apex/dg...
========================================
Practically Perfect PL/SQL with Steven Feuerstein
Copyright © 2018 Oracle and/or its affiliates. Oracle is a registered trademark of Oracle and/or its affiliates. All rights reserved. Other names may be registered trademarks of their respective owners. Oracle disclaims any warranties or representations as to the accuracy or completeness of this recording, demonstration, and/or written materials (the “Materials”). The Materials are provided “as is” without any warranty of any kind, either express or implied, including without limitation warranties or merchantability, fitness for a particular purpose, and non-infringement.