Michel Cadot wrote:
> "DA Morgan" <damorgan_at_psoug.org> a écrit dans le message de news: 1159469806.57467_at_bubbleator.drizzle.com...
> | Frank van Bortel wrote:
> |
> | > As always - a beauty! But the OP mentioned PL/SQL in the header...
> | > OP: add begin as line 0, and end; as last line.
> | > Then enter a slash ('/').
> |
> | Agreed. I too say PL/SQL and assumed the OP was a student following
> | instructions ... thus my rather basic ... and cryptic reply.
> |
> | But Michel ... this is a gem.
> |
> | I have put a demo, based on your code, into Morgan's Library on the
> | WITH CLAUSE page with, what I hope is, appropriate attribution.
> | --
> | Daniel Morgan
> | Puget Sound Oracle Users Group
>
> Just 2 small remarks: my first name is Michel without the final e
> and I used an "order by" in my select just to easily count the rows
> but it is not necessary in the insert statement.
>
> Regards
> Michel Cadot
My apology. It was just an American brain on autopilot.
--
Daniel Morgan
Puget Sound Oracle Users Group
Received on Thu Sep 28 2006 - 15:05:54 CDT
