Queen/Pink Floyd

Hi, don't ask why but ....

CREATE TABLE tbltest(a VARCHAR2(200));
INSERT INTO tbltest(a) VALUES ('brian may john deacon roger taylor freddy mercury');
INSERT INTO tbltest(a) VALUES ('nick mason david gilmour roger waters richard wright');

Is it a simple exercise to create another table from this table, so that:

SQL >
SQL > SELECT * FROM rock;
brian
may
john
deacon
roger
taylor
freddy
mercury
nick
mason
david
gilmour
roger
waters
richard
wright

SQL>
SQL> Received on Fri Dec 13 2002 - 11:15:49 CST