generate several line with a query

[monrow]

Hi,

I've table with this data

ColA ColB ColC
code1 1 ZE
code2 2 ER:GP
code3 3 SP:NS:LK

I want to obtain this result :

code1 1 ZE
code2 2 ER
code2 2 GP
code3 3 SP
code3 3 NS
code3 3 LK

is-it possible to obtain a result;
how can i built my query ?

thanks for your help

 

[r937]

which database system are you using? you'll probably get a much better answer if you post this question in the appropriate forum



r937.com | rudy.ca

 

[monrow]

i'm on oracle 9

 

[PHV]

Your DB seems to be very poorly designed.
Have a look here:

http://r937.com/relational.html

 

[monrow]

yes, i know
but i can't redesigne the database

 

[r937]

please post in the oracle forum

r937.com | rudy.ca

 

[monrow]

ok,
i've post it in oracle forum now