create table data_row
(
col1 varchar2(30)
,col2 varchar2(20)
,col1n number
,col2n number
,col3c varchar2(20)
)Table created.
insert into data_row
values ('plant','cactus',3,4,'special plant')1 row(s) inserted.
insert into data_row
values ('plant','mint',3,2,'plant')1 row(s) inserted.
with rws as (
select rownum r from dual connect by level <= 2
)
select *
from data_row
join rws
on case when col2n > col1n then 2 else 1 end <= rws.r| COL1 | COL2 | COL1N | COL2N | COL3C | R | plant | mint | 3 | 2 | plant | 1 | plant | cactus | 3 | 4 | special plant | 2 | plant | mint | 3 | 2 | plant | 2 |
|---|