I need to help with converting this expression from SQL to Oracle: if (month(current_date) < 10) then (year(current_date)) else (year(current_date) + 1). below is the error message that I’m getting.
UDA-SQL-0107 A general exception has occurred during the operation “prepare”.
ORA-00904: “YEAR”: invalid identifier.
I appreciate your help in advance