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!

Precision

palkodiMay 11 2018 — edited May 11 2018

I am trying to learn more about precision can some one explain me in a plain english ...

I am table column with number(22) and another table with column with number(15,2)

if I reduce column data type from number(22) to number(15,2)

I have alter table schema.column add (new_table number(15,2))

update schema.column set new_table = table

alter table schema.column drop column table

alter table schema.column renameĀ  new_table to table;

will this make any difference from number(22) to number(15,2)

This post has been answered by mathguy on May 11 2018
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jun 8 2018
Added on May 11 2018
11 comments
508 views