var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Oracle: ORDER Options
i want oracle to sort my query with empty string in a sort field to be listed at the beginning not at the end.
Are there any options that i can add after "Order by Field" like the parameters DESC for example?
Thanks for your help.
Something like this?
assuming sort_column has a character datatype
...ORDER BY DECODE(sort_column, '', '1','2') || sort_column
If you want to output the null first then
order by sort_column asc nulls first;
You do not need a parachute to skydive. You only need a parachute to skydive twice.