NEXT_DAY is one of the vital Date/Time functions of Oracle. It is used to get the first weekday that is greater than the mentioned date. The NEXT_DAY function is supported in the various versions of the Oracle/PLSQL, including, Oracle 12c, Oracle 11g, Oracle 10g and Oracle 9i.
NEXT_DAY ( date, weekday )
date: It is used to specify the date.
weekday: It is used to specify the day of the week to be returned.
NEXT_DAY ( ‘26-JUN-19’, ‘SUNDAY’)
The result is the date of the first SUNDAY greater than the mentioned date.