How can I rollup multiple rows of data into one row
I have the following table and data:
CREATE TABLE t1 (col1 VARCHAR2(1), col2 VARCHAR2(25));
INSERT INTO t1 (col1,col2) VALUES ('1','TEST1');
INSERT INTO t1 (col1,col2) VALUES ('2','TEST1');
INSERT INTO t1 (col1,col2) VALUES ('5','TEST2');
INSERT INTO t1 (col1,col2) VALUES ('9','TEST2');
INSERT INTO t1 (col1,col2) VALUES ('1','TEST3');
INSERT INTO t1 (col1,col2) VALUES ('1','TEST4');
INSERT INTO t1 (col1,col2) VALUES ('5','TEST5');
I would like to get the following results from a single query:
co1 col2
TEST1 1,2
TEST2 5,9
TEST3 1
TEST4 1
TEST5 5
If anyone knows how to do this using connect by i would appreciate your help. Thanks