Re: generate number of rows form a column value

"Michael Austin" <maustin_at_firstdbasource.com> a écrit dans le message de news: 3boFl.24713$Ws1.4613_at_nlpi064.nbdc.sbc.com...
| Michel Cadot wrote:
| > "newhorizon" <mehmeteser_at_gmail.com> a écrit dans le message de news:
| > 384f7ea9-f2eb-4395-825a-f5013d5475c2_at_f19g2000yqh.googlegroups.com...
| > | create table test_table ( isim varchar2(50), cnt number);
| > | insert into test_table values ('John', 1) ;
| > | insert into test_table values ('Dave', 2) ;
| > | insert into test_table values ('Simit', 3) ;
| > | insert into test_table values ('TEST', 0) ;
| > |
| > |
| > | How can I generate an output like the following :
| > |
| > |
| > | John 1
| > | Dave 2
| > | Dave 2
| > | Simit 3
| > | Simit 3
| > | Simit 3
| > |
| > | Release of ora10gR2
| > |
| >
| > http://www.dba-village.com/dba/village/dvp_forum.OpenThread?ThreadIdA=35935#127371
| >
| > Regards
| > Michel
| >
| >
|
|
| Again, while it may be done in a variety of ways, it is makes no sense
| other than to demonstrate that it can be done (and with multiple people
| asking the same question in dba-village and here, sure smells like
| homework to me...)

I completly agree with you.
This has no purpose other than a SQL or PL/SQL exercise.

Regards
Michel Received on Wed Apr 15 2009 - 12:10:14 CDT