Re: PL/SQL help

From: Maxim Demenko <mdemenko_at_gmail.com>
Date: Thu, 28 Sep 2006 20:47:26 +0200
Message-ID: <efh5c1$4ua$00$1@news.t-online.com>

Frank van Bortel schrieb:

> Michel Cadot schreef:


>> SQL> select * from t2;

>> NOM          NO_CASES

>> ---------- ----------

>> Smith               2

>> John                3

>> Mary                2

>> Kate                1

>>
>> 4 rows selected.
>>
>> SQL> with
>> 2 rn as (
>> 3 select rownum rn from dual
>> 4 connect by level <= (select max(no_cases) from t2)
>> 5 )
>> 6 select nom
>> 7 from t2, rn
>> 8 where rn <= no_cases
>> 9 order by nom
>> 10 /

> 
> 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 ('/').
> 

Unfortunately, will lead to an error...
;-)

Best regards

Maxim Received on Thu Sep 28 2006 - 13:47:26 CDT