Oracle 기본02
◆ MEMBER 테이블 생성 CREATE TABLE MEMBER ( ID VARCHAR2(20), PASS VARCHAR2(20), NAME VARCHAR2(10), GENDER VARCHAR2(6), AGE NUMBER, BIRTHDAY VARCHAR2(10), PHONE VARCHAR2(13), SIGNDATE DATE ); ㄴ▣ MEMBER 테이블 구조 변경 CREATE TABLE member ( id VARCHAR2(20), PASS VARCHAR2(20), NAME VARCHAR2(10), -- NVARCHAR2(10) -- GENDER VARCHAR2(6), -- NCHAR(1) F:여성 , M:남성 -- AGE NUMBER, -- 삭제 -- BIRTHDAY VARCHAR2(10), PHONE..
2023. 6. 8.