Re: Queen/Pink Floyd

Monty,

You'll need to write a prorgram. I ran into this when needing to change from a single E_Mail column to two columns (e.g. Userid and Domain). Originally, I didn't see a value in having two columns (Userid and Domain) but when add statistics (in release 2), I saw the light (need). While I wrote my program in REXX (since it ended up doing more than breaking the column into two), your program could be in PL/SQL (or some other language)..

Bertram Moshier
Oracle Certified Professional 8i and 9i DBA

http://www.bmoshier.net/bertram

"Monty" <mmontreaux_at_hotmail.com> wrote in message news:6284dd3.0212130915.12d6df70_at_posting.google.com...
> 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 Sat Dec 14 2002 - 19:05:25 CST