Oracle sql winter time change

ALTER SESSION SET NLS_LANGUAGE=english; -- First day of week
SELECT 
	NEXT_DAY(LAST_DAY(TO_DATE(TO_CHAR('01/10/' -- Last Sunday of October 02:00
        || (EXTRACT(YEAR FROM SYSDATE)-5 + level) || '02:00:00'), 
           'DD/MM/YYYY HH24:MI:SS')) - INTERVAL '7' DAY, 'SUNDAY') AS H_WINTER,
	NEXT_DAY(LAST_DAY(TO_DATE(TO_CHAR('01/03/' -- Last Sunday of March 02:00 
		|| (EXTRACT(YEAR FROM SYSDATE)-5 + level) || '02:00:00'),
		'DD/MM/YYYY HH24:MI:SS')) - INTERVAL '7' DAY, 'SUNDAY') AS H_SUMMER
FROM DUAL CONNECT BY level <=10;
-- ⇓ Test it ⇓ (Fiddle source link)

Similar codes

1 vote256 views1 answer
Tsql random number
SQL
0 vote309 views1 answer
SQLSTATE[01000]: Warning: 1265 Data truncated for column 'job_type' at row 1 (SQL: insert into
SQL
3 votes303 views2 answers
Truncate table
SQL
0 vote252 views1 answer
Mysql get 2nd value in comma separated list
SQL
3 votes267 views1 answer
Apex set debug level
SQL
1 vote291 views1 answer
Show databases mysql docker
SQL
0 vote283 views2 answers
Get item by composite primary key mysql
SQL
0 vote250 views4 answers
Sql limit 1 offset 1
SQL
0 vote278 views1 answer
Sql log file inof
SQL
1 vote264 views1 answer
Timestamp in sqlite
SQL