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!

add a row after every n records

683484Apr 15 2009 — edited Apr 15 2009

Hi

I have a query that returns only one column

Column1
-----------
a
b
c
d
g
e
f
g
h

I want to add 01 as the first row and then after 5 records i want to add 02 then 03 after another 5 records and so on i.e

Column1
------------
01
a
b
c
d
e
02
f
g
h

How can this be done?

Locked Post

New comments cannot be posted to this locked post.

Locked on May 13 2009

Added on Apr 15 2009

5 comments

494 views