generate number of rows form a column value
From: newhorizon <mehmeteser_at_gmail.com>
Date: Wed, 15 Apr 2009 03:19:05 -0700 (PDT)
Message-ID: <384f7ea9-f2eb-4395-825a-f5013d5475c2_at_f19g2000yqh.googlegroups.com>
Date: Wed, 15 Apr 2009 03:19:05 -0700 (PDT)
Message-ID: <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 Received on Wed Apr 15 2009 - 05:19:05 CDT