Re: generate number of rows form a column value
From: Michael Austin <maustin_at_firstdbasource.com>
Date: Wed, 15 Apr 2009 11:47:46 -0500
Message-ID: <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
>
>
Date: Wed, 15 Apr 2009 11:47:46 -0500
Message-ID: <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...) Received on Wed Apr 15 2009 - 11:47:46 CDT