In Oracle, when order by descending is used, null values are returned to the top.  To work around this, you just use NULLS LAST in your ORDER BY statement inside of your stored procedure.

Example:

SELECT name FROM customer ORDER BY name DESC NULLS LAST;

where “name” is a column in the “customer” table and ”DESC” is used to set a descending order

This entry was posted on Friday, June 15th, 2007 at 5:00 pm and is filed under Programming. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.