Skip to content

Instantly share code, notes, and snippets.

@kimki1124

kimki1124/oracle_08.sql

Created March 7, 2017 12:49
Show Gist options
  • Save kimki1124/b99ff242be32b5ecd224e4b76ac255b5 to your computer and use it in GitHub Desktop.
Save kimki1124/b99ff242be32b5ecd224e4b76ac255b5 to your computer and use it in GitHub Desktop.
Download ZIP
[ORACLE] 테이블, 테이블 생성, 데이터 타입, 제약조건
Raw
oracle_08.sql
CREATE TABLE EX2_9(
NUM1 NUMBER CONSTRAINTS CHECK1 CHECK (NUM1 BETWEEN 1 AND 9),
GENDER VARCHAR2(10) CONSTRAINTS CHECK2 CHECK (GENDER IN ('MALE', 'FEMALE'))
);
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment