By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
create table products (product_id number, isin char(10), status char(10), pdate date);
insert into products values(1,'AC','Active',NULL);
1 rows affected
insert into products values(2,'AC','Active',NULL);
1 rows affected
insert into products values(3,'AC','Active',NULL);
1 rows affected
select concat('http://localhost/app/feeds/send?type=myType' || CHR(38) || 'ids=' , product_id) from products where isin like 'AC%' and status in
('Active', 'Created', 'Live')
and
((pdate>to_date('07.05.2021','dd.MM.yyyy') or pdate is null));
| CONCAT('HTTP://LOCALHOST/APP/FEEDS/SEND?TYPE=MYTYPE'||CHR(38)||'IDS=',PRODUCT_ID) |
|---|
| http://localhost/app/feeds/send?type=myType&ids=1 |
| http://localhost/app/feeds/send?type=myType&ids=2 |
| http://localhost/app/feeds/send?type=myType&ids=3 |
select 'http://localhost/app/feeds/send?type=myType' || CHR(38) || 'ids=' ||
LISTAGG(product_id,',') WITHIN GROUP (ORDER BY product_id)
from products where isin like 'AC%' and status in
('Active', 'Created', 'Live')
and
((pdate>to_date('07.05.2021','dd.MM.yyyy') or pdate is null));
| 'HTTP://LOCALHOST/APP/FEEDS/SEND?TYPE=MYTYPE'||CHR(38)||'IDS='||LISTAGG(PRODUCT_ID,',')WITHINGROUP(ORDERBYPRODUCT_ID) |
|---|
| http://localhost/app/feeds/send?type=myType&ids=1,2,3 |