Change data type

Question

I created my table Course_Section with CsectionID number(6) PRIMARY KEY. I would like to change number(6) by number(2,2) but can't figure it out.

I tried:

Alter table Course_section
Alter column CSectionID Number(2,2) PRIMARY KEY;

and get an error.

How can I resolve the problem?

Answer 1

Your syntax is a little off. It should be:

ALTER TABLE Course_section
MODIFY CSectionID Number(2, 2);