What is the difference between precision and scale?

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