oracle update table datatype

alter table SALARYEXCEL modify (RATE NUMBER(9,2));

oracle create table

create table salaryExcel
(
    sal_id    NUMBER not null,
    start_date      DATE not null,
    end_date      DATE not null,
    ser_no   NUMBER not null,
    days   NUMBER not null,
    hours   NUMBER not null,
    additional_hours  NUMBER not null,
    rate   NUMBER not null,
    money_earned   NUMBER(9,2),
    paid_in_payroll  NUMBER(9,2),
    insurance  NUMBER(9,2),
    money_deducted  NUMBER(9,2),
    money_owed_to_us  NUMBER(9,2),
    already_paid NUMBER(1) not null check (already_paid in (0,1)),
    true_money_owed_to_us  NUMBER(9,2)
    );


create table moneyHeld(
  held_id NUMBER not null,
  amount_held NUMBER(9,2) not null,
  year_current NUMBER not null
);