NULLs Last « Analytical Functions « Oracle PL / SQL






  1. Oracle PL / SQL
  2. Analytical Functions
  3. NULLs Last
1.Control whether nulls are the highest or lowest in a group using NULLS LAST
2.NULLS LAST: place null value at the end
3.If NULLS LAST is left out of the final ORDER BY, the effect will be lost
4.If the statement were without NULLS LAST, the values of the NVL'd nulls occur first
5.order by nulls last