{"id":132,"date":"2016-03-20T18:06:22","date_gmt":"2016-03-20T09:06:22","guid":{"rendered":"https:\/\/www.itchefblog.com\/?p=132"},"modified":"2018-01-02T10:44:31","modified_gmt":"2018-01-02T01:44:31","slug":"oracle-data-%ec%98%a4%eb%9d%bc%ed%81%b4-%eb%8d%b0%ec%9d%b4%ed%84%b0-%eb%b3%b5%ea%b5%ac-%ec%9d%bc%ec%a0%95-%ec%8b%9c%ea%b0%84-%ec%9d%b4%eb%82%b4","status":"publish","type":"post","link":"https:\/\/www.itchefblog.com\/?p=132","title":{"rendered":"ORACLE DATA \uc624\ub77c\ud074 \ub370\uc774\ud130 \ubcf5\uad6c (\uc77c\uc815 \uc2dc\uac04 \uc774\ub0b4)"},"content":{"rendered":"<p class=\"p1\"><span class=\"s1\">DB<\/span>\ub97c \uc0ac\uc6a9\ud558\ub2e4 \ubcf4\uba74 \uc815\ub9d0 \ub09c\ucc98\ud55c \uc0c1\ud669\uc5d0 \uc9c1\uba74\ud560 \ub54c\uac00 \uc788\ub2e4<span class=\"s1\">..<br \/>\n<\/span>\uc608\ub97c \ub4e4\uc5b4\uc11c<span class=\"s1\">\u00a0\u00a0<\/span>\uc911\uc694\ud55c \ud68c\uc6d0 \ub370\uc774\ud130 \ud14c\uc774\ube14\uc744 \ud578\ub4e4\ub9c1 \ud558\ub2e4\uac00 \uc815\uc2e0\uc774 \uc5c6\uc5b4\uc11c<span class=\"s1\"><br \/>\nWHERE\u00a0<\/span>\ubb38\uc744 \uc78a\uc5c8\ub2e4<span class=\"s1\">&#8230;?\u00a0<\/span>\uc624\ub9c8\uac13<span class=\"s1\">..\u00a0<\/span>\ub300\ud615 \uc0ac\uace0\ub2e4<span class=\"s1\">&#8230;<\/span><\/p>\n<p>\uc774\ubc88 \ud3ec\uc2a4\ud305\uc5d0\uc11c\ub294<span class=\"s1\">\u00a0ORACLE<\/span>\uc5d0\uc11c \uc2e4\uc218\ub85c \ub0a0\ub824\ubc84\ub9b0<span class=\"s1\">! (<\/span>\ud639\uc740 \uc218\uc815\ud574\ubc84\ub9b0<span class=\"s1\">)\u00a0<\/span>\ub370\uc774\ud130\ub97c \ubcf5\uad6c\ud560 \uc218 \uc788\ub294 \uc18c\uc911\ud55c \ucffc\ub9ac\ub97c \uc54c\uc544\ubcf4\ub3c4\ub85d \ud558\uc790<span class=\"s1\">.<\/span><\/p>\n<p>\ub2e4\uc74c\uacfc \uac19\uc740 \uc608\ub97c \ub4e4\uc5b4\ubcf4\uc790<span class=\"s1\">.<\/span><\/p>\n<div class=\"imageblock center\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-137\" src=\"https:\/\/www.itchefblog.com\/wp-content\/uploads\/2016\/03\/3545095969.png\" alt=\"\" width=\"773\" height=\"164\" srcset=\"https:\/\/www.itchefblog.com\/wp-content\/uploads\/2016\/03\/3545095969.png 773w, https:\/\/www.itchefblog.com\/wp-content\/uploads\/2016\/03\/3545095969-300x64.png 300w, https:\/\/www.itchefblog.com\/wp-content\/uploads\/2016\/03\/3545095969-768x163.png 768w\" sizes=\"(max-width: 773px) 100vw, 773px\" \/><\/div>\n<p class=\"p3\"><span class=\"s2\">\uc704\uc640<\/span>\u00a0<span class=\"s2\">\uac19\uc740<\/span>\u00a0<span class=\"s2\">\uad6c\uc870\uc758<\/span>\u00a0PULLIM_ORA_TEST<span class=\"s2\">\ub77c\ub294<\/span>\u00a0<span class=\"s2\">\ud14c\uc774\ube14\uc774<\/span>\u00a0<span class=\"s2\">\uc788\ub2e4<\/span>.<\/p>\n<p><span class=\"s2\">\uc774\uc81c<\/span>\u00a0<span class=\"s2\">\ub9c9<\/span>\u00a0DB<span class=\"s2\">\ub97c<\/span>\u00a0<span class=\"s2\">\ubc30\uc6cc\uc11c<\/span>\u00a0<span class=\"s2\">\uad00\ub9ac\ud558\uac8c<\/span>\u00a0<span class=\"s2\">\ub41c<\/span>\u00a0&#8216;<span class=\"s2\">\uac00\uc0c1<\/span>&#8216;<span class=\"s2\">\uc758<\/span>\u00a0<span class=\"s2\">\uc804\uc0b0<\/span>\u00a0<span class=\"s2\">\uad00\ub9ac\uc790<\/span>\u00a0&#8216;<span class=\"s2\">\ud480\ub9ac\ubbf8<\/span>&#8216;<span class=\"s2\">\ub294<\/span>\u00a0<span class=\"s2\">\ud68c\uc6d0\uac00\uc785<\/span>\u00a0<span class=\"s2\">\ud14c\uc2a4\ud2b8\ub97c<\/span>\u00a0<span class=\"s2\">\uc704\ud574<\/span>\u00a0<span class=\"s2\">\uc790\uc2e0\uc758<\/span>\u00a0<span class=\"s2\">\uae30\uc874<\/span>\u00a0<span class=\"s2\">\uc544\uc774\ub514\ub97c<\/span>\u00a0<span class=\"s2\">\uc0ad\uc81c\ud558\uace0\uc790<\/span>\u00a0<span class=\"s2\">\ud55c\ub2e4<\/span>.<\/p>\n<p><span class=\"s2\">\uadf8\ub97c<\/span>\u00a0<span class=\"s2\">\uc704\ud574<\/span>\u00a0<span class=\"s2\">\ub2e4\uc74c\uacfc<\/span>\u00a0<span class=\"s2\">\uac19\uc774<\/span>\u00a0SQL\u00a0<span class=\"s2\">\ubb38\uc744<\/span>\u00a0<span class=\"s2\">\uc791\uc131\ud558\uace0<\/span>\u00a0<span class=\"s2\">\uc2e4\ud589<\/span>,\u00a0<span class=\"s2\">\ucee4\ubc0b\uc744<\/span>\u00a0<span class=\"s2\">\ud558\uae30\uc5d0<\/span>\u00a0<span class=\"s2\">\uc774\ub978\ub2e4<\/span>.<br \/>\nDELETE FROM PULLIM_ORA_TEST;<br \/>\nCOMMIT;<\/p>\n<div class=\"imageblock center\"><a href=\"https:\/\/www.itchefblog.com\/archives\/oracle-data-%ec%98%a4%eb%9d%bc%ed%81%b4-%eb%8d%b0%ec%9d%b4%ed%84%b0-%eb%b3%b5%ea%b5%ac-%ec%9d%bc%ec%a0%95-%ec%8b%9c%ea%b0%84-%ec%9d%b4%eb%82%b4\/attachment\/8535122564\/\" rel=\"attachment wp-att-138\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-138\" src=\"https:\/\/www.itchefblog.com\/wp-content\/uploads\/2016\/03\/8535122564.png\" alt=\"\" width=\"293\" height=\"68\" \/><\/a><\/div>\n<p class=\"p1\">\ud5d0 \uadf8\ub7f0\ub370<span class=\"s1\">..!!\u00a0<\/span>\ud070\uc77c\uc774 \ub0ac\ub2e4<span class=\"s1\">&#8230;<br \/>\n<\/span>\ucee4\ubc0b\uc744 \uc644\ub8cc \ud55c \ud6c4 \uc815\uc2e0\uc744 \ucc28\ub824\ubcf4\ub2c8<span class=\"s1\">\u00a0WHERE\u00a0<\/span>\ubb38\uc744 \ube7c\uba39\uc5c8\ub124<span class=\"s1\">..??!!<br \/>\n<\/span>\ubbf8\uce60 \ub178\ub987<span class=\"s1\">..\u00a0<\/span>\uc8fd\uc744 \ub178\ub987\uc774\ub2e4<span class=\"s1\">&#8230;\u00a0<\/span>\uc774\ub97c \uc5b4\uc9f8<span class=\"s1\">&#8230;?<br \/>\n<\/span>\uc544\uc8fc \ud65c\ubc1c\ud55c \ucee4\ubba4\ub2c8\ud2f0\ub294 \uc544\ub2c8\uc9c0\ub9cc \uadf8\ub798\ub3c4 \uaf64 \ub9ce\uc740 \ud68c\uc6d0\ub4e4\uc774 \ud558\ub8e8\uc5d0\ub3c4 \ubc29\ubb38\ud558\ub294 \uadf8\ub7f0 \ucee4\ubba4\ub2c8\ud2f0\uc758 \ud68c\uc6d0<span class=\"s1\">\u00a0DB<\/span>\uac00 \uc720\uc2e4\ub41c \uac83\uc774\ub2e4<span class=\"s1\">&#8230;<\/span><\/p>\n<p>\ubaa9\uc228\uc758 \uc704\ud611\uc744 \ub290\ub07c\uace0 \uc0b6\uacfc \uc8fd\uc74c\uc758 \ubb38\ud131\uc744 \ub118\ub098\ub4e4\ub358<span class=\"s1\">\u00a0&#8216;<\/span>\ud480\ub9ac\ubbf8<span class=\"s1\">&#8216;<\/span>\ub294 \uc120\ubc30<span class=\"s1\">\u00a0&#8216;<\/span>\ub514\ube44\ub9e8<span class=\"s1\">&#8216;<\/span>\uc5d0\uac8c \uc804\ud654\ub97c \uac78\uc5b4\uc11c \ub3c4\uc6c0\uc744 \uc694\uccad\ud55c\ub2e4<span class=\"s1\">.<br \/>\n&#8216;<\/span>\ub514\ube44\ub9e8<span class=\"s1\">&#8216;<\/span>\uc740 \ub2f9\ud669\ud558\uc9c0 \uc54a\uace0 \ub450\ub824\uc6c0\uc5d0 \ub5a8\uace0 \uc788\uc744<span class=\"s1\">\u00a0&#8216;<\/span>\ud480\ub9ac\ubbf8<span class=\"s1\">&#8216;<\/span>\uc5d0\uac8c \ucc28\ubd84\ud558\uac8c \ubb3b\ub294\ub2e4<span class=\"s1\">. (<\/span>\uc774\ub7f0 \uc120\uc784\ub9cc \uc874\uc7ac\ud55c\ub2e4\uba74 \uc5bc\ub9c8\ub098 \uc88b\uc744\uae4c<span class=\"s1\">?\u00a0<\/span>\u1112<span class=\"s1\">)<\/span><\/p>\n<p>\ub514\ube44\ub9e8<span class=\"s1\">\u00a0:\u00a0<\/span>\ucee4\ubc0b \ud55c\uc9c0 \uba87 \ubd84\uc774\ub098 \ub418\uc5c8\uc9c0<span class=\"s1\">?<br \/>\n<\/span>\ud480\ub9ac\ubbf8<span class=\"s1\">\u00a0:\u00a0<\/span>\ud55c<span class=\"s1\">\u00a03~5<\/span>\ubd84 \uc815\ub3c4 \ub418\uc5c8\uc5b4\uc694<span class=\"s1\">.<br \/>\n<\/span>\ub514\ube44\ub9e8<span class=\"s1\">\u00a0:\u00a0<\/span>\ube68\ub9ac \uc804\ud654\ud558\uae38 \uc798 \ud588\ub124<span class=\"s1\">..\u00a0<\/span>\uc5ec\ucc28\uc5ec\ucc28\ud574\uc11c \uc774\ub798 \uc800\ub9ac\ud558\uba74 \ub41c\ub2e4<span class=\"s1\">.\u00a0<\/span>\uac71\uc815 \ub9d0\uace0<span class=\"s1\">~\u00a0<\/span>\uadf8\ub7f4 \uc218\ub3c4 \uc788\ub294 \uac70\uc57c<span class=\"s1\">.\u00a0<\/span>\uadf8\ub7ec\uba74\uc11c \ubc30\uc6cc \uac00\ub294 \uac70\uc9c0<span class=\"s1\">~<\/span><\/p>\n<p>\ud480\ub9ac\ubbf8\uac00 \ub514\ube44\ub9e8\uc5d0\uac8c \uc124\uba85 \ub4e4\uc740 \ub300\ub85c \ube60\ub978 \uc870\uce58\ub97c \ud574\uc11c \ucee4\ubba4\ub2c8\ud2f0\ub294 \ub2e4\uc2dc \uc815\uc0c1\ud654\ub418\uc5c8\ub2e4\ub294 \ud6c4\ubb38\uc774 \uc788\ub2e4<span class=\"s1\">.<\/span><\/p>\n<p>\uc5b4\ub5a4 \ubc29\ubc95\uc73c\ub85c \uc0ad\uc81c\ud558\uace0 \ucee4\ubc0b\uae4c\uc9c0 \ud574\ubc84\ub9b0 \ub370\uc774\ud130\ub97c \uc0b4\ub9b4 \uc218 \uc788\uc5c8\uc744\uae4c<span class=\"s1\">?<\/span><\/p>\n<p>\uac04\ub2e8\ud558\ub2e4<span class=\"s1\">.<br \/>\nSELECT * FROM &#8216;<\/span>\ubcf5\uad6c\ud560\ud14c\uc774\ube14\uba85<span class=\"s1\">&#8216; AS OF TIMESTAMP(SYSTIMESTAMP &#8211; INTERVAL &#8216;<\/span>\uc6d0\ud558\ub294\uc2dc\uac04<span class=\"s1\">&#8216; MINUTE);<br \/>\n<\/span>\uc704\uc640 \uac19\uc740 \ucffc\ub9ac\ub97c \ub0a0\ub9ac\uba74<span class=\"s1\">\u00a0&#8216;<\/span>\uc6d0\ud558\ub294\uc2dc\uac04<span class=\"s1\">&#8216;<\/span>\ub0b4\uc5d0 \uc874\uc7ac\ud558\ub358 \ub370\uc774\ud130\ub4e4\uc744 \ud655\uc778\ud560 \uc218 \uc788\ub2e4<span class=\"s1\">.<br \/>\n<\/span>\uc624\ub77c\ud074\uc5d0\uc11c \ub370\uc774\ud130\ub97c \uc0ad\uc81c \ud639\uc740 \uc5c5\ub370\uc774\ud2b8 \uc2dc\uc5d0\ub3c4 \uc2dc\uc2a4\ud15c\uc5d0 \uc124\uc815\ub41c \uc77c\uc815 \uc2dc\uac04 \ub3d9\uc548\uc740 \ub370\uc774\ud130\ub97c \uba54\ubaa8\ub9ac \uc0c1\uc5d0 \uc801\uc7ac\ud558\uac8c \ub418\ub294\ub370<span class=\"s1\">,\u00a0<\/span>\uadf8 \uc2dc\uac04\uc744 \ub118\uae30\uc9c0 \uc54a\uc558\ub2e4\uba74 \ub370\uc774\ud130\ub97c \uc0b4\ub9b4 \uc218 \uc788\ub2e4<span class=\"s1\">.<br \/>\n<\/span>\uc77c\ubc18\uc801\uc73c\ub85c<span class=\"s1\">\u00a030<\/span>\ubd84 \uc815\ubcf4\uac00<span class=\"s1\">\u00a0DEFAULT\u00a0<\/span>\uac12\uc774\ubbc0\ub85c<span class=\"s1\">..\u00a0<\/span>\ubb54\uac00 \ub370\uc774\ud130\ub97c \ub0a0\ub838\ub2e4 \uc2f6\uc73c\uba74<span class=\"s1\">\u00a030<\/span>\ubd84 \uc774\ub0b4\ub85c \uc704\uc758 \ucffc\ub9ac\ub97c \uc0ac\uc6a9\ud558\uba74 \ub370\uc774\ud130\ub97c \ubcf5\uad6c\ud560 \uc218 \uc788\ub2e4<span class=\"s1\">.<\/span><\/p>\n<p>\ud480\ub9ac\ubbf8\uac00 \uc0ac\uc6a9\ud55c \ucffc\ub9ac\ub294 \ub2e4\uc74c\uacfc \uac19\ub2e4<span class=\"s1\">.<br \/>\nSELECT * FROM PULLIM_ORA_TEST AS OF TIMESTAMP(SYSTIMESTAMP &#8211; INTERVAL &#8216;5&#8217; MINUTE);<br \/>\n<\/span>\uc704\uc640 \uac19\uc774 \ucffc\ub9ac\ub97c \ub0a0\ub824\uc8fc\uc790 \ub0a0\uc544\uac00 \ubc84\ub838\ub358<span class=\"s1\">&#8230;\u00a0<\/span>\ud68c\uc6d0 \ub370\uc774\ud130\ub4e4\uc774 \ub098\ud0c0\ub0ac\ub2e4<span class=\"s1\">!<\/span><\/p>\n<div class=\"imageblock center\"><a href=\"https:\/\/www.itchefblog.com\/archives\/oracle-data-%ec%98%a4%eb%9d%bc%ed%81%b4-%eb%8d%b0%ec%9d%b4%ed%84%b0-%eb%b3%b5%ea%b5%ac-%ec%9d%bc%ec%a0%95-%ec%8b%9c%ea%b0%84-%ec%9d%b4%eb%82%b4\/attachment\/8896903266\/\" rel=\"attachment wp-att-140\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-140\" src=\"https:\/\/www.itchefblog.com\/wp-content\/uploads\/2016\/03\/8896903266.png\" alt=\"\" width=\"773\" height=\"179\" srcset=\"https:\/\/www.itchefblog.com\/wp-content\/uploads\/2016\/03\/8896903266.png 773w, https:\/\/www.itchefblog.com\/wp-content\/uploads\/2016\/03\/8896903266-300x69.png 300w, https:\/\/www.itchefblog.com\/wp-content\/uploads\/2016\/03\/8896903266-768x178.png 768w\" sizes=\"(max-width: 773px) 100vw, 773px\" \/><\/a><\/div>\n<p class=\"p3\"><span class=\"s2\">\ub370\uc774\ud130\uac00<\/span>\u00a0<span class=\"s2\">\uc0b4\uc544\uc788\ub294<\/span>\u00a0<span class=\"s2\">\uac83\uc744<\/span>\u00a0<span class=\"s2\">\ud655\uc778\ud588\uc73c\ub098<\/span>\u00a0<span class=\"s2\">\uc774\uac78\ub85c<\/span>\u00a0<span class=\"s2\">\ub05d\uc774<\/span>\u00a0<span class=\"s2\">\uc544\ub2c8\ub2e4<\/span>!<br \/>\n<span class=\"s2\">\uc9c0\uae08<\/span>\u00a0<span class=\"s2\">\uc774<\/span>\u00a0<span class=\"s2\">\ub370\uc774\ud130\ub294<\/span>\u00a0<span class=\"s2\">\uba54\ubaa8\ub9ac<\/span>\u00a0<span class=\"s2\">\uc0c1\uc5d0<\/span>\u00a0<span class=\"s2\">\uc801\uc7ac\ub418\uc5b4\uc788\ub294<\/span>\u00a0<span class=\"s2\">\ub370\uc774\ud130\ub85c<\/span>\u00a0<span class=\"s2\">\uc2dc\uac04\uc774<\/span>\u00a0<span class=\"s2\">\uc9c0\ub098\uba74<\/span>\u00a0<span class=\"s2\">\uc0ac\ub77c\uc838\ubc84\ub9b0\ub2e4<\/span>.<br \/>\n<span class=\"s2\">\uc774<\/span>\u00a0<span class=\"s2\">\ub370\uc774\ud130\uac00<\/span>\u00a0<span class=\"s2\">\uc0ac\ub77c\uc9c0\uae30<\/span>\u00a0<span class=\"s2\">\uc804\uc5d0<\/span>\u00a0<span class=\"s2\">\ub2e4\uc2dc<\/span>\u00a0<span class=\"s2\">\uc6d0\ub798\uc758<\/span>\u00a0<span class=\"s2\">\ud14c\uc774\ube14\uc5d0<\/span>\u00a0<span class=\"s2\">\ub123\uc5b4\uc8fc\uc5b4\uc57c<\/span>\u00a0<span class=\"s2\">\ud55c\ub2e4<\/span>.<\/p>\n<p><span class=\"s2\">\ub2e4\uc74c\uacfc<\/span>\u00a0<span class=\"s2\">\uac19\uc774<\/span>\u00a0<span class=\"s2\">\ucc98\ub9ac\ud558\uba74<\/span>\u00a0<span class=\"s2\">\ub2e4\uc2dc<\/span>\u00a0<span class=\"s2\">\ub370\uc774\ud130\ub97c<\/span>\u00a0<span class=\"s2\">\uae30\uc874\uc758<\/span>\u00a0<span class=\"s2\">\ud14c\uc774\ube14\uc5d0<\/span>\u00a0<span class=\"s2\">\ubcf5\uad6c\ud560<\/span>\u00a0<span class=\"s2\">\uc218<\/span>\u00a0<span class=\"s2\">\uc788\ub2e4<\/span>.<br \/>\nINSERT INTO PULLIM_ORA_TEST\u00a0SELECT * FROM PULLIM_ORA_TEST AS OF TIMESTAMP(SYSTIMESTAMP &#8211; INTERVAL &#8216;5&#8217; MINUTES);<br \/>\nCOMMIT;<\/p>\n<div class=\"imageblock center\"><a href=\"https:\/\/www.itchefblog.com\/archives\/oracle-data-%ec%98%a4%eb%9d%bc%ed%81%b4-%eb%8d%b0%ec%9d%b4%ed%84%b0-%eb%b3%b5%ea%b5%ac-%ec%9d%bc%ec%a0%95-%ec%8b%9c%ea%b0%84-%ec%9d%b4%eb%82%b4\/attachment\/9990325326\/\" rel=\"attachment wp-att-141\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-141\" src=\"https:\/\/www.itchefblog.com\/wp-content\/uploads\/2016\/03\/9990325326.png\" alt=\"\" width=\"773\" height=\"76\" srcset=\"https:\/\/www.itchefblog.com\/wp-content\/uploads\/2016\/03\/9990325326.png 773w, https:\/\/www.itchefblog.com\/wp-content\/uploads\/2016\/03\/9990325326-300x29.png 300w, https:\/\/www.itchefblog.com\/wp-content\/uploads\/2016\/03\/9990325326-768x76.png 768w\" sizes=\"(max-width: 773px) 100vw, 773px\" \/><\/a><\/div>\n<p class=\"p1\">\uc704\uc640 \uac19\uc774 \ucffc\ub9ac\ubb38\uc744 \uc785\ub825 \ud6c4 \uc2e4\ud589\ud558\uace0 \ucee4\ubc0b\uc744 \ud558\uc790 \ud68c\uc6d0 \ud14c\uc774\ube14\uc5d0 \ud68c\uc6d0 \ub370\uc774\ud130\ub4e4\uc774 \uc815\uc0c1\uc801\uc73c\ub85c \uc785\ub825\ub418\uc5c8\ub2e4<span class=\"s1\">.<\/span><\/p>\n<div class=\"imageblock center\"><a href=\"https:\/\/www.itchefblog.com\/archives\/oracle-data-%ec%98%a4%eb%9d%bc%ed%81%b4-%eb%8d%b0%ec%9d%b4%ed%84%b0-%eb%b3%b5%ea%b5%ac-%ec%9d%bc%ec%a0%95-%ec%8b%9c%ea%b0%84-%ec%9d%b4%eb%82%b4\/attachment\/4280524455\/\" rel=\"attachment wp-att-142\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-142\" src=\"https:\/\/www.itchefblog.com\/wp-content\/uploads\/2016\/03\/4280524455.png\" alt=\"\" width=\"773\" height=\"179\" srcset=\"https:\/\/www.itchefblog.com\/wp-content\/uploads\/2016\/03\/4280524455.png 773w, https:\/\/www.itchefblog.com\/wp-content\/uploads\/2016\/03\/4280524455-300x69.png 300w, https:\/\/www.itchefblog.com\/wp-content\/uploads\/2016\/03\/4280524455-768x178.png 768w\" sizes=\"(max-width: 773px) 100vw, 773px\" \/><\/a><\/div>\n<p class=\"p1\">\uc5b4\ub5a4\uac00<span class=\"s1\">?\u00a0<\/span>\uac04\ub2e8\ud558\uc9c0 \uc54a\uc740\uac00<span class=\"s1\">?<br \/>\n<\/span>\uc815\ub9d0 \uac04\ub2e8\ud558\uc9c0\ub9cc<span class=\"s1\">&#8230;\u00a0<\/span>\ub54c\uc5d0 \ub530\ub77c\uc11c\ub294<span class=\"s1\">\u00a0DBA<\/span>\uc758 \uc0dd\uba85\uc744 \uc0b4\ub9ac\ub294 \uc18c\uc911\ud55c \ucffc\ub9ac\uc774\ub2e4<span class=\"s1\">..<br \/>\n<\/span>\uc798 \uae30\uc5b5\ud574 \ub450\uc790<span class=\"s1\">.<\/span><\/p>\n<p>SQL\u00a0\ubb38 \ub9cc\uc744 \uc124\uba85\ud558\uc790\uba74 \ub531\ub531\ud558\uace0 \uc7ac\ubbf8\uac00 \uc5c6\uae30\uc5d0 \ub2e4\uc18c \uba4d\uccad\ud574 \ubcf4\uc774\uae34 \ud558\uc9c0\ub9cc \uc0c1\ud669\uc744 \uc124\uc815\ud558\uace0 \uc124\uba85\ud574\ubcf4\uc558\ub2e4<span class=\"s1\">.<\/span><\/p>\n<p>\uc815\ub9d0 \uc5b4\ub9ac\ubc14\ub9ac \ud574 \ubcf4\uc774\uc9c0\ub9cc \ubc14\uc058\uace0 \uc815\uc2e0\uc5c6\ub294 \uc0c1\ud669\uc5d0 \uc774 \ud14c\uc774\ube14 \uc800 \ud14c\uc774\ube14 \uc62e\uaca8 \ub2e4\ub2c8\uba74\uc11c \uc791\uc5c5\uc744 \ud558\ub2e4 \ubcf4\uba74 \uac04\ud639 \uc788\uc744 \ubc95 \ud55c \uc0c1\ud669\uc774\ub2e4<span class=\"s1\">.<br \/>\n<\/span>\ud544\uc790\uc758 \uacbd\uc6b0 \uc560\ud50c\ub9ac\ucf00\uc774\uc158 \uac1c\ubc1c\uc744 \ud558\ub358 \ub3c4\uc911<span class=\"s1\">\u00a0WHERE\u00a0<\/span>\ubb38 \uc0ac\uc6a9 \uc2e4\uc218\ub85c \uc911\uc694\ud55c \ub370\uc774\ud130\ub97c \uc798 \ubabb \ud578\ub4e4\ub9c1 \ud55c \uacbd\ud5d8\uc774 \uc788\ub294\ub370 \uc704\uc758 \ucffc\ub9ac\ub97c \uc54c\uac8c \ub418\uc5b4\uc11c \ub2e4\ud589\ud788\ub3c4 \ubaa8\ub4e0 \ub370\uc774\ud130\ub97c \uc6d0\ub798\ub300\ub85c \ubcf5\uad6c\ud560 \uc218 \uc788\uc5c8\ub2e4<span class=\"s1\">.<br \/>\n<\/span>\uadf8\ub54c\ub97c \uc0dd\uac01\ud558\uba74 \uc815\ub9d0<span class=\"s1\">&#8230;\u00a0<\/span>\ub054\ucc0d\ud588\ub2e4<span class=\"s1\">&#8230;\u00a0<\/span>\uc8fd\ub2e4 \uc0b4\uc544\ub09c \uae30\ubd84<span class=\"s1\">?\u00a0<\/span>\u314e\u314e<\/p>\n<p>\uc694\uc57d\ud558\uc790\uba74<span class=\"s1\">,<br \/>\n1. INSERT, UPDATE, DELETE\u00a0<\/span>\ubb38 \uc0ac\uc6a9 \uc2dc\uc5d0\ub294 \ud56d\uc0c1<span class=\"s1\">\u00a0WHERE\u00a0<\/span>\ubb38\uc744 \uaf3c\uaf3c\ud558\uac8c \uccb4\ud06c\ud558\uc790<span class=\"s1\">!<br \/>\n2.\u00a0<\/span>\ud639\uc5ec \uc2e4\uc218\ub85c \uc798\ubabb \ud578\ub4e4\ub9c1 \ud588\uc744\uc9c0\ub77c\ub3c4 \ub2f9\ud669\ud558\uc9c0 \ub9d0\uace0<span class=\"s1\">\u00a0ROLLBACK<\/span>\uc744 \ud558\uc790<span class=\"s1\">!<br \/>\n3. ROLLBACK<\/span>\ud560 \uaca8\ub97c\ub3c4 \uc5c6\uc774<span class=\"s1\">\u00a0COMMIT<\/span>\uc744 \ub0a0\ub824\ubc84\ub838\ub2e4\uba74 \ub2f9\ud669\ud558\uc9c0 \ub9d0\uace0 \ube60\ub978 \uc2dc\uac04 \ub0b4\uc5d0 \uc704\uc758 \ucffc\ub9ac\ub97c \uc0ac\uc6a9\ud558\uc5ec \ub370\uc774\ud130\ub97c \ubcf5\uad6c\ud558\uc790<span class=\"s1\">! (<\/span>\uc784\uc2dc \ud14c\uc774\ube14\uc744 \ub9cc\ub4e4\uc5b4\uc11c \uadf8\uacf3\uc5d0 \ubcf5\uad6c\ud55c \ud6c4 \ud544\uc694\ud55c \ub370\uc774\ud130\ub9cc \uc120\ubcc4\uc801\uc73c\ub85c<span class=\"s1\">\u00a0INSERT\u00a0<\/span>\ud558\ub294 \uac83\uc744 \uad8c\uc7a5<span class=\"s1\">)<\/span><\/p>\n","protected":false},"excerpt":{"rendered":"<p>DB\ub97c \uc0ac\uc6a9\ud558\ub2e4 \ubcf4\uba74 \uc815\ub9d0 \ub09c\ucc98\ud55c \uc0c1\ud669\uc5d0 \uc9c1\uba74\ud560 \ub54c\uac00 \uc788\ub2e4.. \uc608\ub97c \ub4e4\uc5b4\uc11c\u00a0\u00a0\uc911\uc694\ud55c \ud68c\uc6d0 \ub370\uc774\ud130 \ud14c\uc774\ube14\uc744 \ud578\ub4e4\ub9c1 \ud558\ub2e4\uac00 \uc815\uc2e0\uc774 \uc5c6\uc5b4\uc11c WHERE\u00a0\ubb38\uc744 \uc78a\uc5c8\ub2e4&#8230;?\u00a0\uc624\ub9c8\uac13..\u00a0\ub300\ud615 \uc0ac\uace0\ub2e4&#8230; \uc774\ubc88 \ud3ec\uc2a4\ud305\uc5d0\uc11c\ub294\u00a0ORACLE\uc5d0\uc11c \uc2e4\uc218\ub85c \ub0a0\ub824\ubc84\ub9b0! (\ud639\uc740 \uc218\uc815\ud574\ubc84\ub9b0)\u00a0\ub370\uc774\ud130\ub97c \ubcf5\uad6c\ud560 \uc218 \uc788\ub294 \uc18c\uc911\ud55c \ucffc\ub9ac\ub97c \uc54c\uc544\ubcf4\ub3c4\ub85d \ud558\uc790. \ub2e4\uc74c\uacfc \uac19\uc740 \uc608\ub97c \ub4e4\uc5b4\ubcf4\uc790. \uc704\uc640\u00a0\uac19\uc740\u00a0\uad6c\uc870\uc758\u00a0PULLIM_ORA_TEST\ub77c\ub294\u00a0\ud14c\uc774\ube14\uc774\u00a0\uc788\ub2e4. \uc774\uc81c\u00a0\ub9c9\u00a0DB\ub97c\u00a0\ubc30\uc6cc\uc11c\u00a0\uad00\ub9ac\ud558\uac8c\u00a0\ub41c\u00a0&#8216;\uac00\uc0c1&#8216;\uc758\u00a0\uc804\uc0b0\u00a0\uad00\ub9ac\uc790\u00a0&#8216;\ud480\ub9ac\ubbf8&#8216;\ub294\u00a0\ud68c\uc6d0\uac00\uc785\u00a0\ud14c\uc2a4\ud2b8\ub97c\u00a0\uc704\ud574\u00a0\uc790\uc2e0\uc758\u00a0\uae30\uc874\u00a0\uc544\uc774\ub514\ub97c\u00a0\uc0ad\uc81c\ud558\uace0\uc790\u00a0\ud55c\ub2e4. \uadf8\ub97c\u00a0\uc704\ud574\u00a0\ub2e4\uc74c\uacfc\u00a0\uac19\uc774\u00a0SQL\u00a0\ubb38\uc744\u00a0\uc791\uc131\ud558\uace0\u00a0\uc2e4\ud589,\u00a0\ucee4\ubc0b\uc744\u00a0\ud558\uae30\uc5d0\u00a0\uc774\ub978\ub2e4. DELETE FROM PULLIM_ORA_TEST; COMMIT; \ud5d0 \uadf8\ub7f0\ub370..!!\u00a0\ud070\uc77c\uc774 \ub0ac\ub2e4&#8230; \ucee4\ubc0b\uc744 \uc644\ub8cc \ud55c \ud6c4 \uc815\uc2e0\uc744 \ucc28\ub824\ubcf4\ub2c8\u00a0WHERE\u00a0\ubb38\uc744 \ube7c\uba39\uc5c8\ub124..??!! &hellip; <\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[21],"tags":[49,50,51,52,53,54,55,56,47,48],"_links":{"self":[{"href":"https:\/\/www.itchefblog.com\/index.php?rest_route=\/wp\/v2\/posts\/132"}],"collection":[{"href":"https:\/\/www.itchefblog.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.itchefblog.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.itchefblog.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.itchefblog.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=132"}],"version-history":[{"count":4,"href":"https:\/\/www.itchefblog.com\/index.php?rest_route=\/wp\/v2\/posts\/132\/revisions"}],"predecessor-version":[{"id":143,"href":"https:\/\/www.itchefblog.com\/index.php?rest_route=\/wp\/v2\/posts\/132\/revisions\/143"}],"wp:attachment":[{"href":"https:\/\/www.itchefblog.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=132"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.itchefblog.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=132"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.itchefblog.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=132"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}