12 June 2005

Let the Mortal Kombat ... BEGIN

Finally re-opened the Sybex 9i SQL Guide and kicked off the official studying effort, taking notes as I went through Chapter 1. Although Chapter 1 was pretty basic stuff, there were some things I never knew or noticed before, like the fact that you can use column aliases in the ORDER BY clause. I could probably never get too much review of NUMBER precision/scale scenarios.

HA! Just looked back at my notes and already I miffed the scale-greater-than-precision scenario. NUMBER(3,5) can store from -0.00999 to 0.00999. It requires two zeros (scale - precision) after the decimal and rounds the decimal part to three digits (precision) after the zeros.

There. Now I will NEVAR FURGET.

No comments:

Post a Comment