Is it possible to create pipelined table functions with columns that are aggregated.
count (*) as record_count
Your question is not clear. Do you want the pipelined function to perform the aggregation or you want to perform aggregation on the result returned by the pipelined function.
Please read Re: 2. How do I ask a question on the forums?