06_데이터베이스(CRUD)
Create 테이블 생성 create table student( no number(3) primary key, name varchar2(21) not null check(regexp_like(name, '^[가-힣]{2,7}$')); phone char(13) join date ); · not null + unique = primary key · defalut 0 : 미입력시 0 · check(조건) · regexp_like(항목, 정규표현식) check(regexp_like(member_name, '^[가-힣0-9]+$')); · and, or, =, !=, · between a and b · in : check(telecom in ('SK','KT','LG')) · 나머지 mod(항목, 30) 항목의..