{"id":11720,"date":"2022-09-28T22:09:27","date_gmt":"2022-09-28T13:09:27","guid":{"rendered":"https:\/\/prodskill.com\/?p=11720"},"modified":"2022-10-10T21:03:51","modified_gmt":"2022-10-10T12:03:51","slug":"da-macro-usage-notes","status":"publish","type":"post","link":"https:\/\/prodskill.com\/zh\/da-macro-usage-notes\/","title":{"rendered":"DA# Macro(5)\uff1a\u4f7f\u7528\u6ce8\u610f\u4e8b\u9879\/\u53c2\u8003\u3001\u4e0b\u8f7d\u3001\u540e\u7eed\u6dfb\u52a0\u7684\u529f\u80fd\u3001\u6ce8\u610f\u4e8b\u9879"},"content":{"rendered":"\n<p>\uc774 \uae00\uc5d0\uc11c\ub294 DA# Macro \uc0ac\uc6a9\uc0c1 \uc8fc\uc758\uc0ac\ud56d\/\ucc38\uace0\uc0ac\ud56d, \ub2e4\uc6b4\ub85c\ub4dc, \ud5a5\ud6c4 \ucd94\uac00 \uc608\uc815 \uae30\ub2a5, \uc77c\ub7ec\ub450\uae30\uc5d0 \ub300\ud574 \uc0b4\ud3b4\ubcf8\ub2e4.<\/p>\n\n\n\n<p>\uc774\uc804 \uae00\uc5d0\uc11c \uc774\uc5b4\uc9c0\ub294 \ub0b4\uc6a9\uc774\ub2e4.<\/p>\n\n\n\n<p><a href=\"https:\/\/prodskill.com\/da-macro-function-reverse\/\">DA# Macro(4): DA# Macro(\ub9e4\ud06c\ub85c) \uae30\ub2a5(3)-Reverse<\/a><\/p>\n\n\n\n<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_82_2 counter-hierarchy ez-toc-counter ez-toc-grey ez-toc-container-direction\">\n<div class=\"ez-toc-title-container\">\n<p class=\"ez-toc-title\" style=\"cursor:inherit\">&lt;&lt;\ubaa9\ucc28&gt;&gt;<\/p>\n<span class=\"ez-toc-title-toggle\"><a href=\"#\" class=\"ez-toc-pull-right ez-toc-btn ez-toc-btn-xs ez-toc-btn-default ez-toc-toggle\" aria-label=\"Toggle Table of Content\"><span class=\"ez-toc-js-icon-con\"><span class=\"\"><span class=\"eztoc-hide\" style=\"display:none;\">Toggle<\/span><span class=\"ez-toc-icon-toggle-span\"><svg style=\"fill: #999;color:#999\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" class=\"list-377408\" width=\"20px\" height=\"20px\" viewBox=\"0 0 24 24\" fill=\"none\"><path d=\"M6 6H4v2h2V6zm14 0H8v2h12V6zM4 11h2v2H4v-2zm16 0H8v2h12v-2zM4 16h2v2H4v-2zm16 0H8v2h12v-2z\" fill=\"currentColor\"><\/path><\/svg><svg style=\"fill: #999;color:#999\" class=\"arrow-unsorted-368013\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"10px\" height=\"10px\" viewBox=\"0 0 24 24\" version=\"1.2\" baseProfile=\"tiny\"><path d=\"M18.2 9.3l-6.2-6.3-6.2 6.3c-.2.2-.3.4-.3.7s.1.5.3.7c.2.2.4.3.7.3h11c.3 0 .5-.1.7-.3.2-.2.3-.5.3-.7s-.1-.5-.3-.7zM5.8 14.7l6.2 6.3 6.2-6.3c.2-.2.3-.5.3-.7s-.1-.5-.3-.7c-.2-.2-.4-.3-.7-.3h-11c-.3 0-.5.1-.7.3-.2.2-.3.5-.3.7s.1.5.3.7z\"\/><\/svg><\/span><\/span><\/span><\/a><\/span><\/div>\n<nav><ul class='ez-toc-list ez-toc-list-level-1 ' ><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/prodskill.com\/zh\/da-macro-usage-notes\/#3_DA_Macro_%EC%82%AC%EC%9A%A9%EC%83%81_%EC%A3%BC%EC%9D%98%EC%82%AC%ED%95%AD%EC%B0%B8%EA%B3%A0%EC%82%AC%ED%95%AD\" >3. DA# Macro \uc0ac\uc6a9\uc0c1 \uc8fc\uc758\uc0ac\ud56d\/\ucc38\uace0\uc0ac\ud56d<\/a><ul class='ez-toc-list-level-3' ><li class='ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/prodskill.com\/zh\/da-macro-usage-notes\/#31_DA_Macro_%EC%82%AC%EC%9A%A9%EC%83%81_%EC%A3%BC%EC%9D%98%EC%82%AC%ED%95%AD\" >3.1. DA# Macro \uc0ac\uc6a9\uc0c1 \uc8fc\uc758\uc0ac\ud56d<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/prodskill.com\/zh\/da-macro-usage-notes\/#32_DA_Macro_%EC%B0%B8%EA%B3%A0%EC%82%AC%ED%95%AD\" >3.2. DA# Macro \ucc38\uace0\uc0ac\ud56d<\/a><ul class='ez-toc-list-level-4' ><li class='ez-toc-heading-level-4'><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/prodskill.com\/zh\/da-macro-usage-notes\/#321_Reverse_%EB%8F%99%EC%8B%9C_%EC%8B%A4%ED%96%89_%EB%B0%A9%EB%B2%95\" >3.2.1. Reverse \ub3d9\uc2dc \uc2e4\ud589 \ubc29\ubc95<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-4'><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/prodskill.com\/zh\/da-macro-usage-notes\/#322_DA_Macro%EA%B0%80_%EC%A0%95%EC%83%81%EC%A0%81%EC%9C%BC%EB%A1%9C_%EB%8F%99%EC%9E%91%ED%95%98%EC%A7%80_%EC%95%8A%EB%8A%94_%EA%B2%BD%EC%9A%B0_%EC%A1%B0%EC%B9%98\" >3.2.2. DA# Macro\uac00 \uc815\uc0c1\uc801\uc73c\ub85c \ub3d9\uc791\ud558\uc9c0 \uc54a\ub294 \uacbd\uc6b0 \uc870\uce58<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-4'><a class=\"ez-toc-link ez-toc-heading-6\" href=\"https:\/\/prodskill.com\/zh\/da-macro-usage-notes\/#323_Reverse_%EC%A0%95%EB%B3%B4_%EC%88%98%EC%A7%91_SQLOracle%EC%9A%A9\" >3.2.3. Reverse \uc815\ubcf4 \uc218\uc9d1 SQL(Oracle\uc6a9)<\/a><\/li><\/ul><\/li><\/ul><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-7\" href=\"https:\/\/prodskill.com\/zh\/da-macro-usage-notes\/#4_DA_Macro_%EB%8B%A4%EC%9A%B4%EB%A1%9C%EB%93%9C_%ED%96%A5%ED%9B%84_%EC%B6%94%EA%B0%80_%EC%98%88%EC%A0%95_%EA%B8%B0%EB%8A%A5_%EC%9D%BC%EB%9F%AC%EB%91%90%EA%B8%B0\" >4. DA# Macro \ub2e4\uc6b4\ub85c\ub4dc, \ud5a5\ud6c4 \ucd94\uac00 \uc608\uc815 \uae30\ub2a5, \uc77c\ub7ec\ub450\uae30<\/a><ul class='ez-toc-list-level-3' ><li class='ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-8\" href=\"https:\/\/prodskill.com\/zh\/da-macro-usage-notes\/#41_DA_Macro_%EB%8B%A4%EC%9A%B4%EB%A1%9C%EB%93%9C\" >4.1. DA# Macro \ub2e4\uc6b4\ub85c\ub4dc<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-9\" href=\"https:\/\/prodskill.com\/zh\/da-macro-usage-notes\/#42_DA_Macro_%ED%96%A5%ED%9B%84_%EC%B6%94%EA%B0%80_%EC%98%88%EC%A0%95_%EA%B8%B0%EB%8A%A5\" >4.2. DA# Macro \ud5a5\ud6c4 \ucd94\uac00 \uc608\uc815 \uae30\ub2a5<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-10\" href=\"https:\/\/prodskill.com\/zh\/da-macro-usage-notes\/#43_%EC%82%AC%EC%9A%A9%EC%9E%90_%EC%9D%BC%EB%9F%AC%EB%91%90%EA%B8%B0\" >4.3. \uc0ac\uc6a9\uc790 \uc77c\ub7ec\ub450\uae30<\/a><\/li><\/ul><\/li><\/ul><\/nav><\/div>\n<h2 class=\"wp-block-heading\" id=\"3._DA#_Macro_\uc0ac\uc6a9\uc0c1_\uc8fc\uc758\uc0ac\ud56d,_\ucc38\uace0\uc0ac\ud56d\"><span class=\"ez-toc-section\" id=\"3_DA_Macro_%EC%82%AC%EC%9A%A9%EC%83%81_%EC%A3%BC%EC%9D%98%EC%82%AC%ED%95%AD%EC%B0%B8%EA%B3%A0%EC%82%AC%ED%95%AD\"><\/span>3. DA# Macro \uc0ac\uc6a9\uc0c1 \uc8fc\uc758\uc0ac\ud56d\/\ucc38\uace0\uc0ac\ud56d<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"3.1._DA#_Macro_\uc0ac\uc6a9\uc0c1_\uc8fc\uc758\uc0ac\ud56d\"><span class=\"ez-toc-section\" id=\"31_DA_Macro_%EC%82%AC%EC%9A%A9%EC%83%81_%EC%A3%BC%EC%9D%98%EC%82%AC%ED%95%AD\"><\/span>3.1. DA# Macro \uc0ac\uc6a9\uc0c1 \uc8fc\uc758\uc0ac\ud56d<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<ul class=\"wp-block-list\"><li>Entity\/Attribute\uc5d0 \ub300\ud55c Set Macro \uc2e4\ud589 \uc804\uc5d0 \ub300\uc0c1 DA# v5 \ubaa8\ub378 \ud30c\uc77c\uc758 \ubc31\uc5c5\uc744 \uad8c\uace0\ud55c\ub2e4.<\/li><li>\uba54\ubaa8\ub9ac \ubd80\uc871 \uc624\ub958 \ubc29\uc9c0\uc640 \uc131\ub2a5 \ud5a5\uc0c1\uc744 \uc704\ud558\uc5ec Macro\ub0b4\uc5d0\uc11c Undo\ub97c \ube44\ud65c\uc131\ud654\uc2dc\ud0a4\uae30 \ub54c\ubb38\uc774\ub2e4.<\/li><li>UDP \ud56d\ubaa9\uc740 \ud574\ub2f9 \ubaa8\ub378\uc5d0 \ubbf8\ub9ac \uc0dd\uc131\ub418\uc5b4 \uc788\uc5b4\uc57c \ud55c\ub2e4. \ud604\uc7ac \ubc30\ud3ec\ub418\ub294 DA# Macro Version(v2.12)\uc5d0\uc11c\ub294 UDP \ud56d\ubaa9\uc744 \uc0dd\uc131\ud574 \uc8fc\uc9c0\ub294 \uc54a\ub294\ub2e4. UDP \uba85\uc744 \uc798\ubabb \uc785\ub825\ud558\uace0 Macro\ub97c \uc2e4\ud589\uc2dc\ucf1c \uc798\ubabb\ub41c UDP\uac00 \uc0dd\uc131\ub418\ub294 \ubb38\uc81c\ub97c \ubc29\uc9c0\ud558\uae30 \uc704\ud568\uc774\ub2e4. (\ud5a5\ud6c4 version\uc5d0\uc11c \uad6c\ud604 \uc608\uc815)<\/li><li>UDP \ud56d\ubaa9\uc740 \ucd94\uac00\/\uc81c\uac70\/\uc21c\uc11c\ubcc0\uacbd\ucd94\uac00\/\uc81c\uac70\/\uc21c\uc11c\ubcc0\uacbd \uac00\ub2a5\ud558\ub098, \uae30\ubcf8 \ud56d\ubaa9\uc740 \ucd94\uac00\/\uc81c\uac70\/\uc21c\uc11c\ubcc0\uacbd \uae08\uc9c0\uc774\ub2e4.<\/li><\/ul>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"3.2._DA#_Macro_\ucc38\uace0\uc0ac\ud56d\"><span class=\"ez-toc-section\" id=\"32_DA_Macro_%EC%B0%B8%EA%B3%A0%EC%82%AC%ED%95%AD\"><\/span>3.2. DA# Macro \ucc38\uace0\uc0ac\ud56d<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<h4 class=\"wp-block-heading\" id=\"3.2.1._Reverse_\ub3d9\uc2dc_\uc2e4\ud589_\ubc29\ubc95\"><span class=\"ez-toc-section\" id=\"321_Reverse_%EB%8F%99%EC%8B%9C_%EC%8B%A4%ED%96%89_%EB%B0%A9%EB%B2%95\"><\/span>3.2.1. Reverse \ub3d9\uc2dc \uc2e4\ud589 \ubc29\ubc95<span class=\"ez-toc-section-end\"><\/span><\/h4>\n\n\n\n<p>Reverse \uae30\ub2a5\uc740 \uc785\ub825 \ud30c\uc77c\uc5d0 \uc9c0\uc815\ub41c \uc5ec\ub7ec \ubaa8\ub378\uc744 \uc21c\ucc28\uc801\uc73c\ub85c \ucc98\ub9ac\ud560 \uc218 \uc788\ub294\ub370, \uc2dc\uac04\uc774 \ub108\ubb34 \uc624\ub798 \uac78\ub9ac\ub294 \uacbd\uc6b0\ub294 \ubaa8\ub378\ubcc4\ub85c \ud30c\uc77c\uc744 \ub098\ub204\uc5b4 \ub3d9\uc2dc\uc5d0 \ucc98\ub9ac\ud560 \uc218 \uc788\ub2e4.<\/p>\n\n\n\n<p>\ud30c\uc77c\uc744 \ub098\ub20c \ub54c, \u201cModel\u201d \uc2dc\ud2b8\uc5d0\uc11c\ub9cc \ub300\uc0c1 \ubaa8\ub378\uc744 \ub0a8\uaca8\ub450\uba74 \ub41c\ub2e4. \u201cTable\u201d, \u201cColumn\u201d, \u201cFK\u201d \uc2dc\ud2b8\uc5d0 \uc804\uccb4 \ubaa8\ub378\uc5d0 \ub300\ud55c \uc815\ubcf4\uac00 \uc788\ub354\ub77c\ub3c4 \u201cModel\u201d \uc2dc\ud2b8\ub97c \uae30\uc900\uc73c\ub85c Reverse\ub97c \uc2e4\ud589\ud55c\ub2e4.<\/p>\n\n\n\n<p>\ud55c PC\uc5d0\uc11c \ub3d9\uc2dc\uc5d0 \ucc98\ub9ac\ud558\ub824\uba74 \uc5d1\uc140 instance\ub97c \uc5ec\ub7ec \uac1c \uc2e4\ud589\ud558\uace0 \uac01 instance\uc5d0\uc11c \ucc98\ub9ac\ud560 \ubaa8\ub378 \ud30c\uc77c\uc744 \uc9c0\uc815\ud558\uc5ec \uc2e4\ud589\ud558\uba74 \ub41c\ub2e4.<\/p>\n\n\n\n<p>(\ucc38\uace0: <a href=\"https:\/\/prodskill.com\/ko\/naver-korean-english-dictionary-search-tool-overview\/#32_%EC%97%AC%EB%9F%AC%EA%B0%9C_%EC%97%91%EC%85%80_process_%EC%8B%A4%ED%96%89_%EB%B0%A9%EB%B2%95\">\ub124\uc774\ubc84 \uad6d\uc5b4\uc0ac\uc804\/\uc601\uc5b4\uc0ac\uc804 \uac80\uc0c9 \ub3c4\uad6c \uac1c\uc694 &#8211; 3.2. \uc5ec\ub7ec\uac1c \uc5d1\uc140 process \uc2e4\ud589 \ubc29\ubc95<\/a>)<\/p>\n\n\n\n<p>\ud558\uc9c0\ub9cc \ud55c PC\uc5d0\uc11c \ub3d9\uc2dc\uc5d0 \ucc98\ub9ac\ud558\ub294 \ubc29\ubc95\uc740 CPU \uc790\uc6d0 \uacbd\ud569\uc73c\ub85c \uae30\ub300\ud55c \uac83\ubcf4\ub2e4\ub294 \ube60\ub974\uac8c \ucc98\ub9ac\ub418\uc9c0 \uc54a\ub294\ub2e4. \uc5ec\ub7ec PC\uc5d0 \ub098\ub204\uc5b4 \uc2e4\ud589\ud558\uba74 \ub3d9\uc2dc\uc5d0 \ube60\ub974\uac8c \ucc98\ub9ac\ud560 \uc218 \uc788\ub2e4.<\/p>\n\n\n\n<h4 class=\"wp-block-heading\" id=\"3.2.2._DA#_Macro\uac00_\uc815\uc0c1\uc801\uc73c\ub85c_\ub3d9\uc791\ud558\uc9c0_\uc54a\ub294_\uacbd\uc6b0_\uc870\uce58\"><span class=\"ez-toc-section\" id=\"322_DA_Macro%EA%B0%80_%EC%A0%95%EC%83%81%EC%A0%81%EC%9C%BC%EB%A1%9C_%EB%8F%99%EC%9E%91%ED%95%98%EC%A7%80_%EC%95%8A%EB%8A%94_%EA%B2%BD%EC%9A%B0_%EC%A1%B0%EC%B9%98\"><\/span>3.2.2. DA# Macro\uac00 \uc815\uc0c1\uc801\uc73c\ub85c \ub3d9\uc791\ud558\uc9c0 \uc54a\ub294 \uacbd\uc6b0 \uc870\uce58<span class=\"ez-toc-section-end\"><\/span><\/h4>\n\n\n\n<p>\ub2e4\uc74c\uacfc \uac19\uc740 \ud604\uc0c1\uc774 \ubc1c\uc0dd\ud560 \uacbd\uc6b0 \uc870\uce58 \ubc29\ubc95\uc774\ub2e4.<\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>\ud604\uc0c1<ul><li>\uc791\uc5c5\uad00\ub9ac\uc790\uc5d0\uc11c \ud655\uc778\ud574 \ubcf4\uc558\uc744 \ub54c, DA# v5(Modeler5.exe)\uac00 \uc2e4\ud589\ub418\uc5b4 \uc788\uace0(Instance #1), \ubaa8\ub378\uc744 \ud558\ub098 \uc5f4\uace0 \uc788\ub294 \uc0c1\ud0dc\uc5d0\uc11c,<\/li><li>DA# Macro\uc5d0\uc11c &#8220;\uc5f4\ub9b0\ubaa8\ub378 \ucd94\uac00&#8221; \ubc84\ud2bc\uc744 \ud074\ub9ad\ud558\uba74 Modeler5.exe \ud504\ub85c\uc138\uc2a4\uac00 \uc0c8\ub85c \uc0dd\uc131\ub418\uba74\uc11c (Instance #2) &#8220;\uc5f4\ub9b0 \ubaa8\ub378\uc774 \uc5c6\uc2b5\ub2c8\ub2e4&#8221;\ub294 \uba54\uc2dc\uc9c0\uac00 \ucd9c\ub825\ub418\uace0,<\/li><li>\uae30\uc874 Instance #1\uc5d0\uc11c \uc5f4\uace0 \uc788\ub294 \ubaa8\ub378 \uc815\ubcf4\ub97c \uac00\uc838\uc624\uc9c0 \ubabb\ud558\ub294 \ud604\uc0c1<\/li><\/ul><\/li><li>\uc6d0\uc778<ul><li>DA#\uc744 \uc124\uce58\ud560 \ub54c Registry\uc5d0 \uc815\ubcf4\ub97c \uc81c\ub300\ub85c \ubc18\uc601\ud558\uc9c0 \ubabb\ud558\ub294 \uacbd\uc6b0 \ubc1c\uc0dd\ud55c\ub2e4.<\/li><li>\uc774 \ud604\uc0c1\uc774 \ubc1c\uc0dd\ud558\uba74 DA#\uc744 \uc0ac\uc6a9\ud558\ub294 \ub370\ub294 \uc544\ubb34 \uc9c0\uc7a5\uc774 \uc5c6\uc73c\ub098 API\ub85c DA#\uc744 \uc2e4\ud589\ud558\ub294 \uacbd\uc6b0\uc5d0 \uc815\uc0c1\uc801\uc73c\ub85c \uc2e4\ud589\ub418\uc9c0 \uc54a\ub294\ub2e4.<\/li><\/ul><\/li><li>\uc870\uce58 \ubc29\ubc95<ul><li><font color=\"red\">\uba85\ub839 \ud504\ub86c\ud504\ud2b8\ub97c \uad00\ub9ac\uc790 \ubaa8\ub4dc\ub85c \uc2e4\ud589(\uc911\uc694!!!)<\/font>\ud558\uace0 \uc544\ub798 \uba85\ub839\uc5b4\ub97c \uc785\ub825\ud558\uc5ec DA# v5 \uac1d\uccb4\ub97c \uc7ac\ub4f1\ub85d\ud55c\ub2e4.<\/li><li>DA#\uc774 \uae30\ubcf8 \uacbd\ub85c\uc640 \ub2e4\ub978 \uacbd\ub85c\uc5d0 \uc124\uce58\ub418\uc5b4 \uc788\ub294 \uacbd\uc6b0 \ud574\ub2f9 \uacbd\ub85c\ub85c \uc774\ub3d9\ud558\uc5ec &#8220;RegisterServer.bat&#8221; \uba85\ub839\uc744 \uc2e4\ud589\ud55c\ub2e4.<\/li><\/ul><\/li><\/ul>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"generic\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">cd \"C:\\Program Files (x86)\\ENCORE\\DATAWARE_DA5\\DA Modeler\"\nRegisterServer.bat<\/pre>\n\n\n\n<p>\uc704 \uba85\ub839\uc5b4\ub97c \uc2e4\ud589 \ud6c4 DA# Macro\ub97c \ub2e4\uc2dc \uc2e4\ud589\ud558\uc5ec \ube44\uc815\uc0c1 \ud604\uc0c1\uc774 \ud574\uacb0\ub418\uc5c8\ub294\uc9c0 \ud655\uc778\ud55c\ub2e4.<\/p>\n\n\n\n<h4 class=\"wp-block-heading\" id=\"3.2.3._Reverse_\uc815\ubcf4_\uc218\uc9d1_SQL(Oracle\uc6a9)\"><span class=\"ez-toc-section\" id=\"323_Reverse_%EC%A0%95%EB%B3%B4_%EC%88%98%EC%A7%91_SQLOracle%EC%9A%A9\"><\/span>3.2.3. Reverse \uc815\ubcf4 \uc218\uc9d1 SQL(Oracle\uc6a9)<span class=\"ez-toc-section-end\"><\/span><\/h4>\n\n\n\n<p>Oracle Database\uc5d0\uc11c Reverse\uc5d0 \ud544\uc694\ud55c Table, Column, FK \ubaa9\ub85d\uc744 \uc218\uc9d1\ud558\ub294 SQL \uc608\uc2dc\uc774\ub2e4.<\/p>\n\n\n\n<p>\uc774 SQL\uc744 \uc2e4\ud589\ud558\ub824\uba74 &#8220;SELECT ANY DICTIONARY&#8221; \uad8c\ud55c\uc774 \ud544\uc694\ud558\ub2e4.<\/p>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"oracledb\" data-enlighter-theme=\"\" data-enlighter-highlight=\"32,63-78,80-95,116,158-159,179\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">-- TABLE \ubaa9\ub85d\nSELECT ROW_NUMBER() OVER(ORDER BY A.OWNER, A.TABLE_NAME) AS RNO\n      ,'\ubaa8\ub3781' AS \ubaa8\ub378\uba85, '\uc8fc\uc81c\uc601\uc5ed1' AS \uc8fc\uc81c\uc601\uc5ed\uba85, '\uadf8\ub8f91' AS \uc5d4\ud130\ud2f0\uadf8\ub8f9\uba85\n      ,CASE\n         WHEN INSTR(T.COMMENTS, CHR(10)) > 0 THEN A.TABLE_NAME -- COMMENT\uc5d0 \ud589\ubd84\ub9ac \ubb38\uc790\uac00 \uc788\ub294 \uacbd\uc6b0 \uc5d4\ud130\ud2f0\uba85 \ubd80\uc801\ud569\ud558\uc5ec \ud14c\uc774\ube14\uba85\uc73c\ub85c \uc0ac\uc6a9\n         WHEN T.COMMENTS IS NOT NULL THEN T.COMMENTS\n         ELSE A.TABLE_NAME\n       END AS \uc5d4\ud130\ud2f0\uba85\n      ,A.TABLE_NAME AS \ud14c\uc774\ube14\uba85\n      ,TRIM(TO_CHAR(A.NUM_ROWS, '9,999,999,999,999')) AS \ub3d9\uc758\uc5b4 -- \ub3d9\uc758\uc5b4\uc5d0 \ucd1d\uac74\uc218\ub97c \ubb38\uc790\ud615\uc73c\ub85c \ucd94\ucd9c(comma \ud3ec\ud568)\n      ,A.TABLE_NAME AS \ubcf4\uc870\uba85\n      ,A.OWNER AS DBOWNER\n      ,NULL AS \ubd84\ub958, NULL AS \"LEVEL\", NULL AS \ub2e8\uacc4, NULL AS \uc720\ud615, NULL AS \ud45c\uc900\ud654, NULL AS \uc0c1\ud0dc, NULL AS \ubc1c\uc0dd\uc8fc\uae30, NULL AS \uc6d4\uac04\ubc1c\uc0dd\ub7c9, NULL AS \"\ubcf4\uc874\uae30\ud55c(\uc6d4)\"\n      ,A.NUM_ROWS \ucd1d\uac74\uc218\n      ,T.COMMENTS AS \uc815\uc758\n      ,NULL AS \ub370\uc774\ud130\ucc98\ub9ac\ud615\ud0dc, NULL AS \ud2b9\uc774\uc0ac\ud56d, NULL AS Note, NULL AS TAG\n      ,O.CREATED, O.LAST_DDL_TIME, A.LAST_ANALYZED, A.TEMPORARY\n      ,'[COMMENT]: ' || T.COMMENTS || CHR(13) || CHR(10) ||\n       '[NUM_ROWS]: ' || TRIM(TO_CHAR(A.NUM_ROWS, '9,999,999,999,999')) || CHR(13) || CHR(10) ||\n       '[CREATED]: ' || TO_CHAR(O.CREATED, 'YYYY-MM-DD HH24:MI:SS') || CHR(13) || CHR(10) ||\n       '[LAST_DDL_TIME]: ' || TO_CHAR(O.LAST_DDL_TIME, 'YYYY-MM-DD HH24:MI:SS') || CHR(13) || CHR(10) ||\n       '[LAST_ANALYZED]: ' || TO_CHAR(A.LAST_ANALYZED, 'YYYY-MM-DD HH24:MI:SS') AS \uc815\uc7582\n  FROM DBA_TABLES A INNER JOIN DBA_OBJECTS O\n         ON   ( A.OWNER = O.OWNER\n            AND A.TABLE_NAME = O.OBJECT_NAME\n            AND O.OBJECT_TYPE = 'TABLE')\n       LEFT OUTER JOIN DBA_TAB_COMMENTS T\n         ON   ( A.OWNER = T.OWNER\n            AND A.TABLE_NAME = T.TABLE_NAME )\n WHERE 1=1\n   AND A.TABLE_NAME NOT LIKE 'BIN$%'\n   AND A.OWNER IN ('OWNER1', 'OWNER2')  -- \ud574\ub2f9 OWNER \uc9c0\uc815\n--   AND A.TABLE_NAME = 'TABLE_NAME' -- \ud2b9\uc815 TABLE\ub9cc \ud3ec\ud568 \ub610\ub294 \uc81c\uc678\n ORDER  BY A.OWNER, A.TABLE_NAME\n;\n\n-- COLUMN \ubaa9\ub85d\nWITH WC AS (\nSELECT A.OWNER, A.TABLE_NAME, A.COLUMN_NAME, A.COLUMN_ID, A.DATA_TYPE\n      ,CASE WHEN A.DATA_TYPE= 'NUMBER' AND A.DATA_SCALE > 0 THEN A.DATA_PRECISION||','||A.DATA_SCALE\n            WHEN A.DATA_TYPE= 'NUMBER' AND A.DATA_SCALE = 0 THEN TO_CHAR(A.DATA_PRECISION)\n            WHEN A.DATA_TYPE= 'NUMBER' AND A.DATA_SCALE IS NULL THEN ''\n            WHEN A.DATA_TYPE IN ('DATE','TIMESTAMP','BLOB', 'CLOB')  THEN NULL\n            WHEN A.DATA_TYPE LIKE 'TIMESTAMP%' THEN NULL\n            ELSE TO_CHAR(A.DATA_LENGTH)\n       END AS DATA_LENGTH\n      ,A.DATA_PRECISION, A.DATA_SCALE\n      ,DECODE(A.NULLABLE, 'Y','N','Y') AS NOT_NULL\n      ,DECODE(B.COLUMN_NAME, NULL, 'N', 'Y') PRI_KEY\n      ,B.POSITION PK_POSITION\n      ,T.COMMENTS\n      ,A.DEFAULT_LENGTH\n--      ,A.DATA_DEFAULT\n      ,CASE\n         WHEN A.DEFAULT_LENGTH IS NULL THEN NULL\n         ELSE EXTRACTVALUE\n           ( DBMS_XMLGEN.GETXMLTYPE\n             ( 'SELECT DATA_DEFAULT FROM DBA_TAB_COLUMNS WHERE OWNER = ''' || A.OWNER || ''' AND TABLE_NAME = ''' || A.TABLE_NAME || ''' AND COLUMN_NAME = ''' || A.COLUMN_NAME || '''' )\n           , '\/\/text()' )\n       END AS DATA_DEFAULT\n      ,A.LAST_ANALYZED, A.NUM_DISTINCT\n--      ,A.LOW_VALUE\n      ,DECODE(DATA_TYPE\n              ,'NUMBER'       ,TO_CHAR(UTL_RAW.CAST_TO_NUMBER(LOW_VALUE))\n              ,'VARCHAR2'     ,TO_SINGLE_BYTE(UTL_RAW.CAST_TO_VARCHAR2(LOW_VALUE))\n              ,'CHAR'         ,TO_SINGLE_BYTE(UTL_RAW.CAST_TO_VARCHAR2(LOW_VALUE))\n              ,'NVARCHAR2'    ,TO_CHAR(UTL_RAW.CAST_TO_NVARCHAR2(LOW_VALUE))\n              ,'BINARY_DOUBLE',TO_CHAR(UTL_RAW.CAST_TO_BINARY_DOUBLE(LOW_VALUE))\n              ,'BINARY_FLOAT' ,TO_CHAR(UTL_RAW.CAST_TO_BINARY_FLOAT(LOW_VALUE))\n              ,'DATE',DECODE(LOW_VALUE, NULL, NULL, TO_CHAR(1780+TO_NUMBER(SUBSTR(LOW_VALUE,1,2),'XX')\n                     +TO_NUMBER(SUBSTR(LOW_VALUE,3,2),'XX'))||'-'\n                   ||TRIM(TO_CHAR(TO_NUMBER(SUBSTR(LOW_VALUE,5,2), 'XX'), '00'))||'-'\n                   ||TRIM(TO_CHAR(TO_NUMBER(SUBSTR(LOW_VALUE,7,2), 'XX'), '00'))||' '\n                   ||TRIM(TO_CHAR(TO_NUMBER(SUBSTR(LOW_VALUE,9,2),'XX')-1, '00'))||':'\n                   ||TRIM(TO_CHAR(TO_NUMBER(SUBSTR(LOW_VALUE,11,2),'XX')-1, '00'))||':'\n                   ||TRIM(TO_CHAR(TO_NUMBER(SUBSTR(LOW_VALUE,13,2),'XX')-1, '00')))\n              ,LOW_VALUE\n              ) LOW_VALUE\n--      ,A.HIGH_VALUE\n      ,DECODE(DATA_TYPE\n              ,'NUMBER'       ,TO_CHAR(UTL_RAW.CAST_TO_NUMBER(HIGH_VALUE))\n              ,'VARCHAR2'     ,TO_SINGLE_BYTE(UTL_RAW.CAST_TO_VARCHAR2(HIGH_VALUE))\n              ,'CHAR'         ,TO_SINGLE_BYTE(UTL_RAW.CAST_TO_VARCHAR2(HIGH_VALUE))\n              ,'NVARCHAR2'    ,TO_CHAR(UTL_RAW.CAST_TO_NVARCHAR2(HIGH_VALUE))\n              ,'BINARY_DOUBLE',TO_CHAR(UTL_RAW.CAST_TO_BINARY_DOUBLE(HIGH_VALUE))\n              ,'BINARY_FLOAT' ,TO_CHAR(UTL_RAW.CAST_TO_BINARY_FLOAT(HIGH_VALUE))\n              ,'DATE',DECODE(HIGH_VALUE, NULL, NULL, TO_CHAR(1780+TO_NUMBER(SUBSTR(HIGH_VALUE,1,2),'XX')\n                     +TO_NUMBER(SUBSTR(HIGH_VALUE,3,2),'XX'))||'-'\n                   ||TRIM(TO_CHAR(TO_NUMBER(SUBSTR(HIGH_VALUE,5,2), 'XX'), '00'))||'-'\n                   ||TRIM(TO_CHAR(TO_NUMBER(SUBSTR(HIGH_VALUE,7,2), 'XX'), '00'))||' '\n                   ||TRIM(TO_CHAR(TO_NUMBER(SUBSTR(HIGH_VALUE,9,2),'XX')-1, '00'))||':'\n                   ||TRIM(TO_CHAR(TO_NUMBER(SUBSTR(HIGH_VALUE,11,2),'XX')-1, '00'))||':'\n                   ||TRIM(TO_CHAR(TO_NUMBER(SUBSTR(HIGH_VALUE,13,2),'XX')-1, '00')))\n              ,HIGH_VALUE\n               ) HIGH_VALUE\n      ,TB.NUM_ROWS, A.NUM_NULLS, A.CHAR_USED, A.AVG_COL_LEN\n  FROM DBA_TABLES TB LEFT OUTER JOIN DBA_TAB_COLUMNS A\n         ON (TB.OWNER = A.OWNER\n         AND TB.TABLE_NAME = A.TABLE_NAME)\n       LEFT OUTER JOIN\n       (SELECT C.OWNER, C.TABLE_NAME, C.COLUMN_NAME, C.POSITION\n          FROM DBA_CONS_COLUMNS C INNER JOIN DBA_CONSTRAINTS S\n                 ON  ( C.OWNER = S.OWNER\n                   AND C.TABLE_NAME = S.TABLE_NAME\n                   AND C.CONSTRAINT_NAME = S.CONSTRAINT_NAME )\n         WHERE S.CONSTRAINT_TYPE = 'P'\n       ) B\n         ON  ( A.OWNER = B.OWNER\n           AND A.TABLE_NAME = B.TABLE_NAME\n           AND A.COLUMN_NAME = B.COLUMN_NAME )\n       LEFT OUTER JOIN ALL_COL_COMMENTS T\n         ON  ( T.OWNER = A.OWNER\n           AND T.TABLE_NAME = A.TABLE_NAME\n           AND T.COLUMN_NAME = A.COLUMN_NAME )\n WHERE 1=1\n   AND A.OWNER IN ('OWNER1', 'OWNER2')  -- \ud574\ub2f9 OWNER \uc9c0\uc815\n   AND A.TABLE_NAME NOT LIKE 'BIN$%'\n   AND NOT EXISTS ( SELECT 'X'  -- View column \uc81c\uc678 \uc870\uac74\n                      FROM DBA_VIEWS V\n                     WHERE V.OWNER = A.OWNER\n                       AND V.VIEW_NAME = A.TABLE_NAME )\n   --AND A.TABLE_NAME = 'TABLE_NAME'\n-- ORDER BY OWNER, TABLE_NAME, COLUMN_ID\n)\nSELECT ROW_NUMBER() OVER(ORDER BY OWNER, TABLE_NAME, COLUMN_ID) AS RNO\n--      ,ROW_NUMBER() OVER(PARTITION BY OWNER, TABLE_NAME ORDER BY COLUMN_ID) AS COLNO\n      ,'\ubaa8\ub3781' AS \ubaa8\ub378\uba85\n      ,'' AS \uc5d4\ud130\ud2f0\uba85\n      ,CASE\n         WHEN INSTR(COMMENTS, CHR(10)) > 0 THEN COLUMN_NAME -- COMMENT\uc5d0 \ud589\ubd84\ub9ac \ubb38\uc790\uac00 \uc788\ub294 \uacbd\uc6b0 \uc18d\uc131\uba85 \ubd80\uc801\ud569\ud558\uc5ec \uceec\ub7fc\uba85\uc73c\ub85c \uc0ac\uc6a9\n         WHEN COMMENTS IS NOT NULL THEN COMMENTS\n         ELSE COLUMN_NAME\n       END AS \uc18d\uc131\uba85\n      ,TABLE_NAME AS \ud14c\uc774\ube14\uba85\n      ,COLUMN_NAME AS \uceec\ub7fc\uba85\n      ,COMMENTS AS \uc815\uc758\n      ,COLUMN_NAME AS \ubcf4\uc870\uba85\n      ,COLUMN_NAME AS \ub3d9\uc758\uc5b4\n      ,TABLE_NAME AS Reverse\ud14c\uc774\ube14\uba85\n      ,COLUMN_NAME AS Reverse\uceec\ub7fc\uba85\n      ,DATA_TYPE AS ReverseType\n      ,DATA_LENGTH AS ReverseLENGTH\n      ,PRI_KEY AS PK\n      ,NOT_NULL AS NOTNULL\n      ,NULL AS \uc720\ud615\n      ,DATA_TYPE AS \ub370\uc774\ud130\ud0c0\uc785\n      ,DATA_PRECISION AS \uae38\uc774\n      ,DATA_SCALE AS \uc18c\uc218\uc810\n      ,DATA_DEFAULT AS \uae30\ubcf8\uac12\n      ,NULL AS \uae30\ubcf8\uac12, NULL AS \ub3c4\uba54\uc778, NULL AS \"FK\", NULL AS \ud575\uc2ec\uc18d\uc131\uc5ec\ubd80, NULL AS \ubcf8\uc9c8\uc2dd\ubcc4\uc790\uc5ec\ubd80\n      ,NULL AS \ubcf4\uc870\uc2dd\ubcc4\uc790\uc5ec\ubd80, NULL AS \ud45c\uc900\ub3d9\uae30\ud654\uc5ec\ubd80, NULL AS \ube44\uc0c1\uc18d\uc5ec\ubd80, NULL AS \ud45c\uc900\ud654\n      ,NULL AS \uc815\ubcf4\ubcf4\ud638\uc5ec\ubd80, NULL AS \uc815\ubcf4\ubcf4\ud638\ub4f1\uae09, NULL AS \uc554\ud638\ud654\uc5ec\ubd80, NULL AS \uc2a4\ud06c\ub7a8\ube14\n      ,'[COMMENT]: ' || COMMENTS || CHR(13) || CHR(10) ||\n       '[NUM_ROWS]: ' || TRIM(TO_CHAR(NUM_ROWS, '9,999,999,999,999')) || CHR(13) || CHR(10) ||\n       '[NUM_DISTINCT]: ' || TRIM(TO_CHAR(NUM_DISTINCT, '9,999,999,999,999')) || CHR(13) || CHR(10) ||\n       '[NUM_NULLS]: ' || TRIM(TO_CHAR(NUM_NULLS, '9,999,999,999,999')) || CHR(13) || CHR(10) ||\n       '[NULL%] : ' || DECODE(NVL(NUM_ROWS, 0), 0, 0, ROUND(NUM_NULLS \/ NUM_ROWS, 5) * 100) || '%' || CHR(13) || CHR(10) ||\n       '[MIN_VALUE]: ' || LOW_VALUE || CHR(13) || CHR(10) ||\n       '[MAX_VALUE]: ' || HIGH_VALUE  AS \uc815\uc7582\n--      ,WC.*\n  FROM WC\n WHERE NUM_NULLS > 0\n ORDER BY OWNER, TABLE_NAME, COLUMN_ID\n;\n\n-- FK \ubaa9\ub85d\nWITH WFK AS (\nSELECT DISTINCT\n       C2.OWNER AS P_OWNER\n      ,C2.TABLE_NAME P_TABLE_NAME\n      ,LISTAGG (C2.COLUMN_NAME, ',') WITHIN GROUP (ORDER BY C2.POSITION)\n         OVER ( PARTITION BY C1.OWNER, C1.TABLE_NAME, C1.CONSTRAINT_NAME, C2.OWNER, C2.TABLE_NAME) AS P_COLUMN_LIST\n      ,C1.OWNER AS C_OWNER\n      ,C1.TABLE_NAME AS C_TABLE_NAME\n      ,C1.CONSTRAINT_NAME AS C_CONSTRAINT_NAME\n  FROM DBA_CONSTRAINTS C1 INNER JOIN DBA_CONS_COLUMNS C2\n         ON (C1.R_CONSTRAINT_NAME = C2.CONSTRAINT_NAME\n         AND C1.R_OWNER = C2.OWNER)\n WHERE C1.OWNER IN ('OWNER1', 'OWNER2')  -- \ud574\ub2f9 DB\uc758 \ud14c\uc774\ube14 OWNER \uc9c0\uc815\n   AND C1.CONSTRAINT_TYPE = 'R'\n ORDER BY C2.OWNER, C2.TABLE_NAME\n)\nSELECT '\ubaa8\ub3781' AS \ubaa8\ub378\uba85\n      ,P_TABLE_NAME AS \ubd80\ubaa8\uc5d4\ud130\ud2f0\uba85\n      ,P_TABLE_NAME AS \ubd80\ubaa8\ud14c\uc774\ube14\uba85\n      ,C_TABLE_NAME AS \uc790\uc2dd\uc5d4\ud130\ud2f0\uba85\n      ,C_TABLE_NAME AS \uc790\uc2dd\ud14c\uc774\ube14\uba85\n      ,P_TABLE_NAME || '->' || C_TABLE_NAME AS \uad00\uacc4\uba85\n      ,NULL AS \uc815\uc758, NULL AS \uad00\uacc4\uc720\ud615, NULL AS \uae30\uc218\uc131, NULL AS \uc120\ud0dd\uc131, NULL AS \uc2dd\ubcc4\uc131\n      ,NULL AS \ubd80\ubaa8\uc5d4\ud130\ud2f0\uad00\uacc4\ub3d9\uc0ac, NULL AS \uc790\uc2dd\uc5d4\ud130\ud2f0\uad00\uacc4\ub3d9\uc0ac\n  FROM WFK\n;<\/pre>\n\n\n\n<p>\uc704 SQL \uc0ac\uc6a9 \uc2dc \ub2e4\uc74c \ub0b4\uc6a9\uc744 \ucc38\uace0\ud55c\ub2e4.<\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>\ub300\uc0c1 Owner(Schema)\ub97c \ud655\uc778\ud558\uace0 \uc218\uc815\ud55c\ub2e4. (32, 116, 179 \ud589)<\/li><li>Table\uc758 \uc815\uc758\ub97c Comment\ub85c \uc9c0\uc815(15\ud589)\ud560\uc9c0, \uc5ec\ub7ec column\uc744 \ucde8\ud569\ud55c \uac12\uc73c\ub85c \uc9c0\uc815(18~22\ud589)\ud560\uc9c0 \uc120\ud0dd\ud55c\ub2e4.<\/li><li>Column\uc758 \uc815\uc758\uc5d0\ub294 Oracle\uc758 \ud1b5\uacc4\uc815\ubcf4\ub97c \ud65c\uc6a9\ud558\uc5ec \ub2e4\uc74c \uc815\ubcf4\ub97c \ud3ec\ud568\ud558\ub3c4\ub85d \ucd94\ucd9c\ud55c\ub2e4.<ul><li>COMMENT: Column coment<\/li><li>NUM_ROWS: Table Row count<\/li><li>NUM_DISTINCT: \uc911\ubcf5\uc744 \uc81c\uac70\ud55c \uac12\uc758 \uc218<\/li><li>NUM_NULLS: \ud574\ub2f9 Column\uc758 \uac12\uc774 NULL\uc778 Row count<\/li><li>NULL%: (NUM_NULLS \/ NUM_ROWS) * 100 \uc73c\ub85c \uacc4\uc0b0\ud55c \uc804\uccb4 Row \uc911 Null\uc778 Row\uc758 \ube44\uc728<\/li><li>MIN_VALUE: \ud574\ub2f9 Column\uc758 \ucd5c\uc18c\uac12 (DBA_TAB_COLUMNS.LOW_VALUE \uc5d0\uc11c DATA_TYPE\uc5d0 \ub530\ub77c \ucd94\ucd9c)<\/li><li>MAX_VALUE: \ud574\ub2f9 Column\uc758 \ucd5c\ub300\uac12 (DBA_TAB_COLUMNS.HIGH_VALUE \uc5d0\uc11c DATA_TYPE\uc5d0 \ub530\ub77c \ucd94\ucd9c)<\/li><\/ul><\/li><li>Column\uc758 MIN_VALUE, MAX_VALUE\ub294 \ub2e4\uc74c \ub0b4\uc6a9\uc744 \ucc38\uace0\ud55c\ub2e4. (63~78, 80~95\ud589)<ul><li>ORA-29275: partial multibyte character (\ubd80\ubd84 \ub2e4\uc911 \ubc14\uc774\ud2b8 \ubb38\uc790) \uc624\ub958\uac00 \ubc1c\uc0dd\ud55c\ub2e4\uba74, to_single_byte \ud568\uc218\ub97c \uc801\uc6a9\ud574 \ubcf4\uace0, \uadf8\ub798\ub3c4 \uc624\ub958\uac00 \ubc1c\uc0dd\ud55c\ub2e4\uba74 \ucd5c\ub300, \ucd5c\uc18c\uac12\uc740 \uc81c\uc678\ud558\uace0 \ucd94\ucd9c\ud55c\ub2e4.<\/li><li>\ucd5c\ub300, \ucd5c\uc18c\uac12\uc744 \uc81c\uc678\ud558\uace0 \ucd94\ucd9c\ud558\ub294 \uacbd\uc6b0 Column \uc815\uc758 \ub0b4\uc6a9(158, 159\ud589)\ub3c4 \ud568\uaed8 \uc218\uc815\ud55c\ub2e4.<\/li><\/ul><\/li><li>SQL\uc744 \uc2e4\ud589\ud560 \uc218 \uc788\ub294 \uacc4\uc815, \uc811\uc18d\uc815\ubcf4, \uad8c\ud55c\uc744 \uc5bb\uae30\uae4c\uc9c0 \uc2dc\uac04\uc774 \uc624\ub798 \uac78\ub9ac\uac70\ub098 \ubd88\uac00\ub2a5\ud55c \uacbd\uc6b0\ub294 DBA \ub610\ub294 IT\uc6b4\uc601\uc790\uc5d0\uac8c \ud574\ub2f9 SQL\uc744 \uc804\ub2ec\ud558\uace0 \uc2e4\ud589\uacb0\uacfc\ub97c \uc5d1\uc140\ud30c\uc77c\ub85c \uc800\uc7a5\ud574\uc11c \ud68c\uc2e0 \uc694\uccad\ud55c\ub2e4.<\/li><li>SQL \uc138 \uac1c\ub97c \uc2e4\ud589\ud55c \uacb0\uacfc\ub294 \uc138 \uac1c\uc758 \ud30c\uc77c(\uac01 \ud30c\uc77c\uc5d0 \uc2dc\ud2b8 \ud55c \uac1c)\ub85c \ubc1b\uc544\ub3c4 \ub418\uace0, \ud558\ub098\uc758 \ud30c\uc77c(\uc2dc\ud2b8 \uc138 \uac1c)\ub85c \ubc1b\uc544\ub3c4 \ub41c\ub2e4.<\/li><\/ul>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"4._DA#_Macro_\ub2e4\uc6b4\ub85c\ub4dc,_\ud5a5\ud6c4_\ucd94\uac00_\uc608\uc815_\uae30\ub2a5,_\uc77c\ub7ec\ub450\uae30\"><span class=\"ez-toc-section\" id=\"4_DA_Macro_%EB%8B%A4%EC%9A%B4%EB%A1%9C%EB%93%9C_%ED%96%A5%ED%9B%84_%EC%B6%94%EA%B0%80_%EC%98%88%EC%A0%95_%EA%B8%B0%EB%8A%A5_%EC%9D%BC%EB%9F%AC%EB%91%90%EA%B8%B0\"><\/span>4. DA# Macro \ub2e4\uc6b4\ub85c\ub4dc, \ud5a5\ud6c4 \ucd94\uac00 \uc608\uc815 \uae30\ub2a5, \uc77c\ub7ec\ub450\uae30<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"4.1._DA#_Macro_\ub2e4\uc6b4\ub85c\ub4dc\"><span class=\"ez-toc-section\" id=\"41_DA_Macro_%EB%8B%A4%EC%9A%B4%EB%A1%9C%EB%93%9C\"><\/span>4.1. DA# Macro \ub2e4\uc6b4\ub85c\ub4dc<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>\uc544\ub798 github repository\uc5d0\uc11c \ud655\uc778\ud560 \uc218 \uc788\ub2e4.<\/p>\n\n\n\n<p><a href=\"https:\/\/github.com\/DAToolset\/DA-Macro\" target=\"_blank\" rel=\"noreferrer noopener\">https:\/\/github.com\/DAToolset\/DA-Macro<\/a><\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><a href=\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-236.png\"><img loading=\"lazy\" decoding=\"async\" width=\"834\" height=\"453\" src=\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-236.png\" alt=\"DA# Macro GitHub Repository\" class=\"wp-image-11724\" srcset=\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-236.png 834w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-236-300x163.png 300w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-236-768x417.png 768w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-236-18x10.png 18w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-236-24x13.png 24w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-236-36x20.png 36w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-236-48x26.png 48w\" sizes=\"auto, (max-width: 834px) 100vw, 834px\" \/><\/a><figcaption>DA# Macro GitHub Repository<\/figcaption><\/figure>\n<\/div>\n\n\n<p>\ub610\ub294, \uc774 URL\uc5d0\uc11c \uc9c1\uc811 \ub2e4\uc6b4\ub85c\ub4dc\ud560 \uc218 \uc788\ub2e4.<\/p>\n\n\n\n<p><a href=\"https:\/\/github.com\/DAToolset\/DA-Macro\/raw\/main\/DA%23%20Macro_v2.12_20210814.xlsm\" target=\"_blank\" rel=\"noreferrer noopener\">https:\/\/github.com\/DAToolset\/DA-Macro\/raw\/main\/DA%23%20Macro_v2.12_20210814.xlsm<\/a><\/p>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"4.2._DA#_Macro_\ud5a5\ud6c4_\ucd94\uac00_\uc608\uc815_\uae30\ub2a5\"><span class=\"ez-toc-section\" id=\"42_DA_Macro_%ED%96%A5%ED%9B%84_%EC%B6%94%EA%B0%80_%EC%98%88%EC%A0%95_%EA%B8%B0%EB%8A%A5\"><\/span>4.2. DA# Macro \ud5a5\ud6c4 \ucd94\uac00 \uc608\uc815 \uae30\ub2a5<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>DA# Macro\ub294 \ud604\uc7ac \uad6c\ud604\ub418\uc5b4 \uc788\ub294 \uae30\ub2a5 \uc678\uc5d0 \ub2e4\uc74c \uae30\ub2a5\uc744 \ucd94\uac00\ud560 \uc608\uc815\uc774\ub2e4.<\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>Subtype \uc18d\uc131 Get\/Set: Subtype \ub0b4\uc5d0 \uad00\ub9ac\ub418\ub294 \uc18d\uc131 Get\/Set (\uacc4\uce35 \uc18d\uc131 \ud3ec\ud568)<\/li><li>AR \ubaa8\ub378 Get\/Set: AR \ubaa8\ub378\uc744 Treeview\ub85c \uc870\ud68c\ud558\uace0 \uc5ec\ub7ec \ubaa8\ub378\uc744 \uc120\ud0dd\ud558\uc5ec Get\/Set<\/li><li>Relationship Get\/Set: \uc5d4\ud130\ud2f0 \uac04 Relationship Get\/Set<\/li><li>\uc5d4\ud130\ud2f0 \ubc30\uce58 \ubc29\ubc95 \ud655\uc7a5<\/li><\/ul>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"4.3._\uc0ac\uc6a9\uc790_\uc77c\ub7ec\ub450\uae30\"><span class=\"ez-toc-section\" id=\"43_%EC%82%AC%EC%9A%A9%EC%9E%90_%EC%9D%BC%EB%9F%AC%EB%91%90%EA%B8%B0\"><\/span>4.3. \uc0ac\uc6a9\uc790 \uc77c\ub7ec\ub450\uae30<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>\ubc84\uadf8, \uae30\ub2a5 \uac1c\uc120, \ucd94\uac00 \uae30\ub2a5 \ub4f1\uc5d0 \ub300\ud55c \uc694\uad6c\uc0ac\ud56d\uc740 \ube14\ub85c\uadf8 \ub313\uae00 \ub610\ub294 \uc774\uba54\uc77c\ub85c \ubcf4\ub0b4\uc8fc\uae30 \ubc14\ub780\ub2e4. \ub2e4\ub9cc, \uc774 \ub3c4\uad6c\ub294 \uc5b4\ub514\uae4c\uc9c0\ub098 \ucde8\ubbf8\ub85c \uac1c\ubc1c\ud558\uace0 \uc788\uc73c\ubbc0\ub85c \uc694\uad6c\uc0ac\ud56d\uc5d0 \ub300\ud55c \ube60\ub978 \ub300\uc751\uc740 \ud560 \uc218 \uc5c6\ub2e4. \uc5ec\uc720\uc2dc\uac04\uc774 \uc788\uc744 \ub54c, \ud574\ub2f9 \uae30\ub2a5\uc774 \ud544\uc694\ud560 \ub54c \ubc18\uc601\ud558\uace0 \ubc30\ud3ec\ud558\uaca0\ub2e4. \ubc30\ud3ec \uc8fc\uae30\ub3c4 \uaddc\uce59\uc801\uc774\uc9c0 \uc54a\ub2e4.<\/p>\n\n\n\n<p>\uc18c\uc2a4\ucf54\ub4dc\ub97c \ud568\uaed8 \uc81c\uacf5\ud558\ubbc0\ub85c \ud544\uc694\ud55c \uae30\ub2a5\uc774 \uc788\ub2e4\uba74 \ubc18\uc601\ud558\uace0 \ub2e4\uc2dc \ub098\uc5d0\uac8c \uacf5\uc720\ud574 \uc8fc\uba74 \ub300\ub2e8\ud788 \uac10\uc0ac\ud558\uaca0\ub2e4.<\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<p>\uc9c0\uae08\uae4c\uc9c0 DA# Macro\uc5d0 \ub300\ud55c \uc0ac\uc6a9 \ubc29\ubc95\uc5d0 \ub300\ud558\uc5ec \ubaa8\ub450 \uc54c\uc544\ubcf4\uc558\ub2e4. \ub2e4\uc74c\uc5d0\ub294 DA# Macro\uc758 \uc18c\uc2a4\ucf54\ub4dc\uc5d0 \ub300\ud574 \uc0b4\ud3b4\ubcf4\uaca0\ub2e4.<\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<p>&lt;&lt;&nbsp;<strong>\uad00\ub828 \uae00 \ubaa9\ub85d<\/strong>&nbsp;&gt;&gt;<\/p>\n\n\n\n<ul class=\"wp-block-list\"><li><a href=\"https:\/\/prodskill.com\/da-macro-overview\/\">DA# Macro(1): DA#, DA# API, DA# Macro (\ub9e4\ud06c\ub85c) \uac1c\uc694<\/a><\/li><li><a href=\"https:\/\/prodskill.com\/da-macro-function-common-entity-get-set\/\">DA# Macro(2): DA# Macro(\ub9e4\ud06c\ub85c) \uae30\ub2a5(1)-\uacf5\ud1b5\uae30\ub2a5, Entity Get\/Set<\/a><\/li><li><a href=\"https:\/\/prodskill.com\/da-macro-function-attribute-get-set\/\">DA# Macro(3): DA# Macro(\ub9e4\ud06c\ub85c) \uae30\ub2a5(2)-Attribute Get\/Set<\/a><\/li><li><a href=\"https:\/\/prodskill.com\/da-macro-function-reverse\/\">DA# Macro(4): DA# Macro(\ub9e4\ud06c\ub85c) \uae30\ub2a5(3)-Reverse<\/a><\/li><li><a href=\"https:\/\/prodskill.com\/da-macro-usage-notes\/\">DA# Macro(5): \uc0ac\uc6a9\uc0c1 \uc8fc\uc758\uc0ac\ud56d\/\ucc38\uace0\uc0ac\ud56d, \ub2e4\uc6b4\ub85c\ub4dc, \ud5a5\ud6c4 \ucd94\uac00 \uc608\uc815 \uae30\ub2a5, \uc77c\ub7ec\ub450\uae30<\/a><\/li><li><a href=\"https:\/\/prodskill.com\/da-macro-modeler-api\/\">DA# Macro(6): DA# Modeler API<\/a><\/li><li><a href=\"https:\/\/prodskill.com\/da-macro-demo-video-youtube\/\">DA# Macro \uae30\ub2a5 \uc2dc\uc5f0 \uc601\uc0c1 (YouTube)<\/a><\/li><li><a href=\"https:\/\/prodskill.com\/da-macro-toc\/\">DA# Macro \uc124\uba85\uae00 \ubaa9\ucc28 , \ub2e4\uc6b4\ub85c\ub4dc<\/a><\/li><\/ul>\n","protected":false},"excerpt":{"rendered":"<p>\u5728\u672c\u6587\u4e2d\uff0c\u6211\u4eec\u5c06\u4e86\u89e3\u4f7f\u7528 DA# \u5b8f\u7684\u6ce8\u610f\u4e8b\u9879\/\u6ce8\u610f\u4e8b\u9879\u3001\u4e0b\u8f7d\u3001\u5c06\u6765\u8981\u6dfb\u52a0\u7684\u529f\u80fd\u4ee5\u53ca\u6ce8\u610f\u4e8b\u9879\u3002\u8fd9\u662f\u4e0a\u4e00\u7bc7\u6587\u7ae0\u7684\u5ef6\u7eed\u3002 DA# Macro(4): DA# Macro function(3)-Reverse 3. DA# Macro \u4f7f\u7528\u6ce8\u610f\u4e8b\u9879\/\u53c2\u8003 3.1. DA# \u4f7f\u7528\u5b8f\u7684\u6ce8\u610f\u4e8b\u9879 \u5728\u4e3a\u5b9e\u4f53\/\u5c5e\u6027\u6267\u884c\u8bbe\u7f6e\u5b8f\u4e4b\u524d\uff0c\u76ee\u6807...<\/p>","protected":false},"author":1,"featured_media":11724,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[22],"tags":[17,73,109,110,111],"class_list":["post-11720","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-da-macro","tag-vba","tag-excel-vba","tag-da","tag-api","tag-da-macro"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.2 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>DA# Macro(5): \uc0ac\uc6a9\uc0c1 \uc8fc\uc758\uc0ac\ud56d\/\ucc38\uace0\uc0ac\ud56d, \ub2e4\uc6b4\ub85c\ub4dc, \ud5a5\ud6c4 \ucd94\uac00 \uc608\uc815 \uae30\ub2a5, \uc77c\ub7ec\ub450\uae30 - \uc0dd\uc0b0\uc131 Skill<\/title>\n<meta name=\"description\" content=\"\uc774 \uae00\uc5d0\uc11c\ub294 DA# Macro \uc0ac\uc6a9\uc0c1 \uc8fc\uc758\uc0ac\ud56d\/\ucc38\uace0\uc0ac\ud56d , \ub2e4\uc6b4\ub85c\ub4dc, \ud5a5\ud6c4 \ucd94\uac00 \uc608\uc815 \uae30\ub2a5, \uc77c\ub7ec\ub450\uae30\uc5d0 \ub300\ud574 \uc0b4\ud3b4\ubcf8\ub2e4. \ubaa8\ub378 \ud30c\uc77c \ubc31\uc5c5\uc5d0 \uc8fc\uc758\uac00 \ud544\uc694\ud558\uace0, \ub3d9\uc2dc\uc5d0 \uc2e4\ud589\ud560 \uc218 \uc788\ub294 \ubc29\ubc95\uacfc Reverse \uc815\ubcf4 \uc218\uc9d1 SQL(Oracle\uc6a9)\uc744 \ud655\uc778\ud560 \uc218 \uc788\ub2e4.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/prodskill.com\/zh\/da-macro-usage-notes\/\" \/>\n<meta property=\"og:locale\" content=\"zh_CN\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"DA# Macro(5): \uc0ac\uc6a9\uc0c1 \uc8fc\uc758\uc0ac\ud56d\/\ucc38\uace0\uc0ac\ud56d, \ub2e4\uc6b4\ub85c\ub4dc, \ud5a5\ud6c4 \ucd94\uac00 \uc608\uc815 \uae30\ub2a5, \uc77c\ub7ec\ub450\uae30 - \uc0dd\uc0b0\uc131 Skill\" \/>\n<meta property=\"og:description\" content=\"\uc774 \uae00\uc5d0\uc11c\ub294 DA# Macro \uc0ac\uc6a9\uc0c1 \uc8fc\uc758\uc0ac\ud56d\/\ucc38\uace0\uc0ac\ud56d , \ub2e4\uc6b4\ub85c\ub4dc, \ud5a5\ud6c4 \ucd94\uac00 \uc608\uc815 \uae30\ub2a5, \uc77c\ub7ec\ub450\uae30\uc5d0 \ub300\ud574 \uc0b4\ud3b4\ubcf8\ub2e4. \ubaa8\ub378 \ud30c\uc77c \ubc31\uc5c5\uc5d0 \uc8fc\uc758\uac00 \ud544\uc694\ud558\uace0, \ub3d9\uc2dc\uc5d0 \uc2e4\ud589\ud560 \uc218 \uc788\ub294 \ubc29\ubc95\uacfc Reverse \uc815\ubcf4 \uc218\uc9d1 SQL(Oracle\uc6a9)\uc744 \ud655\uc778\ud560 \uc218 \uc788\ub2e4.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/prodskill.com\/zh\/da-macro-usage-notes\/\" \/>\n<meta property=\"og:site_name\" content=\"\uc0dd\uc0b0\uc131 Skill\" \/>\n<meta property=\"article:published_time\" content=\"2022-09-28T13:09:27+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2022-10-10T12:03:51+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-236.png\" \/>\n\t<meta property=\"og:image:width\" content=\"834\" \/>\n\t<meta property=\"og:image:height\" content=\"453\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Zerom\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"\u4f5c\u8005\" \/>\n\t<meta name=\"twitter:data1\" content=\"Zerom\" \/>\n\t<meta name=\"twitter:label2\" content=\"\u9884\u8ba1\u9605\u8bfb\u65f6\u95f4\" \/>\n\t<meta name=\"twitter:data2\" content=\"9 \u5206\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/prodskill.com\/da-macro-usage-notes\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/prodskill.com\/da-macro-usage-notes\/\"},\"author\":{\"name\":\"Zerom\",\"@id\":\"https:\/\/prodskill.com\/ko\/#\/schema\/person\/bbad0870c78008c82edbe0960fe768bd\"},\"headline\":\"DA# Macro(5): \uc0ac\uc6a9\uc0c1 \uc8fc\uc758\uc0ac\ud56d\/\ucc38\uace0\uc0ac\ud56d, \ub2e4\uc6b4\ub85c\ub4dc, \ud5a5\ud6c4 \ucd94\uac00 \uc608\uc815 \uae30\ub2a5, \uc77c\ub7ec\ub450\uae30\",\"datePublished\":\"2022-09-28T13:09:27+00:00\",\"dateModified\":\"2022-10-10T12:03:51+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/prodskill.com\/da-macro-usage-notes\/\"},\"wordCount\":258,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/prodskill.com\/ko\/#\/schema\/person\/bbad0870c78008c82edbe0960fe768bd\"},\"image\":{\"@id\":\"https:\/\/prodskill.com\/da-macro-usage-notes\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-236.png\",\"keywords\":[\"\uc5d1\uc140VBA\",\"Excel VBA\",\"DA#\",\"API\",\"DA# Macro\"],\"articleSection\":[\"DA# Macro\"],\"inLanguage\":\"zh-Hans\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/prodskill.com\/da-macro-usage-notes\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/prodskill.com\/da-macro-usage-notes\/\",\"url\":\"https:\/\/prodskill.com\/da-macro-usage-notes\/\",\"name\":\"DA# Macro(5): \uc0ac\uc6a9\uc0c1 \uc8fc\uc758\uc0ac\ud56d\/\ucc38\uace0\uc0ac\ud56d, \ub2e4\uc6b4\ub85c\ub4dc, \ud5a5\ud6c4 \ucd94\uac00 \uc608\uc815 \uae30\ub2a5, \uc77c\ub7ec\ub450\uae30 - \uc0dd\uc0b0\uc131 Skill\",\"isPartOf\":{\"@id\":\"https:\/\/prodskill.com\/ko\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/prodskill.com\/da-macro-usage-notes\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/prodskill.com\/da-macro-usage-notes\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-236.png\",\"datePublished\":\"2022-09-28T13:09:27+00:00\",\"dateModified\":\"2022-10-10T12:03:51+00:00\",\"description\":\"\uc774 \uae00\uc5d0\uc11c\ub294 DA# Macro \uc0ac\uc6a9\uc0c1 \uc8fc\uc758\uc0ac\ud56d\/\ucc38\uace0\uc0ac\ud56d , \ub2e4\uc6b4\ub85c\ub4dc, \ud5a5\ud6c4 \ucd94\uac00 \uc608\uc815 \uae30\ub2a5, \uc77c\ub7ec\ub450\uae30\uc5d0 \ub300\ud574 \uc0b4\ud3b4\ubcf8\ub2e4. \ubaa8\ub378 \ud30c\uc77c \ubc31\uc5c5\uc5d0 \uc8fc\uc758\uac00 \ud544\uc694\ud558\uace0, \ub3d9\uc2dc\uc5d0 \uc2e4\ud589\ud560 \uc218 \uc788\ub294 \ubc29\ubc95\uacfc Reverse \uc815\ubcf4 \uc218\uc9d1 SQL(Oracle\uc6a9)\uc744 \ud655\uc778\ud560 \uc218 \uc788\ub2e4.\",\"breadcrumb\":{\"@id\":\"https:\/\/prodskill.com\/da-macro-usage-notes\/#breadcrumb\"},\"inLanguage\":\"zh-Hans\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/prodskill.com\/da-macro-usage-notes\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"zh-Hans\",\"@id\":\"https:\/\/prodskill.com\/da-macro-usage-notes\/#primaryimage\",\"url\":\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-236.png\",\"contentUrl\":\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-236.png\",\"width\":834,\"height\":453},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/prodskill.com\/da-macro-usage-notes\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/prodskill.com\/ko\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"DA# Macro(5): \uc0ac\uc6a9\uc0c1 \uc8fc\uc758\uc0ac\ud56d\/\ucc38\uace0\uc0ac\ud56d, \ub2e4\uc6b4\ub85c\ub4dc, \ud5a5\ud6c4 \ucd94\uac00 \uc608\uc815 \uae30\ub2a5, \uc77c\ub7ec\ub450\uae30\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/prodskill.com\/ko\/#website\",\"url\":\"https:\/\/prodskill.com\/ko\/\",\"name\":\"\uc0dd\uc0b0\uc131 Skill\",\"description\":\"Meta Thinking, Meta Working\",\"publisher\":{\"@id\":\"https:\/\/prodskill.com\/ko\/#\/schema\/person\/bbad0870c78008c82edbe0960fe768bd\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/prodskill.com\/ko\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"zh-Hans\"},{\"@type\":[\"Person\",\"Organization\"],\"@id\":\"https:\/\/prodskill.com\/ko\/#\/schema\/person\/bbad0870c78008c82edbe0960fe768bd\",\"name\":\"Zerom\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"zh-Hans\",\"@id\":\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/productivity_clockgear.png\",\"url\":\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/productivity_clockgear.png\",\"contentUrl\":\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/productivity_clockgear.png\",\"width\":512,\"height\":512,\"caption\":\"Zerom\"},\"logo\":{\"@id\":\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/productivity_clockgear.png\"},\"url\":\"https:\/\/prodskill.com\/zh\/author\/proda\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"DA# \u5b8f\uff085\uff09\uff1a\u4f7f\u7528\u6ce8\u610f\u4e8b\u9879\/\u8bf4\u660e\u3001\u4e0b\u8f7d\u3001\u672a\u6765\u6dfb\u52a0\u3001\u6ce8\u91ca - \u751f\u4ea7\u529b\u6280\u80fd","description":"\u672c\u6587\u6db5\u76d6\u4f7f\u7528 DA# \u5b8f\u7684\u6ce8\u610f\u4e8b\u9879\/\u53c2\u8003\u8d44\u6599\u3001\u4e0b\u8f7d\u5185\u5bb9\u3001\u5373\u5c06\u63a8\u51fa\u7684\u529f\u80fd\u4ee5\u53ca\u6ce8\u610f\u4e8b\u9879\u3002\u6b64\u5916\uff0c\u672c\u6587\u8fd8\u5f3a\u8c03\u4e86\u5907\u4efd\u6a21\u578b\u6587\u4ef6\u7684\u91cd\u8981\u6027\u3001\u5982\u4f55\u5e76\u53d1\u8fd0\u884c\u6a21\u578b\u6587\u4ef6\u4ee5\u53ca\u53cd\u5411\u4fe1\u606f\u6536\u96c6 SQL\uff08\u9002\u7528\u4e8e Oracle\uff09\u3002","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/prodskill.com\/zh\/da-macro-usage-notes\/","og_locale":"zh_CN","og_type":"article","og_title":"DA# Macro(5): \uc0ac\uc6a9\uc0c1 \uc8fc\uc758\uc0ac\ud56d\/\ucc38\uace0\uc0ac\ud56d, \ub2e4\uc6b4\ub85c\ub4dc, \ud5a5\ud6c4 \ucd94\uac00 \uc608\uc815 \uae30\ub2a5, \uc77c\ub7ec\ub450\uae30 - \uc0dd\uc0b0\uc131 Skill","og_description":"\uc774 \uae00\uc5d0\uc11c\ub294 DA# Macro \uc0ac\uc6a9\uc0c1 \uc8fc\uc758\uc0ac\ud56d\/\ucc38\uace0\uc0ac\ud56d , \ub2e4\uc6b4\ub85c\ub4dc, \ud5a5\ud6c4 \ucd94\uac00 \uc608\uc815 \uae30\ub2a5, \uc77c\ub7ec\ub450\uae30\uc5d0 \ub300\ud574 \uc0b4\ud3b4\ubcf8\ub2e4. \ubaa8\ub378 \ud30c\uc77c \ubc31\uc5c5\uc5d0 \uc8fc\uc758\uac00 \ud544\uc694\ud558\uace0, \ub3d9\uc2dc\uc5d0 \uc2e4\ud589\ud560 \uc218 \uc788\ub294 \ubc29\ubc95\uacfc Reverse \uc815\ubcf4 \uc218\uc9d1 SQL(Oracle\uc6a9)\uc744 \ud655\uc778\ud560 \uc218 \uc788\ub2e4.","og_url":"https:\/\/prodskill.com\/zh\/da-macro-usage-notes\/","og_site_name":"\uc0dd\uc0b0\uc131 Skill","article_published_time":"2022-09-28T13:09:27+00:00","article_modified_time":"2022-10-10T12:03:51+00:00","og_image":[{"width":834,"height":453,"url":"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-236.png","type":"image\/png"}],"author":"Zerom","twitter_card":"summary_large_image","twitter_misc":{"\u4f5c\u8005":"Zerom","\u9884\u8ba1\u9605\u8bfb\u65f6\u95f4":"9 \u5206"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/prodskill.com\/da-macro-usage-notes\/#article","isPartOf":{"@id":"https:\/\/prodskill.com\/da-macro-usage-notes\/"},"author":{"name":"Zerom","@id":"https:\/\/prodskill.com\/ko\/#\/schema\/person\/bbad0870c78008c82edbe0960fe768bd"},"headline":"DA# Macro(5): \uc0ac\uc6a9\uc0c1 \uc8fc\uc758\uc0ac\ud56d\/\ucc38\uace0\uc0ac\ud56d, \ub2e4\uc6b4\ub85c\ub4dc, \ud5a5\ud6c4 \ucd94\uac00 \uc608\uc815 \uae30\ub2a5, \uc77c\ub7ec\ub450\uae30","datePublished":"2022-09-28T13:09:27+00:00","dateModified":"2022-10-10T12:03:51+00:00","mainEntityOfPage":{"@id":"https:\/\/prodskill.com\/da-macro-usage-notes\/"},"wordCount":258,"commentCount":0,"publisher":{"@id":"https:\/\/prodskill.com\/ko\/#\/schema\/person\/bbad0870c78008c82edbe0960fe768bd"},"image":{"@id":"https:\/\/prodskill.com\/da-macro-usage-notes\/#primaryimage"},"thumbnailUrl":"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-236.png","keywords":["\uc5d1\uc140VBA","Excel VBA","DA#","API","DA# Macro"],"articleSection":["DA# Macro"],"inLanguage":"zh-Hans","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/prodskill.com\/da-macro-usage-notes\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/prodskill.com\/da-macro-usage-notes\/","url":"https:\/\/prodskill.com\/da-macro-usage-notes\/","name":"DA# \u5b8f\uff085\uff09\uff1a\u4f7f\u7528\u6ce8\u610f\u4e8b\u9879\/\u8bf4\u660e\u3001\u4e0b\u8f7d\u3001\u672a\u6765\u6dfb\u52a0\u3001\u6ce8\u91ca - \u751f\u4ea7\u529b\u6280\u80fd","isPartOf":{"@id":"https:\/\/prodskill.com\/ko\/#website"},"primaryImageOfPage":{"@id":"https:\/\/prodskill.com\/da-macro-usage-notes\/#primaryimage"},"image":{"@id":"https:\/\/prodskill.com\/da-macro-usage-notes\/#primaryimage"},"thumbnailUrl":"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-236.png","datePublished":"2022-09-28T13:09:27+00:00","dateModified":"2022-10-10T12:03:51+00:00","description":"\u672c\u6587\u6db5\u76d6\u4f7f\u7528 DA# \u5b8f\u7684\u6ce8\u610f\u4e8b\u9879\/\u53c2\u8003\u8d44\u6599\u3001\u4e0b\u8f7d\u5185\u5bb9\u3001\u5373\u5c06\u63a8\u51fa\u7684\u529f\u80fd\u4ee5\u53ca\u6ce8\u610f\u4e8b\u9879\u3002\u6b64\u5916\uff0c\u672c\u6587\u8fd8\u5f3a\u8c03\u4e86\u5907\u4efd\u6a21\u578b\u6587\u4ef6\u7684\u91cd\u8981\u6027\u3001\u5982\u4f55\u5e76\u53d1\u8fd0\u884c\u6a21\u578b\u6587\u4ef6\u4ee5\u53ca\u53cd\u5411\u4fe1\u606f\u6536\u96c6 SQL\uff08\u9002\u7528\u4e8e Oracle\uff09\u3002","breadcrumb":{"@id":"https:\/\/prodskill.com\/da-macro-usage-notes\/#breadcrumb"},"inLanguage":"zh-Hans","potentialAction":[{"@type":"ReadAction","target":["https:\/\/prodskill.com\/da-macro-usage-notes\/"]}]},{"@type":"ImageObject","inLanguage":"zh-Hans","@id":"https:\/\/prodskill.com\/da-macro-usage-notes\/#primaryimage","url":"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-236.png","contentUrl":"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-236.png","width":834,"height":453},{"@type":"BreadcrumbList","@id":"https:\/\/prodskill.com\/da-macro-usage-notes\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/prodskill.com\/ko\/"},{"@type":"ListItem","position":2,"name":"DA# Macro(5): \uc0ac\uc6a9\uc0c1 \uc8fc\uc758\uc0ac\ud56d\/\ucc38\uace0\uc0ac\ud56d, \ub2e4\uc6b4\ub85c\ub4dc, \ud5a5\ud6c4 \ucd94\uac00 \uc608\uc815 \uae30\ub2a5, \uc77c\ub7ec\ub450\uae30"}]},{"@type":"WebSite","@id":"https:\/\/prodskill.com\/ko\/#website","url":"https:\/\/prodskill.com\/ko\/","name":"\u751f\u4ea7\u529b\u6280\u80fd","description":"\u5143\u601d\u7ef4\uff0c\u5143\u5de5\u4f5c","publisher":{"@id":"https:\/\/prodskill.com\/ko\/#\/schema\/person\/bbad0870c78008c82edbe0960fe768bd"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/prodskill.com\/ko\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"zh-Hans"},{"@type":["Person","Organization"],"@id":"https:\/\/prodskill.com\/ko\/#\/schema\/person\/bbad0870c78008c82edbe0960fe768bd","name":"\u6cfd\u7f57\u59c6","image":{"@type":"ImageObject","inLanguage":"zh-Hans","@id":"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/productivity_clockgear.png","url":"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/productivity_clockgear.png","contentUrl":"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/productivity_clockgear.png","width":512,"height":512,"caption":"Zerom"},"logo":{"@id":"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/productivity_clockgear.png"},"url":"https:\/\/prodskill.com\/zh\/author\/proda\/"}]}},"_links":{"self":[{"href":"https:\/\/prodskill.com\/zh\/wp-json\/wp\/v2\/posts\/11720","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/prodskill.com\/zh\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/prodskill.com\/zh\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/prodskill.com\/zh\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/prodskill.com\/zh\/wp-json\/wp\/v2\/comments?post=11720"}],"version-history":[{"count":0,"href":"https:\/\/prodskill.com\/zh\/wp-json\/wp\/v2\/posts\/11720\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/prodskill.com\/zh\/wp-json\/wp\/v2\/media\/11724"}],"wp:attachment":[{"href":"https:\/\/prodskill.com\/zh\/wp-json\/wp\/v2\/media?parent=11720"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/prodskill.com\/zh\/wp-json\/wp\/v2\/categories?post=11720"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/prodskill.com\/zh\/wp-json\/wp\/v2\/tags?post=11720"}],"curies":[{"name":"\u53ef\u6e7f\u6027\u7c89\u5242","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}