[{"no":"1225","minus":"-1711635137","minus_like_count":"0","parent_post_comment_no":"0","post_no":"5988","board_id":"database","type":"editor","is_post_reply":"Y","user_no":"780","user_nickname":"\uc708\ube44","user_thumb_url":"https:\/\/devsnote.com\/assets\/data\/profile\/780_4802b2b6f82b1e402769dd7b879dbcf2.jpg?u=1683208087","user_description":"","title":"","comment":"[{\"id\":\"oGa7uDdPm4\",\"type\":\"paragraph\",\"data\":{\"text\":\"Oracle\uc5d0\uc11c MyBatis\ub97c \uc0ac\uc6a9\ud558\uc5ec \ud2b9\uc815 \uc870\uac74\uc5d0 \ub530\ub77c \ucc44\ubc88(\uc2dc\ud000\uc2a4 \uc0dd\uc131) \ub85c\uc9c1\uc744 \uad6c\ud604\ud558\uace0 \uc2f6\uc73c\uc2e0 \uac83\uc73c\ub85c \uc774\ud574\ud588\uc2b5\ub2c8\ub2e4. \"}},{\"id\":\"6-z_ioypdY\",\"type\":\"paragraph\",\"data\":{\"text\":\"\uc8fc\uc5b4\uc9c4 \uc870\uac74\uc740 Name1 \uceec\ub7fc\uc758 \uac12\uc774 \uc911\ubcf5\ub418\ub294\uc9c0 \uc5ec\ubd80\uc5d0 \ub530\ub77c Pk1\uc758 \uac12\uc774 \ubcc0\uacbd\ub418\uac70\ub098 \uc720\uc9c0\ub418\uc5b4\uc57c \ud55c\ub2e4\ub294 \uac83\uc785\ub2c8\ub2e4. \"}},{\"id\":\"ghx2vEae2x\",\"type\":\"paragraph\",\"data\":{\"text\":\"\uc989, Name1 \uac12\uc774 \uae30\uc874\uc5d0 \ub370\uc774\ud130\ubca0\uc774\uc2a4\uc5d0 \uc874\uc7ac\ud55c\ub2e4\uba74 Pk1\uc740 \ub3d9\uc77c\ud55c \uac12\uc744 \uc720\uc9c0\ud558\uace0, \uc0c8\ub85c\uc6b4 Name1 \uac12\uc774\uba74 Pk1\uc744 \uc0c8\ub85c \ucc44\ubc88\ud574\uc57c \ud569\ub2c8\ub2e4.\"}},{\"id\":\"gFqjKyBA0b\",\"type\":\"paragraph\",\"data\":{\"text\":\"\uc774\ub97c \uad6c\ud604\ud558\uae30 \uc704\ud574 \uba87 \uac00\uc9c0 \uc811\uadfc \ubc29\ubc95\uc774 \uc788\uc744 \uc218 \uc788\uc73c\uba70, \uc544\ub798\ub294 \uac00\ub2a5\ud55c \uad6c\ud604 \ubc29\ubc95 \uc911 \ud558\ub098\ub97c \uc81c\uc2dc\ud55c \uac83\uc785\ub2c8\ub2e4.\"}},{\"id\":\"6CkF_Udlfc\",\"type\":\"header\",\"data\":{\"text\":\"1\ub2e8\uacc4: \uc2dc\ud000\uc2a4 \uc0dd\uc131\",\"level\":3}},{\"id\":\"LxlnG7i_nr\",\"type\":\"paragraph\",\"data\":{\"text\":\"\uba3c\uc800, \uc0c8\ub85c\uc6b4 Pk1 \uac12\uc744 \uc0dd\uc131\ud558\uae30 \uc704\ud55c Oracle \uc2dc\ud000\uc2a4\ub97c \uc0dd\uc131\ud569\ub2c8\ub2e4. \"}},{\"id\":\"AzbKLcfOF2\",\"type\":\"paragraph\",\"data\":{\"text\":\"\uc774 \uc2dc\ud000\uc2a4\ub294 \uc0c8\ub85c\uc6b4 Pk1 \uac12\uc744 \uc790\ub3d9\uc73c\ub85c \uc0dd\uc131\ud560 \ub54c \uc0ac\uc6a9\ub429\ub2c8\ub2e4.\"}},{\"id\":\"z2_s9GyHWv\",\"type\":\"code\",\"data\":{\"language\":\"sql\",\"code\":\"CREATE SEQUENCE pk1_seq\\nSTART WITH 1\\nINCREMENT BY 1\\nNOCACHE;\\n\",\"caption\":\"\"}},{\"id\":\"6Qx5S0R3nn\",\"type\":\"header\",\"data\":{\"text\":\"2\ub2e8\uacc4: MyBatis \ucffc\ub9ac \uc791\uc131\",\"level\":3}},{\"id\":\"yW1Qm2YQur\",\"type\":\"paragraph\",\"data\":{\"text\":\"MyBatis \ub9e4\ud37c XML \ud30c\uc77c\uc5d0 \uc0c8\ub85c\uc6b4 \ub370\uc774\ud130\ub97c \uc0bd\uc785\ud558\ub294 \ucffc\ub9ac\ub97c \uc791\uc131\ud569\ub2c8\ub2e4. \"}},{\"id\":\"Pgc3NFeNeA\",\"type\":\"paragraph\",\"data\":{\"text\":\"\uc774 \ucffc\ub9ac\ub294 \uba3c\uc800 Name1 \uac12\uc774 \ub370\uc774\ud130\ubca0\uc774\uc2a4\uc5d0 \uc874\uc7ac\ud558\ub294\uc9c0 \ud655\uc778\ud558\uace0, \uc874\uc7ac\ud558\ub294 \uacbd\uc6b0 \ud574\ub2f9 Name1\uc5d0 \ub300\ud55c \ud604\uc7ac Pk1 \uac12\uc744 \uc0ac\uc6a9\ud558\uba70, \uc874\uc7ac\ud558\uc9c0 \uc54a\ub294 \uacbd\uc6b0 \uc0c8\ub85c\uc6b4 Pk1 \uac12\uc744 \uc2dc\ud000\uc2a4\uc5d0\uc11c \uc0dd\uc131\ud558\uc5ec \uc0ac\uc6a9\ud569\ub2c8\ub2e4.\"}},{\"id\":\"FTYvb2gzHH\",\"type\":\"code\",\"data\":{\"language\":\"sql\",\"code\":\"\\n \\n \\n SELECT CASE\\n WHEN EXISTS(SELECT 1 FROM your_table WHERE name1 = #{name1})\\n THEN (SELECT pk1 FROM your_table WHERE name1 = #{name1} FETCH FIRST 1 ROWS ONLY)\\n ELSE '2023' || LPAD(pk1_seq.NEXTVAL, 7, '0')\\n END AS pk1\\n FROM dual\\n <\/selectKey>\\n INSERT INTO your_table (pk1, pk2, name1)\\n VALUES (#{pk1}, #{pk2}, #{name1})\\n<\/insert>\\n\",\"caption\":\"\"}},{\"id\":\"zzWDd6bBPu\",\"type\":\"paragraph\",\"data\":{\"text\":\"\uc774 \uc608\uc81c\uc5d0\uc11c\ub294 \uba3c\uc800 SELECT \ubb38\uc744 \uc0ac\uc6a9\ud558\uc5ec Name1\uc774 \uae30\uc874\uc5d0 \uc874\uc7ac\ud558\ub294\uc9c0 \ud655\uc778\ud569\ub2c8\ub2e4. \"}},{\"id\":\"S3DSjns5vo\",\"type\":\"paragraph\",\"data\":{\"text\":\"\uc874\uc7ac\ud55c\ub2e4\uba74 \ud574\ub2f9 Name1\uc5d0 \ub300\ud55c \ud604\uc7ac Pk1 \uac12\uc744 \uc120\ud0dd\ud558\uace0, \uadf8\ub807\uc9c0 \uc54a\uc73c\uba74 \uc2dc\ud000\uc2a4\ub97c \uc0ac\uc6a9\ud558\uc5ec \uc0c8\ub85c\uc6b4 Pk1 \uac12\uc744 \uc0dd\uc131\ud569\ub2c8\ub2e4. \"}},{\"id\":\"aJXF_8sHhK\",\"type\":\"paragraph\",\"data\":{\"text\":\"LPAD \ud568\uc218\ub97c \uc0ac\uc6a9\ud558\uc5ec \ucc44\ubc88\ub41c \uc22b\uc790 \uc55e\uc5d0 0\uc744 \ucc44\uc6b0\uace0, '2023' \uac19\uc740 \uc5f0\ub3c4 \ub610\ub294 \ud544\uc694\ud55c \uc811\ub450\uc0ac\ub97c \ucd94\uac00\ud569\ub2c8\ub2e4.\"}}]","rating":"0.0","like_count":"0","mentioned_user_nos":"[]","is_secret":"N","is_deleted":"N","deleted":"","created":"2024-03-28 23:12:17","comment_html":"

Oracle\uc5d0\uc11c MyBatis\ub97c \uc0ac\uc6a9\ud558\uc5ec \ud2b9\uc815 \uc870\uac74\uc5d0 \ub530\ub77c \ucc44\ubc88(\uc2dc\ud000\uc2a4 \uc0dd\uc131) \ub85c\uc9c1\uc744 \uad6c\ud604\ud558\uace0 \uc2f6\uc73c\uc2e0 \uac83\uc73c\ub85c \uc774\ud574\ud588\uc2b5\ub2c8\ub2e4. <\/p>

\uc8fc\uc5b4\uc9c4 \uc870\uac74\uc740 Name1 \uceec\ub7fc\uc758 \uac12\uc774 \uc911\ubcf5\ub418\ub294\uc9c0 \uc5ec\ubd80\uc5d0 \ub530\ub77c Pk1\uc758 \uac12\uc774 \ubcc0\uacbd\ub418\uac70\ub098 \uc720\uc9c0\ub418\uc5b4\uc57c \ud55c\ub2e4\ub294 \uac83\uc785\ub2c8\ub2e4. <\/p>

\uc989, Name1 \uac12\uc774 \uae30\uc874\uc5d0 \ub370\uc774\ud130\ubca0\uc774\uc2a4\uc5d0 \uc874\uc7ac\ud55c\ub2e4\uba74 Pk1\uc740 \ub3d9\uc77c\ud55c \uac12\uc744 \uc720\uc9c0\ud558\uace0, \uc0c8\ub85c\uc6b4 Name1 \uac12\uc774\uba74 Pk1\uc744 \uc0c8\ub85c \ucc44\ubc88\ud574\uc57c \ud569\ub2c8\ub2e4.<\/p>

\uc774\ub97c \uad6c\ud604\ud558\uae30 \uc704\ud574 \uba87 \uac00\uc9c0 \uc811\uadfc \ubc29\ubc95\uc774 \uc788\uc744 \uc218 \uc788\uc73c\uba70, \uc544\ub798\ub294 \uac00\ub2a5\ud55c \uad6c\ud604 \ubc29\ubc95 \uc911 \ud558\ub098\ub97c \uc81c\uc2dc\ud55c \uac83\uc785\ub2c8\ub2e4.<\/p>

1\ub2e8\uacc4: \uc2dc\ud000\uc2a4 \uc0dd\uc131<\/h3>

\uba3c\uc800, \uc0c8\ub85c\uc6b4 Pk1 \uac12\uc744 \uc0dd\uc131\ud558\uae30 \uc704\ud55c Oracle \uc2dc\ud000\uc2a4\ub97c \uc0dd\uc131\ud569\ub2c8\ub2e4. <\/p>

\uc774 \uc2dc\ud000\uc2a4\ub294 \uc0c8\ub85c\uc6b4 Pk1 \uac12\uc744 \uc790\ub3d9\uc73c\ub85c \uc0dd\uc131\ud560 \ub54c \uc0ac\uc6a9\ub429\ub2c8\ub2e4.<\/p>

CREATE<\/span> SEQUENCE<\/span> pk1_seq\nSTART<\/span> WITH<\/span> 1<\/span>\nINCREMENT<\/span> BY<\/span> 1<\/span>\nNOCACHE;\n<\/code><\/pre><\/div> 2\ub2e8\uacc4: MyBatis \ucffc\ub9ac \uc791\uc131<\/h3> MyBatis \ub9e4\ud37c XML \ud30c\uc77c\uc5d0 \uc0c8\ub85c\uc6b4 \ub370\uc774\ud130\ub97c \uc0bd\uc785\ud558\ub294 \ucffc\ub9ac\ub97c \uc791\uc131\ud569\ub2c8\ub2e4. <\/p> 
\uc774 \ucffc\ub9ac\ub294 \uba3c\uc800 Name1 \uac12\uc774 \ub370\uc774\ud130\ubca0\uc774\uc2a4\uc5d0 \uc874\uc7ac\ud558\ub294\uc9c0 \ud655\uc778\ud558\uace0, \uc874\uc7ac\ud558\ub294 \uacbd\uc6b0 \ud574\ub2f9 Name1\uc5d0 \ub300\ud55c \ud604\uc7ac Pk1 \uac12\uc744 \uc0ac\uc6a9\ud558\uba70, \uc874\uc7ac\ud558\uc9c0 \uc54a\ub294 \uacbd\uc6b0 \uc0c8\ub85c\uc6b4 Pk1 \uac12\uc744 \uc2dc\ud000\uc2a4\uc5d0\uc11c \uc0dd\uc131\ud558\uc5ec \uc0ac\uc6a9\ud569\ub2c8\ub2e4.<\/p> 
<insert<\/span> id<\/span>=\"insertWithConditionalPk\"<\/span> parameterType=\"map\"<\/span>>\n    <!-- \ubcc0\uc218 \uc120\uc5b8 --><\/span>\n    <selectKey keyProperty=\"pk1\"<\/span> resultType=\"string\"<\/span> order<\/span>=\"BEFORE\"<\/span>>\n        SELECT<\/span> CASE<\/span>\n                 WHEN<\/span> EXISTS<\/span>(SELECT<\/span> 1<\/span> FROM<\/span> your_table WHERE<\/span> name1 = #{name1})<\/span>\n                 THEN<\/span> (SELECT<\/span> pk1 FROM<\/span> your_table WHERE<\/span> name1 = #{name1} FETCH FIRST 1 ROWS ONLY)<\/span>\n                 ELSE<\/span> '2023'<\/span> || LPAD<\/span>(pk1_seq.NEXTVAL, 7<\/span>, '0'<\/span>)\n               END<\/span> AS<\/span> pk1\n        FROM<\/span> dual\n    <\/selectKey>\n    INSERT<\/span> INTO<\/span> your_table (pk1, pk2, name1)\n    VALUES<\/span> (#{pk1}, #{pk2}, #{name1})<\/span>\n<\/insert<\/span>>\n<\/code><\/pre><\/div> \uc774 \uc608\uc81c\uc5d0\uc11c\ub294 \uba3c\uc800 SELECT \ubb38\uc744 \uc0ac\uc6a9\ud558\uc5ec Name1\uc774 \uae30\uc874\uc5d0 \uc874\uc7ac\ud558\ub294\uc9c0 \ud655\uc778\ud569\ub2c8\ub2e4. <\/p> 
\uc874\uc7ac\ud55c\ub2e4\uba74 \ud574\ub2f9 Name1\uc5d0 \ub300\ud55c \ud604\uc7ac Pk1 \uac12\uc744 \uc120\ud0dd\ud558\uace0, \uadf8\ub807\uc9c0 \uc54a\uc73c\uba74 \uc2dc\ud000\uc2a4\ub97c \uc0ac\uc6a9\ud558\uc5ec \uc0c8\ub85c\uc6b4 Pk1 \uac12\uc744 \uc0dd\uc131\ud569\ub2c8\ub2e4. <\/p> 
LPAD \ud568\uc218\ub97c \uc0ac\uc6a9\ud558\uc5ec \ucc44\ubc88\ub41c \uc22b\uc790 \uc55e\uc5d0 0\uc744 \ucc44\uc6b0\uace0, '2023' \uac19\uc740 \uc5f0\ub3c4 \ub610\ub294 \ud544\uc694\ud55c \uc811\ub450\uc0ac\ub97c \ucd94\uac00\ud569\ub2c8\ub2e4.<\/p> ","summary":"Oracle\uc5d0\uc11c MyBatis\ub97c \uc0ac\uc6a9\ud558\uc5ec \ud2b9\uc815 \uc870\uac74\uc5d0 \ub530\ub77c \ucc44\ubc88(\uc2dc\ud000\uc2a4 \uc0dd\uc131) \ub85c\uc9c1\uc744 \uad6c\ud604\ud558\uace0 \uc2f6\uc73c\uc2e0 \uac83\uc73c\ub85c \uc774\ud574\ud588\uc2b5\ub2c8\ub2e4.  \uc8fc\uc5b4\uc9c4 \uc870\uac74\uc740 Name1 \uceec\ub7fc\uc758 \uac12\uc774 \uc911\ubcf5\ub418\ub294\uc9c0 \uc5ec\ubd80\uc5d0 \ub530\ub77c Pk1\uc758 \uac12\uc774 \ubcc0\uacbd\ub418\uac70\ub098 \uc720\uc9c0\ub418\uc5b4\uc57c \ud55c\ub2e4\ub294 \uac83\uc785\ub2c8\ub2e4.  \uc989, Name1 \uac12\uc774 \uae30\uc874\uc5d0 \ub370\uc774\ud130\ubca0\uc774\uc2a4\uc5d0 \uc874\uc7ac\ud55c\ub2e4\uba74 Pk1\uc740 \ub3d9\uc77c\ud55c \uac12\uc744 \uc720\uc9c0\ud558\uace0, \uc0c8\ub85c\uc6b4 Name1 \uac12\uc774\uba74 Pk1..."}]

#Sql

질문sql 채번에 대해서 질문이있습니다