1. 수정

1-1. 자료형 변경

ALTER TABLE MEMBER MODIFY ID NVARCHAR2(20);

1-2. 컬럼삭제

• ALTER TABLE MEMBER DROP COLUMN AGE;

1-3. 컬럼 추가

• ALTER TABLE MEMBER ADD EMAIL VARCHAR2(200);

//CREATE
CREATE TABLE MEMBER
(	ID 			VARCHAR2(50)
,	PWD 		NVARCHAR2(50)
,	NAME 		NVARCHAR2(50)
,	GENDER 		NCHAR(2)
,	AGE 		NUMBER
,	BIRTHDAY 	CHAR(10)
,	PHONE 		CHAR(13)
,	REFDATE 	DATE
);
SELECT * FROM MEMBER;
//ALTER
ALTER TABLE "MEMBER" MODIFY ID NVARCHAR2(10);
ALTER TABLE "MEMBER" DROP COLUMN AGE;
ALTER TABLE "MEMBER" ADD EMAIL VARCHAR2(200);