테이블 정의서에 따른 스키마 만들기
CREATE TABLE member( id varchar2(20) primary key, pw varchar2(20) NOT NULL, name varchar2(30) NOT NULL, gender varchar2(6) NOT NULL check(gender in('남자','여자')), birth date NOT NULL, tel varchar2(13), email varchar2(50) NOT NULL, regDate date default SYSDATE, conDate date default SYSDATE, status varchar2(6) defalut '정상' check(status in('정상','강퇴','탈퇴','휴면')), photo varchar2(100), gradeNo number(2)..
2021. 12. 31.