What is the difference between precision and scale?

oracle types
user700792 picture user700792 · Apr 16, 2011 · Viewed 201.1k times · Source

What is the difference between precision and scale in Oracle? In tutorials they usually leave scale empty and set precision to 6 when creating a primary key.

What do precision and scale stand for?

Answer

koljaTM picture koljaTM · Oct 25, 2012

Precision 4, scale 2: 99.99

Precision 10, scale 0: 9999999999

Precision 8, scale 3: 99999.999

Precision 5, scale -3: 99999000

Related questions

C#: Oracle Data Type Equivalence with OracleDbType

Situation: I am creating an app in C# that uses Oracle.DataAccess.Client (11g) to do certain operations on a Oracle database with stored procedures. I am aware that there is a certain enum (OracleDbType) that contains the Oracle data …

Read More
How to store unlimited characters in Oracle 11g?

We have a table in Oracle 11g with a varchar2 column. We use a proprietary programming language where this column is defined as string. Maximum we can store 2000 characters (4000 bytes) in this column. Now the requirement is such that the …

Read More
Is "NUMBER" and "NUMBER(*,0)" the same in Oracle?

In Oracle documentation it is mentioned that NUMBER (precision, scale) If a precision is not specified, the column stores values as given. If no scale is specified, the scale is zero. But NUMBER (without precision and scale) is also accepting …

Read More