精度和小数位数有什么区别? [英] What is the difference between precision and scale?

问题描述

Oracle中精度和规模之间有什么区别?在教程中，他们通常将标度留空，并在创建主键时将精度设置为6.

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.

精度和刻度代表什么?

推荐答案

精度4，比例2:99.99

Precision 4, scale 2: 99.99

精度10，小数位数为0:9999999999

Precision 10, scale 0: 9999999999

精度8，比例3:99999.999

Precision 8, scale 3: 99999.999

精度5，小数位数-3:99999000

Precision 5, scale -3: 99999000

这篇关于精度和小数位数有什么区别?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！