Re: query: "count" each minute between start/end

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@xxxxxxxxxxxxxxxx (replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org
.

Relevant Pages

  • Re: Outer join problem
    ... Create an in-line view with an outer join then outer join the in-line ... view to the balance of the query. ... Daniel A. Morgan ...
    (comp.databases.oracle.server)
  • Re: Merge result of two queries?
    ... outer join. ... the missing dates. ... Daniel A. Morgan ...
    (comp.databases.oracle.misc)
  • Re: Hi! All
    ... in one query return the distinct rows from both tables and the name ... The result from the single query should be: ... Daniel A. Morgan ... FULL OUTER JOIN T2 ...
    (comp.databases.oracle.tools)