I wanted to list all week numbers in a year, along with their starting and ending dates of the week as below.
I am able to get the Week numbers using the below query.
select to_char(sysdate,'ww') from dual;
But I am not able to get the total list of of week numbers in a year along with their dates as shown above. Any help please