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

0 vote352 views1 answer
Mysql random number between 1 and 100
SQL
1 vote321 views1 answer
Mysql get character set
SQL
-1 vote294 views1 answer
Plsql while
SQL
0 vote328 views2 answers
Cascade syntax in sql
SQL
1 vote352 views1 answer
Group_concat order by
SQL
0 vote369 views2 answers
#1273 - Unknown collation: 'utf8mb4_0900_ai_ci'
SQL
0 vote310 views1 answer
Sql select rows between 1000 and 2000
SQL
0 vote373 views1 answer
Snowflake drop column
SQL
11 votes368 views2 answers
Having clause in sql
SQL
0 vote390 views1 answer
Mysql get nth highest
SQL