I wanted to list all week numbers in a year, along with their starting and ending dates of the week as below.
Week1(01-Jan-2018-07-Jan-2018)
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
Version:12.1.0.2.0