Skip to Main Content
Forums

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Changing default value for "nulls first" and "nulls last"

Vytenis BivainisSep 25 2008 — edited Sep 25 2008
Hello.

I would like Oracle rows with null values to appear on top of the result set when I use ORDER BY ASC and at bottom when I use ORDER BY DESC. Can I set this as the default value for my session (like ALTER SESSION) or whole database or anywhere so as not to rewrite my queries?

Thank you.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Oct 23 2008
Added on Sep 25 2008
1 comment
769 views