Skip to Main Content

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!

So I'm guessing I cannot decrease column scale with an alter statement

2776946Jun 10 2015 — edited Jun 10 2015

Just learned this, kind of interesting to me. If the column contains data I can increase the scale but I can't decrease it afterwards to its original scale, even though the numbers would fit. Also from what I've read the only case to decrease a scale is with set to nulls, delete, or maybe copy the column into an appended column.

Just think it's a bit odd you can't decrease a number column even though the values would fit.

Does this have something to do with leading zero's?

This post has been answered by unknown-7404 on Jun 10 2015
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jul 8 2015
Added on Jun 10 2015
9 comments
499 views