Skip to Main Content
Forums

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

NUMBER - precision and scale

Ora-affFeb 17 2014 — edited Feb 18 2014

A number variable field if declared without precision and scale values defaults to 38 and 0. So if I create a table

CREATE TABLE employees

(

salary NUMBER

)      

then internally it is actually salary NUMBER(38,0) right?

Then why a value of 188.56 is not stored as 189 during insert?
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Mar 18 2014
Added on Feb 17 2014
20 comments
15,475 views