Oracle 18c

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