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

Locked Post

New comments cannot be posted to this locked post.

Locked on Jun 27 2006

Added on May 29 2006

#general-database-discussions

5 comments

1,290 views