Logic for one row to multiple rows

[pandeesh]

Using Row Generator, is it possible to get the below 5 rows with 2 columns as output.(columns are comma separated for illustration)

Code: Select all

col1,col2
----------
DUMMY,ABC
DUMMY,ZSE
DUMMY,HYT
DUMMY,OIU 
DUMMY,LKP

All are fixed and there is no logic in deriving.

Thanks

[pandeesh]

Yes. I have accomplished that using Row Generator.
One more way i can think of is using Oracle enterprise stage by ytilizing dual table.

Code: Select all

select 'DUMMY' as DUMMY,"ABC" as VALUE from dual
UNION
select 'DUMMY' as DUMMY,"ZSE" as VALUE from dual
....
....
...

Thanks