How to add a year to the date in Oracle SQL?
SQLTeam is a Microsoft SQL Server site, we're not experts in Oracle.
It seems that you can accomplish what you're looking for using CURRENT_DATE and INTERVAL expressions, see here for some more detail:
https://docs.oracle.com/cd/B19306_01/server.102/b14200/sql_elements003.htm#sthref371