๋กœ์ผ“๐Ÿพ
article thumbnail
[MyBatis] mybatis์—์„œ ๋‹ค์Œ ์‹œํ€€์Šค ๋ฐ์ดํ„ฐ ๊ฐ€์ ธ์˜ค๊ธฐ
... 2020. 12. 29. 16:39

SELECT SBJECT_MASTR_SEQ.NEXTVAL FROM DUAL INSERT INTO SBJECT_MASTR (SBJECT_MASTR_SN, SBJECT_NM, SBJECT_CODE, SBJECT_CTGRY, EDC_TRGET, SRCHWRD, USE_YN, CM, REGIST_DT, REGIST_MBER_SEQ) VALUES (#{sn}, #{sbject_nm}, 'ES'||LPAD(#{sn}, 6, 0), #{sbject_ctgry}, #{edc_trget}, #{srchwrd}, #{use_yn}, #{cm}, SYSDATE, #{mber_seq}) ์˜ค๋ผํด ๊ธฐ์ค€์˜ ๊ธ€์ž…๋‹ˆ๋‹ค. ํƒœ๊ทธ๋ฅผ ์ด์šฉํ•˜์—ฌ ํ˜„์žฌ ์‹œํ€€์Šค ๋‹ค์Œ์˜ ์‹œํ€€์Šค๋ฅผ ๊ฐ€์ ธ์˜ฌ์ˆ˜ ์žˆ์Šต๋‹ˆ๋‹ค. ใ…ฃSELECT SBJECT_MASTR_SEQ.NEX..

profile on loading

Loading...