ADD_DAYS SQL Function

You can use ADD_DAYS to add a specified number of days to a date, as in the following example:

UPDATE tab1

SET next_year = ADD_DAYS(SYSDATE,365)