Skip to Main Content
Forums

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Generate rows based on the column value

2664030Nov 18 2017 — edited Nov 18 2017

Hello Friends,

I have a table TAB1 with 1 column COL1 as below,

COL1

1

2

3

I want the result as,

COL1

1

2

2

3

3

3

Kindly help!
This post has been answered by Boobal Ganesan on Nov 18 2017
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Dec 16 2017
Added on Nov 18 2017
3 comments
497 views