0
I am trying as below
expecting thirty records however getting only one record
the query is
with dts as (
select to_date('01-apr-2021','dd-mon-yyyy') start_date,
to_date('01-apr-2021','dd-mon-yyyy')+level-1 hdate from dual
connect by level<=to_date('30-apr-2021','dd-mon-yyyy')-to_date('01-apr-2021...