database - Oracle order NULL LAST by default - Stack Overflow

PHOTO EMBED

Fri Oct 15 2021 14:30:46 GMT+0000 (Coordinated Universal Time)

Saved by @mvieira #sql

SQL> with t1(col) as(
  2    select 1    from dual union all
  3    select 2    from dual union all
  4    select null from dual union all
  5    select 3    from dual
  6  )
  7  select *
  8    from t1
  9  order by col asc nulls last
  10  ;
content_copyCOPY

https://stackoverflow.com/questions/18698311/oracle-order-null-last-by-default