Re: SQL Question - Adding rows to the resultset

From: Randolf Geist <mahrah_at_web.de>
Date: Wed, 11 Mar 2009 00:47:03 -0700 (PDT)
Message-ID: <3d9b377b-3212-4cb3-bc13-16401cd968c5_at_o36g2000yqh.googlegroups.com>

On Mar 10, 9:26 pm, Gokul <gokulkumar.go..._at_gmail.com> wrote:
> Hi Steve,
>
> We are already looking at writing a PL/SQL program to solve the
> problem. Was interested to know
> if this was possible in SQL.
>
> Thanks for your response.
> Gokul

Gokul,

you might want to post this over on the OTN PL/SQL forum (http:// forums.oracle.com/forums/forum.jspa?forumID=75&start=0). I'm quite confident you'll find some SQL gurus over there that can solve your issue in plain SQL. At least in 10g using the MODEL clause the logic should be applicable quite easily, although I second the points made that you need to make clearer descriptions, e.g. what are "first"/"next" transactions etc.

Regards,
Randolf

Oracle related stuff blog:
http://oracle-randolf.blogspot.com/

SQLTools++ for Oracle (Open source Oracle GUI for Windows): http://www.sqltools-plusplus.org:7676/
http://sourceforge.net/projects/sqlt-pp/ Received on Wed Mar 11 2009 - 02:47:03 CDT