{"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\/en\/da-macro-usage-notes\/","title":{"rendered":"DA# Macro(5): Usage notes\/notes, downloads, features to be added in the future, notes"},"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\/en\/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\/en\/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\/en\/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\/en\/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\/en\/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\/en\/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\/en\/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\/en\/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\/en\/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\/en\/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>In this article, we look at the precautions\/notes for using the DA# Macro, downloads, functions to be added in the future, and notes. This is a continuation of the previous article. DA# Macro(4): DA# Macro function(3)-Reverse 3. Precautions\/References for using DA# Macro 3.1. DA# Precautions for Using Macro Before executing the Set Macro for Entity\/Attribute, the target...<\/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.3 - 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\/en\/da-macro-usage-notes\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\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\/en\/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=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Zerom\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"9 minutes\" \/>\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\":\"en-US\",\"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\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/prodskill.com\\\/da-macro-usage-notes\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@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\":\"en-US\"},{\"@type\":[\"Person\",\"Organization\"],\"@id\":\"https:\\\/\\\/prodskill.com\\\/ko\\\/#\\\/schema\\\/person\\\/bbad0870c78008c82edbe0960fe768bd\",\"name\":\"Zerom\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@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\\\/en\\\/author\\\/proda\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"DA# Macro (5): Precautions\/Notes for Use, Download, Future Additions, Notes - Productivity Skill","description":"This article covers precautions\/references for using the DA# Macro, downloads, upcoming features, and notes. It also highlights the importance of backing up model files, how to run them concurrently, and the reverse information collection SQL (for Oracle).","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\/en\/da-macro-usage-notes\/","og_locale":"en_US","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\/en\/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":{"Written by":"Zerom","Est. reading time":"9 minutes"},"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":"en-US","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): Precautions\/Notes for Use, Download, Future Additions, Notes - Productivity 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":"This article covers precautions\/references for using the DA# Macro, downloads, upcoming features, and notes. It also highlights the importance of backing up model files, how to run them concurrently, and the reverse information collection SQL (for Oracle).","breadcrumb":{"@id":"https:\/\/prodskill.com\/da-macro-usage-notes\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/prodskill.com\/da-macro-usage-notes\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@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":"Productivity Skills","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":"en-US"},{"@type":["Person","Organization"],"@id":"https:\/\/prodskill.com\/ko\/#\/schema\/person\/bbad0870c78008c82edbe0960fe768bd","name":"Zerom","image":{"@type":"ImageObject","inLanguage":"en-US","@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\/en\/author\/proda\/"}]}},"_links":{"self":[{"href":"https:\/\/prodskill.com\/en\/wp-json\/wp\/v2\/posts\/11720","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/prodskill.com\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/prodskill.com\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/prodskill.com\/en\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/prodskill.com\/en\/wp-json\/wp\/v2\/comments?post=11720"}],"version-history":[{"count":0,"href":"https:\/\/prodskill.com\/en\/wp-json\/wp\/v2\/posts\/11720\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/prodskill.com\/en\/wp-json\/wp\/v2\/media\/11724"}],"wp:attachment":[{"href":"https:\/\/prodskill.com\/en\/wp-json\/wp\/v2\/media?parent=11720"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/prodskill.com\/en\/wp-json\/wp\/v2\/categories?post=11720"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/prodskill.com\/en\/wp-json\/wp\/v2\/tags?post=11720"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}