INSERT INTO INSA_ACAD_ABILITY
 (      
  SABUN ,SEQ  ,MAJOR_STUDY_GBN ,GRAT_YN
  ,GRAT_YEAR  ,GRAT_MONTH  ,SCHOOL_NAME
 )
 VALUES
 (
  #sabun,jdbcType=VARCHAR#
  ,(SELECT NVL(MAX(SEQ),0)+1 AS SEQ
   FROM INSA_ACAD_ABILITY
   WHERE SABUN = #sabun,jdbcType=VARCHAR#)
  ,#majorStudyGbn,jdbcType=VARCHAR#
  ,#gratYn,jdbcType=VARCHAR#
  ,#gratYear,jdbcType=VARCHAR#
  ,#gratMonth,jdbcType=VARCHAR#
  ,#schoolName,jdbcType=VARCHAR#
 );">

■예 3_1_9  ||  INSA TABLE 생성 예
____CREATE TABLE____ INSA (
   SABUN  VARCHAR2(10),
   JOIN_DAY  VARCHAR2(8),
   RETIRE_DAY  VARCHAR2(8),
   PUT_YN  VARCHAR2(1),
   CLASS_GBN_CODE VARCHAR2(3),
   NAME   VARCHAR2(100),
   REG_NO   VARCHAR2(13),
   ENG_NAME  VARCHAR2(100),
   PHONE  VARCHAR2(25),
   HP   VARCHAR2(25),
   CARRIER   VARCHAR2(500),
   POS_GBN_CODE VARCHAR2(5),
   CMP_REG_NO VARCHAR2(10),
   SEX    VARCHAR2(10),
   YEARS  NUMBER,
   EMAIL  VARCHAR2(100),
   ZIP   VARCHAR2(6),
   ADDR1  VARCHAR2(250),
   ADDR2  VARCHAR2(250),
   MIL_YN  VARCHAR2(10),
   HOME_PHONE VARCHAR2(25),
   JOIN_GBN_CODE  VARCHAR2(3),
   SALARY NUMBER DEFAULT 0,
   KOSA_REG_YN VARCHAR2(1),
   KOSA_CLASS  VARCHAR2(3),
   PW   VARCHAR2(15),
   CONSTRAINT "INSA_PK_SABUN" PRIMARY KEY(SABUN)      
)
TABLESPACE USERS
PCTFREE 10
PCTUSED 0
INITRANS 1
MAXTRANS 255
STORAGE (
    INITIAL 64 K
    NEXT 1024 K
    MINEXTENTS 1
    MAXEXTENTS UNLIMITED)
LOGGING
NOCACHE
MONITORING
NOPARALLEL;

■SQL3_1_2) 제약조건 지정 방식
____CREATE TABLE____ INSA (
SABUN VARCHAR2(10) PRIMARY KEY);  --인라인방식

____CREATE TABLE____ INSA(
 SABUN VARCHAR2(10),
CONSTRAINT "INSA_PK_SABUN" PRIMARY KEY(SABUN));  --아웃라인방식

■예 3_1_10  ||  학력 테이블 생성
____CREATE TABLE____ INSA_ACAD_ABILITY (
   SABUN VARCHAR2(10) NOT NULL,
   SEQ   NUMBER NOT NULL,
   MAJOR_STUDY_GBN   VARCHAR2(100),
   GRAT_YN   VARCHAR2(1),
   GRAT_YEAR   VARCHAR2(4),
   GRAT_MONTH VARCHAR2(2),
   SCHOOL_NAME VARCHAR2(50),
   CONSTRAINT "INSA_ACAD_ABILITY _PK_SEQ" PRIMARY KEY(SEQ)
)
TABLESPACE USERS
PCTFREE 10
PCTUSED 0
INITRANS 1
MAXTRANS 255
STORAGE (
    INITIAL 64 K  
NEXT 1024 K  
MINEXTENTS 1  
MAXEXTENTS UNLIMITED)
LOGGING
NOCACHE
MONITORING
NOPARALLEL;

■SQL3_1_3) 테이블에 지정된 제약조건 확인
SELECT COLUMN_NAME,
  DECODE(B.CONSTRAINT_TYPE, 'P','PRIMARY KEY',
     'U','UNIQUE KEY',
     'C','CHECK OR NOT NULL',
     'R','FOREIGN KEY') AS CONSTRAINT_TYPE,   A.CONSTRAINT_NAME,
  B.CONSTRAINT_NAME
 FROM　　USER_CONS_COLUMNS A,　 USER_CONSTRAINTS B　　
 WHERE　 A.TABLE_NAME = UPPER(:NAME)
 AND　 A.TABLE_NAME = B.TABLE_NAME　　
 AND　 A.CONSTRAINT_NAME = B.CONSTRAINT_NAME;
 
 
■예 3_4_15  || 학력 정보 INSERT 및 SEQ 생성
<insert id="createAcadAblility" parameterClass="personAcadAbilityVo">
    INSERT INTO INSA_ACAD_ABILITY
 (      
  SABUN ,SEQ  ,MAJOR_STUDY_GBN ,GRAT_YN
  ,GRAT_YEAR  ,GRAT_MONTH  ,SCHOOL_NAME
 )
 VALUES
 (
  #sabun,jdbcType=VARCHAR#
  ,(SELECT NVL(MAX(SEQ),0)+1 AS SEQ
   FROM INSA_ACAD_ABILITY
   WHERE SABUN = #sabun,jdbcType=VARCHAR#)
  ,#majorStudyGbn,jdbcType=VARCHAR#
  ,#gratYn,jdbcType=VARCHAR#
  ,#gratYear,jdbcType=VARCHAR#
  ,#gratMonth,jdbcType=VARCHAR#
  ,#schoolName,jdbcType=VARCHAR#
 );