Nikolas Tautenhahn wrote:
> DA Morgan schrieb:
> > One way would be to outer join to a pipelined table function.
>
> Do you mean that I should create the list of minutes with the pipelined
> table function and outer join the table in such a manner that the counts
> are generated? As I haven't done anything with pipelined table functions
> yet I am not fully aware of how powerful they are and where the
> limitations are...
>
> Regards,
> N.
It certainly would be one way. I have a demo in Morgan's Library that
does essentially the same thing by generating dates. Go to
www.psoug.org, click on the link for the library and scroll down to
Pipelined Table Functions. Look for "Generate Date List." It also shows
how to outer-join to a PTF.
--
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu (replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org
Received on Sat Jul 28 2007 - 09:46:39 CDT
