Skip to Main Content

Oracle Database Discussions

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!

Modify a column without truncating the table

515449May 29 2006 — edited May 30 2006
HI! All

I need to modify a column Discount Decimal(7,2) to decimal(7,4) ,the column has a data i dont want to truncate the table .when i try to run this script

Alter table <Table Name > modify column Discount(7,4)

iam getting a error stating ,"Empty the column before altering"

can any one help me
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jun 27 2006
Added on May 29 2006
5 comments
1,290 views