Other Oracle database topics

You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author

Query Help

Reiro

2006-03-22, 7:25 am

Hi

I have a test database with many columns Name1, Name2 .............and
so on. Set out as follows:

Name1 Name2
.............................
Ridwan Nathaniel
Irfhan Koena

I need the data as follows:

Name3

Ridwan
Irfhan
Nathaniel
Koena

Plz Help....

Thanks in Advance..... :)

Bertrand Guillaumin

2006-03-22, 7:25 am

Try :

SELECT NAME1 as NAME3 FROM TABLE UNION ALL SELECT NAME2 as NAME3 FROM
TABLE etc...

Repeating union all as many times as you need.

Regards,

Sponsored Links