Re: PL/SQL help

"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 Received on Thu Sep 28 2006 - 14:16:02 CDT