Re: Question about alter table

Saira Somani <saira_somani_at_yahoo.com> wrote:
> ALTER TABLE table_name MODIFY column_name new_attributes;

> so yours would look something like this:

> ALTER TABLE tableA MODIFY (column1 number (10, 10));

When I try to use
ALTER TABLE tableName MODIFY cost number(10, 10); the following error occurs:

ORA-01440: column to be modified must be empty to decrease precision or scale

How can I solve this problem?

> Cheers,
> Saira
> mailto:saira_somani_at_yahoo.com

> "Hello_World" <nix1_at_cuse15.se.cuhk.edu.hk> wrote in message
> news:9u0t3i$pea$1_at_eng-ser1.erg.cuhk.edu.hk...

>> If I want to cahnge number(7,6) to number(10, 10)
>> what is the SQL command?
>>
>> alter tableName XXXXXXXXX
>> what is XXXXXXXX ?