Oracle 21c

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

ALTER SESSION SET NLS_TERRITORY='America';
CREATE TABLE day_numbers(day_number, day_name) AS
SELECT TO_CHAR(SYSDATE + LEVEL, 'D'),
       TO_CHAR(SYSDATE + LEVEL, 'DY')
FROM   DUAL
CONNECT BY LEVEL <= 7;
7 rows affected

SELECT * FROM day_numbers;


DAY_NUMBER
DAY_NAME


7
SAT

1
SUN

2
MON

3
TUE

4
WED

5
THU

6
FRI