Re: Question about alter table

ALTER TABLE table_name MODIFY column_name new_attributes;

so yours would look something like this:

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

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 ?
Received on Tue Nov 27 2001 - 19:02:20 CST