Version: Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Hello,
I need help to create a query to display a list of weeks that will be used as a List of Values in APEX (23.2) which requires a “Display” value and a “Return” value.
So, at the time of this post it was week 37. The list of weeks would be 1 to 37. Next week the list would be 1 to 38 etc. When it's Leap Year then week 53 would be in the list when that week became the current week.
I came up with a query to get all 53 weeks, but the request is to display this list as described. Can someone help me with creating this query?
The query I found for displaying all 53 weeks is:
SELECT LEVEL week_number, LEVEL
FROM dual
CONNECT BY LEVEL <= 53;
Please let me know if you have any questions.
Thanks,
Joe