Re: Queen/Pink Floyd

Monty wrote:

> 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>
Very simple.

You will need:

1. An anonymous block
2. A cursor
3. A loop
4. INSTR
5. SUBSTR
6. An insert statement
7. A commit

Dan Morgan Received on Fri Dec 13 2002 - 17:37:05 CST