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: Logo

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

Facebook photo

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

Connecting to %s