mysql 샘플 테이블 + 쿼리 연습 문제

-
http://java-school.net/jdbc/SQL-SELECT-Statement CREATE TABLE DEPT (     DEPTNO DECIMAL ( 2 ),     DNAME VARCHAR ( 14 ),     LOC VARCHAR ( 13 ),     CONSTRAINT PK_DEPT PRIMARY KEY ( DEPTNO ) ); CREATE TABLE EMP (     EMPNO DECIMAL ( 4 ),     ENAME VARCHAR ( 10 ),     JOB VARCHAR ( 9 ),     MGR DECIMAL ( 4 ),     HIREDATE DATE ,     SAL DECIMAL ( 7 , 2 ),     COMM DECIMAL ( 7 , 2 ),     DEPTNO DECIMAL ( 2 ),     CONSTRAINT PK_EMP PRIMARY KEY ( EMPNO ),     CONSTRAINT FK_DEPTNO FOREIGN KEY ( DEPTNO ) REFERENCES DEPT ( DEPTNO ) ); CREATE TABLE SALGRADE (     GRADE TINYINT ,     LOSAL SMALLINT ,     HISAL SMALLINT ); INSE...

MyBatis+Oracle 다중 insert 시퀀스 nextval

-




<update id="addTecOrderAddOptions" parameterType="com.lottemart.api.order.domain.Order">
        <!-- Order.addTecOrderAddOptions -->
        INSERT INTO TEC_ORDER_ADD_OPTION
(
ADD_OPTION_ID,
EC_ORDER_ID,
EC_ORDER_SEQ,
PROCESS_SEQ,
ADD_OPTION_DIVN_CD,
ADD_OPTION_NM,
ADD_OPTION_VALUE
)
SELECT LPAD(SQ_EC_ORDER_OPTION_SEQ.NEXTVAL, 15, '0')
, A.*
  FROM (
  <foreach collection="orderAddOptionList" item="orderAddOption"  separator="UNION ALL "  >
  SELECT
#{orderAddOption.ecOrderId, jdbcType=VARCHAR} AS EC_ORDER_ID,
#{orderAddOption.ecOrderSeq} AS EC_ORDER_SEQ,
#{orderAddOption.processSeq} AS PROCESS_SEQ,
#{orderAddOption.addOptionDivnCd, jdbcType=VARCHAR} AS ADD_OPTION_DIVN_CD,
#{orderAddOption.addOptionNm, jdbcType=VARCHAR} AS ADD_OPTION_NM,
#{orderAddOption.addOptionValue, jdbcType=VARCHAR} AS ADD_OPTION_VALUE
FROM DUAL
</foreach>)A
    </update>