{"id":3549,"date":"2018-02-04T22:19:14","date_gmt":"2018-02-04T13:19:14","guid":{"rendered":"http:\/\/haisins.epac.to\/wordpress\/?p=3549"},"modified":"2018-02-04T22:20:04","modified_gmt":"2018-02-04T13:20:04","slug":"%ec%bb%ac%eb%9f%bc-%ec%b6%94%ea%b0%80-%ec%8b%9c%ec%97%90-%eb%94%94%ed%8f%b4%ed%8a%b8-%ea%b0%92-%ec%82%ac%ec%9a%a9%ed%95%98%ea%b8%b0-oracle-11g","status":"publish","type":"post","link":"http:\/\/haisins.synology.me\/wordpress\/?p=3549","title":{"rendered":"\uceec\ub7fc \ucd94\uac00 \uc2dc\uc5d0 \ub514\ud3f4\ud2b8 \uac12 \uc0ac\uc6a9\ud558\uae30 (oracle 11g)"},"content":{"rendered":"<p>DBA\uac00 \ucd94\uac00\ud558\ub824\ub294 TAX_CODE \uceec\ub7fc\uc740 NOT NULL \uc81c\uc57d \uc870\uac74\uc774 \uc801\uc6a9\ub418\uc5b4 \uc788\uc5b4\uc57c \ud569\ub2c8\ub2e4.<\/p>\n<p>&nbsp;<\/p>\n<p>\uc774\ubbf8 \ub370\uc774\ud130\uac00 \uc785\ub825\ub41c \ud14c\uc774\ube14\uc5d0 NOT NULL \uceec\ub7fc\uc744 \ucd94\uac00\ud558\uae30 \uc704\ud574 \ub514\ud3f4\ud2b8 \uac12 &#8216;XX&#8217;\ub97c \uc801\uc6a9\ud574\uc57c \ud569\ub2c8\ub2e4.<\/p>\n<p>&nbsp;<\/p>\n<p>DBA\ub294 \uc544\ub798\uc640 \uac19\uc740 SQL \uad6c\ubb38\uc744 \uc791\uc131 \ud560 \uac83\uc785\ub2c8\ub2e4.<\/p>\n<p>&nbsp;<\/p>\n<pre class=\"lang:plsql decode:true \">alter table sales add tax_code varchar2(20) default 'XX' not null;<\/pre>\n<p>&nbsp;<\/p>\n<p>\ud558\uc9c0\ub9cc \ubb38\uc81c\uac00 \uc644\uc804\ud788 \ud574\uacb0\ub41c \uac83\uc740 \uc544\ub2d9\ub2c8\ub2e4.<\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"color: #ff0000;\"><strong>SALES \ud14c\uc774\ube14\uc740 \uc57d 4 \uc5b5 \uac1c\uc758 \ub85c\uc6b0\ub97c \ud3ec\ud568\ud558\ub294 \uac70\ub300\ud55c \ud14c\uc774\ube14\uc785\ub2c8\ub2e4.<\/strong><\/span><\/p>\n<p>\uc774 \uba85\ub839\uc744 \uc2e4\ud589\ud55c\ub2e4\uba74 \uceec\ub7fc\uc774 \ucd94\uac00\ub418\uae30\ub294 \ud558\uaca0\uc9c0\ub9cc, \ubaa8\ub4e0 &#8216;XX&#8217; \ub85c\uc6b0\uc5d0 \uac12\uc774 \uc5c5\ub370\uc774\ud2b8\ub418\uae30 \uc804\uae4c\uc9c0\ub294 \ud14c\uc774\ube14\uc5d0 \ub300\ud55c \ucee8\ud2b8\ub864\uc744 \ud68c\ubcf5\ud560 \uc218 \uc5c6\uc744 \uac83\uc785\ub2c8\ub2e4. 4 \uc5b5 \uac1c\uc758 \ub85c\uc6b0\ub97c \uc5c5\ub370\uc774\ud2b8\ud558\ub294 \uc791\uc5c5\uc740 \ub9e4\uc6b0 \uc624\ub79c \uc2dc\uac04\uc774 \uac78\ub9b4 \ubfd0 \uc544\ub2c8\ub77c, \uc5b8\ub450 \uc138\uadf8\uba3c\ud2b8\ub97c \uac00\ub4dd \ucc44\uc6b0\uace0, \ub300\ub7c9\uc758 \ub9ac\ub450 \ub370\uc774\ud130\uac00 \uc313\uc774\uace0, \uc0c1\ub2f9\ud55c \uc218\uc900\uc758 \uc131\ub2a5 \uc624\ubc84\ud5e4\ub4dc\uac00 \ubc1c\uc0dd\ud558\uac8c \ub420 \uac83\uc785\ub2c8\ub2e4. \uacb0\uad6d \ucffc\ub9ac\ub294 \uc2dc\uc2a4\ud15c\uc744 \uc911\ub2e8\uc2dc\ud0ac \uc218 \uc788\uc744 \ub54c\uae4c\uc9c0 \uc791\uc5c5\uc744 \uc720\ubcf4\ud558\uae30\ub85c \ud569\ub2c8\ub2e4.<\/p>\n<p>&nbsp;<\/p>\n<p>Oracle Database 11g \ub77c\uba74 ?<\/p>\n<p>\ub300\uc548\uc774 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"font-size: 20px;\"><strong><span style=\"color: #ff0000;\">11g \uc5d0\uc11c\ub294 \uc704 \uba85\ub839\uc744 \uc2e4\ud589\ud558\ub354\ub77c\ub3c4 \ud14c\uc774\ube14\uc758 \ubaa8\ub4e0 \ub808\ucf54\ub4dc\uc5d0 \ub300\ud55c \uc5c5\ub370\uc774\ud2b8\uac00 \uc2e4\ud589\ub418\uc9c0 \uc54a\uc2b5\ub2c8\ub2e4. <\/span><\/strong><\/span><\/p>\n<p>&nbsp;<\/p>\n<p>\uc0c8\ub85c \ucd94\uac00\ub418\ub294 \ub808\ucf54\ub4dc\uc758 \uacbd\uc6b0 \uceec\ub7fc\uc758 \ub514\ud3f4\ud2b8 \uac12\uc774 \uc790\ub3d9\uc73c\ub85c \uc785\ub825\ub418\ubbc0\ub85c \ubb38\uc81c\ub420 \uac83\uc774 \uc5c6\uc2b5\ub2c8\ub2e4.<\/p>\n<p>\ud558\uc9c0\ub9cc \uc0ac\uc6a9\uc790\uac00 \uae30\uc874\uc758 \ub808\ucf54\ub4dc\uc5d0\uc11c \uc774 \uceec\ub7fc\uc744 \uc870\ud68c\ud558\uba74 NULL\uc774 \ubc18\ud658\ub418\uc9c0 \uc54a\uc744\uae4c\uc694?<\/p>\n<p>\uadf8\ub807\uc9c0 \uc54a\uc2b5\ub2c8\ub2e4. \uc0ac\uc6a9\uc790\uac00 \uae30\uc874 \ub808\ucf54\ub4dc\uc758 \uceec\ub7fc\uc744 \uc120\ud0dd\ud558\uba74, \uc624\ub77c\ud074\uc740 \ub370\uc774\ud130 \ub515\uc154\ub108\ub9ac\uc5d0\uc11c \ub514\ud3f4\ud2b8 \uac12\uc744 \uc870\ud68c\ud55c \ud6c4 \uc774 \uac12\uc744 \uc0ac\uc6a9\uc790\uc5d0\uac8c \ubc18\ud658\ud569\ub2c8\ub2e4.<\/p>\n<p>&nbsp;<\/p>\n<p><strong><span style=\"color: #0000ff;\">\ub514\ud3f4\ud2b8 \uac12\uc744 \uac16\ub294 NOT NULL \uceec\ub7fc\uc744 \uc0c8\ub85c \ucd94\uac00\ud558\uace0\ub3c4 \ub9ac\ub450\/\uc5b8\ub450 \ub370\uc774\ud130 \uc0dd\uc131\uc73c\ub85c \uc778\ud55c \uc131\ub2a5 \ubb38\uc81c\ub97c \uacaa\uc9c0 \uc54a\uc73c\ub2c8 \uc77c\uac70\uc591\ub4dd<\/span><\/strong>\uc778 \uc148\uc785\ub2c8\ub2e4.<\/p>\n<p>\ub530\ub77c\uc11c \uc2e4\uc81c\ub85c not null \ub97c \uac16\ub294 \uceec\ub7fc\uc744 \ucd94\uac00\ud55c \uc774\ud6c4\uc758 data\ub294 default \uac12 \u2018XX\u2019 \uac00 \uadf8\ub300\ub85c \uc801\uc6a9\ub418\uc5b4 \uc785\ub825 \ub418\uaca0\uc9c0\ub9cc, \uc774\uc804\uc758 \ub85c\uc6b0\uc5d0\ub294 <span style=\"color: #ff0000;\">\uc2e4\uc81c\ub85c default \uac12 \u2018XX\u2019 \uac00 update \ub418\ub294\uac83\uc774 \uc544\ub2c8\ub77c \ub515\uc154\ub108\ub9ac\ub97c \ud1b5\ud574\uc11c \ubcf4\uc5ec \uc8fc\uac8c \ub418\ub294 \uac83<\/span> \uc785\ub2c8\ub2e4.<\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"color: #339966; font-size: 24px;\"><strong>Oracle 11g \ubd80\ud130 \uceec\ub7fc \ucd94\uac00 \uae30\ub2a5 \ud5a5\uc0c1<\/strong><\/span><\/p>\n<p>&nbsp;<\/p>\n<p>\ud14c\uc774\ube14\uc5d0 column \ucd94\uac00\uc2dc(Default Value\uac00 \uc9c0\uc815\ub418\uace0, NOT NULL \uc81c\ud55c\uc0ac\ud56d\uc774 \uc788\ub294 \uacbd\uc6b0) Default Value\uac00 Table\uc5d0 \uc9c1\uc811 insert\ub418\uc9c0 \uc54a\uace0 dictionary\uc5d0 metadata\ub85c\ub9cc \uac00\uc9c0\uace0 \uc788\ub294 \uae30\ub2a5\uc774\ub2e4.<\/p>\n<p>&nbsp;<\/p>\n<p><strong><span style=\"color: #ff6600;\">\uc774\uc804 \ubc84\uc804 \uc5d0\uc11c\ub294 Row\uc218\uac00 \ub9ce\uc740 \ud14c\uc774\ube14\uc5d0 Not Null\uc774\uba74\uc11c Default Value\uac00 \uc788\ub294 Column\uc744 \ucd94\uac00\ud558\uba74, Default Value\uac00 \ubaa8\ub4e0 row \uc5d0 \ub300\ud558\uc5ec insert\ub418\uc5c8\uae30 \ub54c\ubb38\uc5d0 \uc0c1\ub2f9\ud55c \uc2dc\uac04\uc774 \uac78\ub838\uc5c8\ub2e4. <\/span><\/strong><\/p>\n<p>&nbsp;<\/p>\n<p>\uadf8\ub9ac\uace0 <strong>Add Column \uc774 \uc218\ud589\ub418\ub294 \ub3d9\uc548 \ud574\ub2f9 Dependent SQL \uc774 \u201clibrary cache pin\u201d, \u201clibrary cache lock\u201d\ub4f1\uc758 waiting\ud604\uc0c1\uc774 \ubc1c\uc0dd<\/strong>\ub418\uc5c8\ub2e4.<\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"color: #ff00ff;\"><strong>\uc624\ub77c\ud074 \ub370\uc774\ud130\ubca0\uc774\uc2a4 11g\uc5d0\uc11c\ub294 \ud14c\uc774\ube14\uc5d0 Column\uc774 \ucd94\uac00\ub420 \uacbd\uc6b0 Default \uac12\uc774 \uc9c0\uc815\ub418\uba74 Dictionary\uc5d0\ub9cc Default\uac12\uc774 \uc800\uc7a5\ub418\uc5b4 Add Column\uc791\uc5c5\uc774 1\ucd08 \uc774\ub0b4\uc5d0 \ub05d\ub09c\ub2e4.<\/strong><\/span><\/p>\n<p>&nbsp;<\/p>\n<p>Default \uac12\uc740 \ud574\ub2f9 row\uac00 insert\/update\ub418\ub294 \uc21c\uac04\uc5d0 \uc785\ub825\uc774 \ub41c\ub2e4. \ub530\ub77c\uc11c \uc624\ub79c DDL\uc218\ud589\uc73c\ub85c \uc778\ud55c \u201clibrary cache pin\u201d, \u201clibrary cache lock\u201d \ud604\uc0c1\uc774 \ud574\uc18c\ub420 \uac83\uc73c\ub85c \uae30\ub300\ub41c\ub2e4.<\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"font-size: 20px;\"><em><strong>\uceec\ub7fc \ucd94\uac00 \uae30\ub2a5 \ud5a5\uc0c1\uc758 \uc7a5\uc810<\/strong><\/em><\/span><\/p>\n<ul>\n<li><span style=\"color: #800080;\"><strong>Add Column \uc791\uc5c5\uc774 \ub9e4\uc6b0 \uc9e7\uc740 \uc2dc\uac04 \ub0b4\uc5d0 \ub05d\ub09c\ub2e4.<\/strong><\/span><\/li>\n<li><span style=\"color: #800080;\"><strong>\uc2e4\uc2dc\uac04 Default Value\uc758 Insert\ub85c \uc778\ud55c \ubd80\ud558(insert\uc791\uc5c5\uacfc Redo \ubc1c\uc0dd)\uc774 \uc5c6\uc5b4\uc84c\ub2e4.<\/strong><\/span><\/li>\n<li><span style=\"color: #800080;\"><strong>Add Column \uc218\ud589 \uc911\uc758 SQL Waiting \ud604\uc0c1\uc774 \ud574\uc18c\ub41c\ub2e4.<\/strong><\/span><\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>DBA\uac00 \ucd94\uac00\ud558\ub824\ub294 TAX_CODE \uceec\ub7fc\uc740 NOT NULL \uc81c\uc57d \uc870\uac74\uc774 \uc801\uc6a9\ub418\uc5b4 \uc788\uc5b4\uc57c \ud569\ub2c8\ub2e4. &nbsp; \uc774\ubbf8 \ub370\uc774\ud130\uac00 \uc785\ub825\ub41c \ud14c\uc774\ube14\uc5d0 NOT NULL \uceec\ub7fc\uc744 \ucd94\uac00\ud558\uae30 \uc704\ud574 \ub514\ud3f4\ud2b8 \uac12 &#8216;XX&#8217;\ub97c \uc801\uc6a9\ud574\uc57c \ud569\ub2c8\ub2e4. &nbsp; DBA\ub294 \uc544\ub798\uc640 \uac19\uc740 SQL \uad6c\ubb38\uc744 \uc791\uc131 \ud560 \uac83\uc785\ub2c8\ub2e4. &nbsp; alter table sales add tax_code varchar2(20) default &#8216;XX&#8217; not null; &nbsp; \ud558\uc9c0\ub9cc \ubb38\uc81c\uac00 \uc644\uc804\ud788 \ud574\uacb0\ub41c \uac83\uc740 \uc544\ub2d9\ub2c8\ub2e4. &nbsp; SALES [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":3403,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_bbp_topic_count":0,"_bbp_reply_count":0,"_bbp_total_topic_count":0,"_bbp_total_reply_count":0,"_bbp_voice_count":0,"_bbp_anonymous_reply_count":0,"_bbp_topic_count_hidden":0,"_bbp_reply_count_hidden":0,"_bbp_forum_subforum_count":0,"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"spay_email":""},"categories":[3],"tags":[1003,1002,999,1001,1000],"jetpack_featured_media_url":"https:\/\/i0.wp.com\/haisins.synology.me\/wordpress\/wp-content\/uploads\/2018\/02\/Bild-Flyer-Know-how.jpg?fit=1000%2C563","amp_enabled":true,"_links":{"self":[{"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/3549"}],"collection":[{"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=3549"}],"version-history":[{"count":1,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/3549\/revisions"}],"predecessor-version":[{"id":3550,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/3549\/revisions\/3550"}],"wp:featuredmedia":[{"embeddable":true,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/media\/3403"}],"wp:attachment":[{"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=3549"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=3549"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=3549"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}