NICE AND USE FULL
Gyanaranjan Nayak, August 08, 2016 - 3:53 am UTC
Thanks a lot sir. You are superb!!
Specifying an nls_date_language would be better
William Robertson, August 08, 2016 - 4:18 pm UTC
Just to be safe, I'd also specify a language:
if to_char(sysdate,'DY', 'nls_date_language = English') = 'SUN'
then ...
August 09, 2016 - 2:46 am UTC
Good point.