NLS_FORMAT_DATE default format is DD-MON-RR

It is a known fact thatĀ NLS_FORMAT_DATE default format is DD-MON-RR, but the date literal can be used in multiple forms and still be fit the format. I’ve found the following question a bit tricky

because the right answers are A and C. See below for more. All these DATEĀ literals are valid for default NLS_FORMAT_DATE and all of then produce the same result

 

Leave a comment

Your email address will not be published. Required fields are marked *