1

When the NULL ordering is not specified, then the handling of the NULL values is:

  • NULL values are last if the sorting is ASC
  • NULL values are first if the sorting is DESC

Why is this so?

enter image description here

Improve this question

1 Answer 1

Reset to default
9

It is written in the Oracle Documentation:

If the null ordering is not specified then the handling of the null values is: NULLS LAST if the sort is ASC NULLS FIRST if the sort is DESC

Here it is.

Improve this answer
Sign up to request clarification or add additional context in comments.

1 Comment

Also note from the documentation linked, that placement of the nulls can be changed, if desired, DESC NULLS LAST.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.