How to change datatype of the column in derby database?

Question

Iam trying to change the datatype of the column from integer(9) to Numeric(14,3). but not able to change

i tried below query

alter table TableName alter ColumnName NUMERIC (14,3);

Answer 1

hope below one will help.

ALTER TABLE Table_Name ALTER COLUMN Column_Name SET DATA TYPE NUMERIC(14,3);