Re: generate number of rows form a column value
From: Michel Cadot <micadot{at}altern{dot}org>
Date: Wed, 15 Apr 2009 17:15:55 +0200
Message-ID: <49e5fa2b$0$27599$426a74cc_at_news.free.fr>
Date: Wed, 15 Apr 2009 17:15:55 +0200
Message-ID: <49e5fa2b$0$27599$426a74cc_at_news.free.fr>
"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
Received on Wed Apr 15 2009 - 10:15:55 CDT