ALTER TYPE 변경

 

CREATE TABLE information (
    name  VARCHAR2(15),
    hobby VARCHAR2(15),
    age   NUMBER (8),
    job   VARCHAR2(15)
);

SELECT * FROM information;

ALTER TABLE information MODIFY age VARCHAR2(15);

DESC information;

SQL에서 Table을 생성 했는데

type을 바꿔주고 싶을 때!