SELECT LEVEL + DATE '2019-11-01' dateFlag ,LEVEL + DATE '2019-11-01' dateF , trunc(dbms_random.value(1,50)) AS value
FROM dual
CONNECT BY LEVEL < DATE '2021-12-31' - DATE '2019-11-01' + 2
SELECT LEVEL + DATE '2019-11-01' dateFlag ,LEVEL + DATE '2019-11-01' dateF , trunc(dbms_random.value(1,50)) AS value
FROM dual
CONNECT BY LEVEL < DATE '2021-12-31' - DATE '2019-11-01' + 2