We have created a awesome themeFar far away,behind the word mountains, far from the countries
INFO ½ÇÀü DB¸ðµ¨¸µ°ú SQL°úÁ¤
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 USERSPCTFREE 10PCTUSED 0INITRANS 1MAXTRANS 255STORAGE ( INITIAL 64 K NEXT 1024 K MINEXTENTS 1 MAXEXTENTS UNLIMITED)LOGGINGNOCACHEMONITORINGNOPARALLEL;
¡á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 USERSPCTFREE 10PCTUSED 0INITRANS 1MAXTRANS 255STORAGE ( INITIAL 64 K NEXT 1024 K MINEXTENTS 1 MAXEXTENTS UNLIMITED)LOGGINGNOCACHEMONITORINGNOPARALLEL;
¡á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# );