What is a pipelined function?

Posted on 2011-10-10
Last Modified: 2012-05-12
I need to use a stored procedure written by our DBA that he's calling a "pipelined function".

Please explain this. We work with Oracle, and the app I am supporting is MVC3 in C#.

Question by:newbieweb
    LVL 73

    Accepted Solution

    a pipelined function is a function that returns a collection type.
    Sometimes called a "table function"  because you can query the function as if it were a table.

    select * from table(your_function(1,2,3))

    "pipelining" is a special way of returning the collection from inside the function.
    rows will only be returned as they are needed.  As opposed to a non-pipelined function which will generate the entire collection and return all of it in one step.

    LVL 12

    Assisted Solution

    this url gives a detailed explanation of the pipelined functions:

    Author Closing Comment


    Featured Post

    Highfive + Dolby Voice = No More Audio Complaints!

    Poor audio quality is one of the top reasons people don’t use video conferencing. Get the crispest, clearest audio powered by Dolby Voice in every meeting. Highfive and Dolby Voice deliver the best video conferencing and audio experience for every meeting and every room.

    Join & Write a Comment

    Suggested Solutions

    APEX (Application Express) is used to develop a web application from Oracle. SQL Workshop is one of the tools that comes with Oracle APEX to query or modify the database objects or to make any changes to the structure.
    From implementing a password expiration date, to datatype conversions and file export options, these are some useful settings I've found in Jasper Server.
    Via a live example show how to connect to RMAN, make basic configuration settings changes and then take a backup of a demo database
    Video by: Steve
    Using examples as well as descriptions, step through each of the common simple join types, explaining differences in syntax, differences in expected outputs and showing how the queries run along with the actual outputs based upon a simple set of dem…

    729 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    19 Experts available now in Live!

    Get 1:1 Help Now