■예 3_1_1  ||  테이블 생성 예
____CREATE TABLE____ CHAPTER_1
(
  SABUN VARCHAR2(10)        NOT NULL,
  NAME VARCHAR2(50)        NOT NULL,
  AGE VARCHAR2(3),
  PHONE VARCHAR2(11),
  CONSTRAINT CHAPTER_1_PK PRIMARY KEY(SABUN)
)
TABLESPACE SYSTEM
PCTFREE 10
PCTUSED 40
INITRANS 1
MAXTRANS 255
STORAGE (
    INITIAL 64 K
    NEXT 1024 K
    MINEXTENTS 1
    MAXEXTENTS UNLIMITED
    FREELISTS 1
    FREELIST GROUPS 1
);

■예 3_1_2  ||  테이블 생성 예
ALTER TABLE CHAPTER_1 ADD(JOIN_DAY VARCHAR2(8)); --컬럼 추가
ALTER TABLE CHAPTER_1 COLUMN RENAME PHONE TO HP; --컬럼명 수정
ALTER TABLE CHAPTER_1 MODIFY(AGE NUMBER(3));  --컬럼 DATATYPE 변경

■예 3_1_3  ||  PRIMARY KEY 제약조건 지정
____CREATE TABLE____ CHAPTER_1(
  SABUN  VARCHAR2(10) CONSTRAINT CHAPTER_1_PK_SABUN PRIMARY KEY
);

■예 3_1_4  ||  NOT NULL 제약조건 지정
____CREATE TABLE____ CHAPTER_1(
  SABUN  VARCHAR2(10) CONSTRAINT CHAPTER_1_PK_SABUN PRIMARY KEY
  NAME   VARCHAR2(20) CONSTRAINT CHAPTER_1_nn_NAME NOT NULL
);

■예 3_1_5  ||  NOT NULL 제약조건 지정
____CREATE TABLE____ CHAPTER_1(
  SABUN  VARCHAR2(10) CONSTRAINT CHAPTER_1_PK_SABUN PRIMARY KEY
  NAME   VARCHAR2(20) CONSTRAINT CHAPTER_1_nn_NAME NOT NULL
  PHONE  VARCHAR2(11) CONSTRAINT CHAPTER_1_FK_PHONE
  FOREIGN KEY (PHONE) REFERENCES CHAPTER_2(PHONE)            
);

■예 3_1_6  ||  DEFAULT 제약조건 지정
____CREATE TABLE____ CHAPTER_1(
  SABUN  VARCHAR2(10) CONSTRAINT CHAPTER_1_PK_SABUN PRIMARY KEY
  NAME   VARCHAR2(20) CONSTRAINT CHAPTER_1_nn_NAME NOT NULL
  PHONE  VARCHAR2(11) CONSTRAINT CHAPTER_1_FK_PHONE
  FOREIGN KEY (PHONE) REFERENCES CHAPTER_2(PHONE)
  PUT_START_DAY  DATE  DEFAULT  SYSDATE                      
);

■SQL 3_1_1 테이블 제약 조건 확인
SELECT A.TABLE_NAME, B.COLUMN_NAME, A.CONSTRAINT_NAME, A.CONSTRAINT_TYPE, A.SEARCH_CONDITION
FROM USER_CONSTRAINTS A, USER_CONS_COLUMNS B
WHERE A.CONSTRAINT_NAME = B.CONSTRAINT_NAME
AND A.TABLE_NAME = 'INSA'
AND A.CONSTRAINT_TYPE = 'P';

■예 3_1_7  ||  제약조건 추가
ALTER TABLE  INSA
ADD CONSTRAINT  INSA_MOBILE_UK  UNIQUE (MOBILE);

■예 3_1_8  ||  제약조건 삭제
ALTER TABLE  INSA
DROP CONSTRAINT  INSA_MOBILE_UK;