Repeat data based on count column [message #654745] |
Thu, 11 August 2016 10:42 |
anil_mk
Messages: 146 Registered: August 2006 Location: Bangalore, India
|
Senior Member |
|
|
Hi All,
I want to display ID column value based count value
Below is the example,
WITH J
AS (select 'A123' ID, (SYSDATE+3 - SYSDATE) CNT FROM DUAL UNION
select 'A1234' ID, (SYSDATE+2 - SYSDATE) CNT FROM DUAL UNION
select 'A1235' ID, (SYSDATE+1 - SYSDATE) CNT FROM DUAL)
select ID from j connect by LEVEL<=CNT ;
Expected output
ID
----
A123
A123
A123
A1234
A1234
A1235
Please help me to get above result set.
Thanks
|
|
|
|
|
|
|
|