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 post is long overdue.  It’s been too long since I have posted last, but I figured this was just the post to break the hiatus.

I want to give a shout out to the Live Writer team at Microsoft for shipping Beta 2. 

You can download the installer for Writer Beta 2 at http://writer.live.com.

JJ, Charles, Spike, Bonnie, Joe, Rebecca, Sophy, Pooja, Ron, & Flora, CONGRATULATIONS!

If you’re reading this, have your own blog that you post to, and don’t use Writer, try it out.  That team knows how to ship kick ass software!