geeky

Oracle number data type

I don’t know why I’m always confused. I need to write this down so the next time I wouldn’t be.

You may optionally specify the precision/length and scale of the number data type in Oracle i.e. number(9,2).

I remembered it as “leading” & “trailing” (the decimal point) which is INCORRECT.

As discussed here:

column_name NUMBER (precision, scale)

Precision = total number of digits and scale = number of digits to the right of the decimal point.

One thought on “Oracle number data type

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s