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