Another Oracle Dev Gym workout for you...

Pipelined Table Functions


Tim Hall of oracle-base.com fame explores pipelined table functions, which allow you to return rows from a function back to the calling query even before the function has accumulated all rows. After you read his article and check out the documentation, it's time to take five quizzes written by Steven Feuerstein to test your knowledge of this feature.

Information

  • Instructor

    Tim Hall*

  • Estimated Time

    59 Minutes

  • Difficulty

    Intermediate to Advanced

Oracle Account Text

You need an Oracle Account to take a workout. Click here to sign up.
Already a member of the Oracle Dev Gym? Click here to get back to work.

Exercises

Exercise Difficulty Time
Oracle Pipelined Table Functions (ORACLE-BASE)Not Provided5
Creating Pipelined Table Functions (documentation)Advanced20
Quiz on Pipelined Table FunctionsIntermediate5
Quiz on Pipelined Table FunctionsIntermediate5
Quiz on Pipelined Table FunctionsAdvanced8
Quiz on NO_DATA_NEEDEDAdvanced8
Quiz on Pipelined Table Function Collection DatatypesAdvanced7
Instructor

*About Tim Hall

Tim Hall is an Oracle DBA/Developer and well known Oracle blogger at https://oracle-base.com. If that isn't enough, he's written two books and over 900 articles, is an Oracle ACE Director, Oracle Developer Champion, OakTable member and has presented at numerous user groups and conferences worldwide.

More from Tim Hall