user573224 wrote:Basically this is an application (sql) issue. If you do not code explicitly, ascending ordering is default and also means that nulls last is the default.
I have a schema of 117 tables and I would like Oracle to behave nulls first when doing any order by on any tables.
As it is today, I have to write some custom DAO specific to Oracle just so as to have a nulls first in the sql statements.Changing how a database engine behaves seems like the opposite of dbms agnostic application, if that's the purpose. Also in general, database agnostic/ignorant applications are often considered a sure way to unscalable and unmanageable systems.