SQL Language (MOSC)

MOSC Banner

split a row into multiple rows based on column values

edited Sep 6, 2017 9:54AM in SQL Language (MOSC) 3 commentsAnswered

Hi Gurus,

My table is as below:

op_num       col1         col2           col3                col4

100                0              1               2                    0

200                2             3                0                     1

Required output:

op_num       col1       

100                1

100                2           

200                2

200                3

200                1.

Can you please help me in this. 

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center