convert long column into rows
Using Oracle 9i SQL (no PL/SQL due to gui front end)
I have 3 columns. System, franchise, servcode. In servcode column it can be up to 1200 char wide. Service codes displayed set up like this: AA BB CC DD EE FF etc. May be one 2char code wide, or 300 2char codes wide with a space in between. Need to figure out how to display system, franchise, and then convert the servcode column into multiple rows, as many rows as there are codes. Ive tried a replace command that wherever there is the space, that a CHR(10) (carriage return) is inserted. That got me multiple rows of code, but in my gui (Forest & Trees) it still shows as one row. Ex:
system franchise servcode
8888 10 AA
I really need the system & franchise to be displayed on each line,and the codes displayed along side them. Have never run across a problem like this before. any ideas would be greatly appreciated. Thanks much.