{"id":3136,"date":"2021-10-07T00:05:52","date_gmt":"2021-10-07T08:05:52","guid":{"rendered":"https:\/\/www.gudusoft.com\/?page_id=3136"},"modified":"2026-07-12T02:06:47","modified_gmt":"2026-07-12T10:06:47","slug":"oracle-data-lineage-tool","status":"publish","type":"page","link":"https:\/\/www.gudusoft.com\/ko\/%ec%98%a4%eb%9d%bc%ed%81%b4-%eb%8d%b0%ec%9d%b4%ed%84%b0-%ea%b3%84%eb%b3%b4-%eb%8f%84%ea%b5%ac\/","title":{"rendered":"Oracle \ub370\uc774\ud130 \uacc4\ubcf4: PL\/SQL \uc800\uc7a5 \ud504\ub85c\uc2dc\uc800 \ubc0f \ud328\ud0a4\uc9c0 \ubd84\uc11d"},"content":{"rendered":"<p><strong>Oracle \ub370\uc774\ud130 \uacc4\ubcf4<\/strong> \ub370\uc774\ud130 \uacc4\ubcf4\ub294 Oracle \ud658\uacbd\uc5d0\uc11c \ub370\uc774\ud130\uac00 \uc774\ub3d9\ud558\ub294 \ubc29\uc2dd\uc744 \uc5f4 \uc218\uc900\uc5d0\uc11c \ubcf4\uc5ec\uc8fc\ub294 \uc9c0\ub3c4\uc785\ub2c8\ub2e4. \uc989, \uc5b4\ub5a4 \uc18c\uc2a4 \ud14c\uc774\ube14\uacfc \uc5f4\uc774 \uac01 \ub300\uc0c1 \ud14c\uc774\ube14, \ubdf0 \ub610\ub294 \uad6c\uccb4\ud654\ub41c \ubdf0\uc5d0 \ub370\uc774\ud130\ub97c \uc81c\uacf5\ud558\ub294\uc9c0, \uadf8\ub9ac\uace0 \uc5b4\ub5a4 PL\/SQL \ud328\ud0a4\uc9c0, \ud504\ub85c\uc2dc\uc800, \ud568\uc218 \ubc0f \ud2b8\ub9ac\uac70\uac00 \uc774\ub7ec\ud55c \ub370\uc774\ud130 \uc774\ub3d9\uc744 \uc218\ud589\ud558\ub294\uc9c0\ub97c \ub098\ud0c0\ub0c5\ub2c8\ub2e4. \ub300\ubd80\ubd84\uc758 Oracle \ud658\uacbd\uc5d0\uc11c\ub294 \ubcc0\ud658 \ub85c\uc9c1\uc774 \ub3c5\ub9bd \uc2e4\ud589\ud615 \ucffc\ub9ac\uac00 \uc544\ub2cc PL\/SQL\uc5d0 \uc788\uae30 \ub54c\ubb38\uc5d0 \uc815\ud655\ud55c \ub370\uc774\ud130 \uacc4\ubcf4\ub97c \ud30c\uc545\ud558\ub824\uba74 Oracle SQL\ubfd0\ub9cc \uc544\ub2c8\ub77c PL\/SQL\uc744 \uc808\ucc28\uc801 \uc5b8\uc5b4\ub85c \ud30c\uc2f1\ud560 \uc218 \uc788\ub294 \ub3c4\uad6c\uac00 \ud544\uc694\ud569\ub2c8\ub2e4. <a href=\"https:\/\/www.gudusoft.com\/ko\/sql-%eb%8d%b0%ec%9d%b4%ed%84%b0-%ea%b3%84%eb%b3%b4-%eb%8f%84%ea%b5%ac\/\">Gudu SQLFlow<\/a> \uc774 \uc18c\ud504\ud2b8\uc6e8\uc5b4\ub294 \ub3d9\uc801 SQL\uc744 \ud3ec\ud568\ud558\uc5ec \uc815\ud655\ud788 \uadf8\ub7ec\ud55c \uc791\uc5c5\uc744 \uc218\ud589\ud558\ub294 \uc804\uc6a9 PL\/SQL \ud30c\uc11c\ub97c \uc81c\uacf5\ud569\ub2c8\ub2e4. <code>\uc989\uc2dc \uc2e4\ud589<\/code>.<\/p>\n\n\n\n<div class=\"wp-block-group alignfull has-background is-layout-constrained\" style=\"background-color:#eef7fb;padding-top:24px;padding-bottom:24px\"><div class=\"wp-block-group__inner-container\">\n\n<p><strong>\uc9c1\uc811 \uc791\uc131\ud55c \ucf54\ub4dc\ub85c \ud14c\uc2a4\ud2b8\ud574 \ubcf4\uc138\uc694.<\/strong> Oracle \ud328\ud0a4\uc9c0 \ubcf8\ubb38\uc744 \ubd99\uc5ec\ub123\uc73c\uc138\uc694 <a href=\"https:\/\/sqlflow.gudusoft.com\/?utm_source=gudusoft&amp;utm_medium=website&amp;utm_campaign=oracle-data-lineage-tool\" target=\"_blank\" rel=\"noreferrer noopener\">\ubb34\ub8cc SQLFlow \uacc4\ubcf4 \uc2dc\uac01\ud654 \ub3c4\uad6c<\/a>Oracle \ubc29\uc5b8\uc744 \uc120\ud0dd\ud558\uace0 \ud574\ub2f9 \ubc29\uc5b8\uc774 \uc0dd\uc131\ud558\ub294 \uc5f4 \uc218\uc900 \uacc4\ubcf4 \ubc0f \ud504\ub85c\uc2dc\uc800 \ud638\ucd9c \uadf8\ub798\ud504\ub97c \ud655\uc778\ud558\uc2ed\uc2dc\uc624.<\/p>\n\n<\/div><\/div>\n\n\n\n<h2 class=\"wp-block-heading\">\uc624\ub77c\ud074 \ub370\uc774\ud130 \uacc4\ubcf4 \ucd94\uc801\uc774 SELECT \ubb38 \ud30c\uc2f1\ubcf4\ub2e4 \uc5b4\ub824\uc6b4 \uc774\uc720\ub294 \ubb34\uc5c7\uc77c\uae4c\uc694?<\/h2>\n\n\n\n<p>\uc624\ub77c\ud074 \ub370\uc774\ud130\ubca0\uc774\uc2a4\ub294 \uc88b\uc740 \uc758\ubbf8\uc5d0\uc11c \uc624\ub798\ub418\uc5c8\uc2b5\ub2c8\ub2e4. \ub9ce\uc740 \uc6b4\uc601 \ud658\uacbd\uc5d0\ub294 20\ub144 \uc774\uc0c1 \ucd95\uc801\ub41c \ube44\uc988\ub2c8\uc2a4 \ub85c\uc9c1\uc774 \uc800\uc7a5\ub418\uc5b4 \uc788\uc73c\uba70, \uadf8 \ub300\ubd80\ubd84\uc740 PL\/SQL\ub85c \uc791\uc131\ub418\uc5c8\uc2b5\ub2c8\ub2e4. \uc57c\uac04 \ub85c\ub4dc, \ub9c8\ud2b8 \uc0c8\ub85c \uace0\uce68, \uc870\uc815 \uc791\uc5c5, \uac10\uc0ac \ucd94\uc801\uc740 \ud504\ub85c\uc2dc\uc800\ub97c \ud638\ucd9c\ud558\uace0 \ud568\uc218\ub97c \ud638\ucd9c\ud558\ub294 \ud328\ud0a4\uc9c0 \ud615\ud0dc\ub85c \uad6c\ud604\ub418\uba70, \uadf8 \uacfc\uc815\uc5d0\uc11c \ud2b8\ub9ac\uac70\uac00 \uc2e4\ud589\ub429\ub2c8\ub2e4. \uc774\ub7ec\ud55c \uad6c\ud604 \ubc29\uc2dd\uc744 \uc774\ud574\ud558\ub294 \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uacc4\ubcf4 \ub3c4\uad6c\ub294 \uc5c6\uc2b5\ub2c8\ub2e4. <code>\uc120\ud0dd\ud558\ub2e4<\/code>, <code>\ub07c\uc6cc \ub123\ub2e4<\/code>, \uadf8\ub9ac\uace0 <code>\ubdf0 \uc0dd\uc131<\/code> \uadf8\ub7ec\ud55c \ubd80\ub3d9\uc0b0\uc758 \ud45c\uba74\uc801\uc778 \ubaa8\uc2b5\ub9cc \ubcf4\uace0 \uadf8 \uc774\uba74\uc5d0 \uc228\uaca8\uc9c4 \ub17c\ub9ac\ub97c \ub300\ubd80\ubd84 \ub193\uce58\ub294 \uac83\uc774\ub2e4.<\/p>\n\n\n\n<p>\uae30\uc220\uc801\uc778 \uc774\uc720\ub294 PL\/SQL\uc774 SQL\uc774 \uc544\ub2c8\uae30 \ub54c\ubb38\uc785\ub2c8\ub2e4. PL\/SQL\uc740 \uc790\uccb4 \ubb38\ubc95\uc744 \uac00\uc9c4 \ube14\ub85d \uad6c\uc870\uc758 \uc808\ucc28\uc801 \uc5b8\uc5b4\uc785\ub2c8\ub2e4. \uc774 \ubb38\ubc95\uc5d0\ub294 \uc120\uc5b8, \uc81c\uc5b4 \ud750\ub984, \ucee4\uc11c, \uc608\uc678 \ucc98\ub9ac\uae30, \ud328\ud0a4\uc9c0 \uba85\uc138 \ubc0f \ubcf8\ubb38\uc774 \ud3ec\ud568\ub429\ub2c8\ub2e4. SQL \ubb38\uc740 \uc774 \uad6c\uc870 \ub0b4\uc5d0 \ub0b4\uc7a5\ub418\uc5b4 \uc788\uc73c\uba70, \uc785\ub825\uacfc \ucd9c\ub825\uc740 \ubcc0\uc218, \ub9e4\uac1c\ubcc0\uc218 \ubc0f \ucee4\uc11c \ub8e8\ud504\ub97c \ud1b5\ud574 \ud750\ub985\ub2c8\ub2e4. PL\/SQL\uc5d0\uc11c \uacc4\ubcf4\ub97c \ucd94\ucd9c\ud55c\ub2e4\ub294 \uac83\uc740 \uc808\ucc28\uc801 \uacc4\uce35\uc744 \ud30c\uc2f1\ud558\uace0, \uadf8 \uc548\uc5d0\uc11c \uac12\uc744 \ucd94\uc801\ud558\uace0, \ub0b4\uc7a5\ub41c SQL \ubb38\ub4e4\uc744 \uc11c\ub85c \uc5f0\uacb0\ud558\ub294 \uac83\uc744 \uc758\ubbf8\ud569\ub2c8\ub2e4. SQL \uc804\uc6a9 \ubb38\ubc95\uc73c\ub85c\ub294 \uc774\ub7ec\ud55c \uc791\uc5c5\uc744 \uc218\ud589\ud560 \uc218 \uc5c6\uae30 \ub54c\ubb38\uc5d0 \uc77c\ubc18\uc801\uc778 \uacc4\ubcf4 \ucd94\ucd9c\uae30\ub294 \ud504\ub85c\uc2dc\uc800 \ubcf8\ubb38\uc744 \uc644\uc804\ud788 \uac74\ub108\ub6f0\uac70\ub098 \uccab \ubc88\uc9f8 \ub2e8\uacc4\uc5d0\uc11c \uc2e4\ud328\ud558\ub294 \uacbd\uc6b0\uac00 \ub9ce\uc2b5\ub2c8\ub2e4. <code>\uc2dc\uc791\ud558\ub2e4<\/code> \ucc28\ub2e8\ud558\ub2e4.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">\ud655\uc7a5 \uae30\ub2a5\uc774 \uc788\ub294 SQL \ud30c\uc11c\uac00 \uc544\ub2c8\ub77c, PL\/SQL \uc804\uc6a9 \ud30c\uc11c\uc785\ub2c8\ub2e4.<\/h2>\n\n\n\n<p>SQLFlow\ub294 \ub2e4\uc74c\uc744 \uae30\ubc18\uc73c\ub85c \uad6c\ucd95\ub418\uc5c8\uc2b5\ub2c8\ub2e4. <a href=\"https:\/\/www.sqlparser.com\/\">\uc77c\ubc18 SQL \ud30c\uc11c<\/a>\ub294 2000\ub144\ub300 \uc911\ubc18\ubd80\ud130 \uac1c\ubc1c\ub418\uc5b4 \uc57d 13,600\uac1c\uc758 \ubc29\uc5b8\ubcc4 \ud14c\uc2a4\ud2b8 \ud53d\uc2a4\ucc98\ub97c \ud1b5\ud574 \uac80\uc99d\ub41c \uc0c1\uc6a9 SQL \ucef4\ud30c\uc77c\ub7ec \ud504\ub7f0\ud2b8\uc5d4\ub4dc\uc785\ub2c8\ub2e4. \uc624\ub77c\ud074\uc758 \uacbd\uc6b0 \ub450 \uac00\uc9c0 \uae30\ub2a5\uc744 \uc81c\uacf5\ud569\ub2c8\ub2e4. \ud558\ub098\ub294 \ucffc\ub9ac, DDL \ubc0f \ubdf0\ub97c \uc704\ud55c \uc624\ub77c\ud074 SQL \ud30c\uc11c\uc774\uace0, \ub2e4\ub978 \ud558\ub098\ub294 PL\/SQL\uc744 \uc704\ud55c \ubcc4\ub3c4\uc758 \ud504\ub85c\uc2dc\uc800 \ud30c\uc11c\uc785\ub2c8\ub2e4. PL\/SQL \ud30c\uc11c\ub294 \uc624\ub77c\ud074 \ubcc0\ud658 \ub85c\uc9c1\uc774 \uc2e4\uc81c\ub85c \uc874\uc7ac\ud558\ub294 \uac1d\uccb4 \uc720\ud615\uc744 \ucc98\ub9ac\ud569\ub2c8\ub2e4.<\/p>\n\n\n\n<ul><li><strong>\ud328\ud0a4\uc9c0:<\/strong> \ud328\ud0a4\uc9c0\uc5d0 \ud3ec\ud568\ub41c \ubaa8\ub4e0 \ud504\ub85c\uc2dc\uc800\uc640 \ud568\uc218\ub97c \ud3ec\uad04\ud558\ub294 \uc644\ubcbd\ud55c \ubd84\uc11d\uacfc \ud328\ud0a4\uc9c0 \uacbd\uacc4\ub97c \ub118\ub098\ub4dc\ub294 \ud638\ucd9c \uadf8\ub798\ud504\ub97c \uc81c\uacf5\ud569\ub2c8\ub2e4.<\/li>\n<li><strong>\uc808\ucc28 \ubc0f \uae30\ub2a5:<\/strong> \ud504\ub85c\uc2dc\uc800 \ub9e4\uac1c\ubcc0\uc218\uc640 \uc784\uc2dc \ud14c\uc774\ube14\uc744 \ud1b5\ud574 \uacc4\ubcf4\ub97c \ucd94\uc801\ud558\ubbc0\ub85c \uc778\uc218\ub85c \uc785\ub825\ub418\uc5b4 \ud14c\uc774\ube14\uc5d0 \uc800\uc7a5\ub418\ub294 \uac12\uc740 \ucc98\uc74c\ubd80\ud130 \ub05d\uae4c\uc9c0 \uc5f0\uacb0\ub429\ub2c8\ub2e4.<\/li>\n<li><strong>\ud2b8\ub9ac\uac70:<\/strong> \ub370\uc774\ud130\ub97c \ubcf5\uc0ac\ud558\uac70\ub098 \ubcc0\ud658\ud558\ub294 \ud589 \uc218\uc900 \ub85c\uc9c1 <code>\ub07c\uc6cc \ub123\ub2e4<\/code>, <code>\uc5c5\ub370\uc774\ud2b8<\/code>, \ub610\ub294 <code>\uc0ad\uc81c<\/code> \ubcf4\uc774\uc9c0 \uc54a\ub294 \ubd80\uc791\uc6a9\uc73c\ub85c \ub0a8\uc544\uc788\uc9c0 \uc54a\uace0 \uacc4\ubcf4\ub3c4\uc5d0 \ub098\ud0c0\ub0a9\ub2c8\ub2e4.<\/li>\n<li><strong>\ub3d9\uc801 SQL:<\/strong> \uc2e4\ud589 \uc2dc\uac04\uc5d0 \uc870\ub9bd\ub418\uc5b4 \uc2e4\ud589\ub418\ub294 \ubb38\uc7a5 <code>\uc989\uc2dc \uc2e4\ud589<\/code> \uac74\ub108\ub6f0\ub294 \ub300\uc2e0 \ud574\uacb0 \ubc0f \ubd84\uc11d\ub429\ub2c8\ub2e4.<\/li><\/ul>\n\n\n\n<p>SQLFlow\ub294 \uac1d\uccb4\ubcc4 \ubd84\uc11d \uc678\uc5d0\ub3c4 \ub300\ud654\ud615 \ud654\uba74\uc744 \uc81c\uacf5\ud569\ub2c8\ub2e4. <strong>\uadf8\ub798\ud504 \ud638\ucd9c<\/strong>\ud328\ud0a4\uc9c0 \uacbd\uacc4\ub97c \ub118\uc5b4 \uc5b4\ub5a4 \ud504\ub85c\uc2dc\uc800\uac00 \uc5b4\ub5a4 \ud504\ub85c\uc2dc\uc800\ub97c \ud638\ucd9c\ud558\ub294\uc9c0. \ucf54\ub4dc\ubca0\uc774\uc2a4\uc5d0\uc11c <code>etl_driver.run_nightly<\/code> \uc5ec\ub7ec \uac1c\uc758 \ud328\ud0a4\uc9c0 \ud504\ub85c\uc2dc\uc800\ub85c \ub098\ub258\uc5b4\uc838 \uc788\ub294\ub370, \ud638\ucd9c \uadf8\ub798\ud504\ub97c \uc774\uc6a9\ud558\uba74 \uc2e4\uc81c\ub85c \uc6d0\ud558\ub294 \ud14c\uc774\ube14\uc744 \uc791\uc131\ud558\ub294 \ud504\ub85c\uc2dc\uc800\ub97c \ucc3e\uc744 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">\uc608\uc2dc: \ud328\ud0a4\uc9c0 \ud504\ub85c\uc2dc\uc800\ub97c \ud1b5\ud55c \uacc4\ubcf4 \ucd94\uc801<\/h2>\n\n\n\n<p>\ub2e4\uc74c\uc740 \ub2e8\uc21c\ud654\ub418\uc5c8\uc9c0\ub9cc \ub300\ud45c\uc801\uc778 \ud328\ud134\uc785\ub2c8\ub2e4. \uc2a4\ud14c\uc774\uc9d5 \ud658\uacbd\uc5d0\uc11c \uc77c\uc77c \ub9e4\ucd9c \ub370\uc774\ud130\ub97c \ubd88\ub7ec\uc624\ub294 \ud328\ud0a4\uc9c0 \ud504\ub85c\uc2dc\uc800\uc785\ub2c8\ub2e4.<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>CREATE OR REPLACE PACKAGE BODY sales_etl AS PROCEDURE load_revenue_mart(p_load_date IN DATE) IS BEGIN DELETE FROM mart.revenue_daily WHERE day_id = TO_CHAR(p_load_date, &#039;YYYYMMDD&#039;); INSERT INTO mart.revenue_daily (day_id, region_name, total_amount) SELECT TO_CHAR(o.order_date, &#039;YYYYMMDD&#039;), r.region_name, SUM(o.amount) FROM staging.orders o JOIN dim.region r ON r.region_id = o.region_id WHERE o.status = &#039;SHIPPED&#039; AND TRUNC(o.order_date) = TRUNC(p_load_date) GROUP BY TO_CHAR(o.order_date, &#039;YYYYMMDD&#039;), r.region_name; END load_revenue_mart; END sales_etl;<\/code><\/pre>\n\n\n\n<p>SQLFlow\ub294 \ud328\ud0a4\uc9c0 \ubcf8\ubb38\uc744 \uc77d\uace0 \ucd9c\ub825 \uc5f4\ubcc4\ub85c \ubcf4\uace0\uc11c\ub97c \uc0dd\uc131\ud569\ub2c8\ub2e4. <code>\ub9c8\ud2b8.\uc77c\uc77c\uc218\uc775.\ucd1d\uc561<\/code> ~\uc5d0 \uc758\ud574 \uacf5\uae09\ub429\ub2c8\ub2e4 <code>\uc2a4\ud14c\uc774\uc9d5.\uc8fc\ubb38.\uae08\uc561<\/code> ~\uc744 \ud1b5\ud574 <code>\ud569\uc9d1\ud569<\/code>; <code>\uc9c0\uc5ed \uc774\ub984<\/code> ~\uc5d0\uc11c \uc720\ub798\ud569\ub2c8\ub2e4 <code>dim.region.region_name<\/code> \uac00\uc785\uc744 \ud1b5\ud574 <code>\uc9c0\uc5ed ID<\/code>; <code>\uc77c_id<\/code> ~\uc5d0\uc11c \ud30c\uc0dd\ub428 <code>\uc2a4\ud14c\uc774\uc9d5.\uc8fc\ubb38.\uc8fc\ubb38\uc77c<\/code> ~\uc744 \ud1b5\ud574 <code>TO_CHAR<\/code>\ub610\ud55c \ub2e4\uc74c\uacfc \uac19\uc740 \ub0b4\uc6a9\ub3c4 \uae30\ub85d\ub418\uc5b4 \uc788\uc2b5\ub2c8\ub2e4. <code>o.\uc0c1\ud0dc<\/code>, <code>\uc8fc\ubb38 \ub0a0\uc9dc<\/code>\uadf8\ub9ac\uace0 \ub9e4\uac1c\ubcc0\uc218 <code>p_load_date<\/code> \uacb0\uacfc\ub97c \ud1b5\ud574 \ud615\uc131\ud558\ub2e4 <code>\uc5b4\ub514<\/code> \uc870\ud56d, \uadf8\ub9ac\uace0 \uc808\ucc28\uac00 \uadf8 \uc548\uc5d0 \uc788\ub2e4\ub294 \uac83\uc785\ub2c8\ub2e4. <code>\ud310\ub9e4_etl<\/code> \ud638\ucd9c \uadf8\ub798\ud504\uc758 \ud328\ud0a4\uc9c0. \ubd80\ub3d9\uc0b0\uc5d0 \uc788\ub294 \uc218\ubc31 \uac1c\uc758 \ud504\ub85c\uc2dc\uc800\uc5d0 \uc774\ub97c \uacf1\ud558\uba74 \uc218\ub3d9 \ubb38\uc11c\ub85c\ub294 \uc808\ub300 \ucd5c\uc2e0 \uc0c1\ud0dc\ub85c \uc720\uc9c0\ud560 \uc218 \uc5c6\ub294 \uc885\uc18d\uc131 \ub9f5\uc774 \ub9cc\ub4e4\uc5b4\uc9d1\ub2c8\ub2e4.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">\ub3d9\uc801 SQL: EXECUTE IMMEDIATE\uc758 \uc0ac\uac01\uc9c0\ub300<\/h2>\n\n\n\n<p>Oracle \ud300\uc740 \ud30c\ud2f0\uc158 \uc774\ub984\uc73c\ub85c \ud14c\uc774\ube14\uc744 \ub85c\ub4dc\ud558\uace0, \ud504\ub85c\uc2dc\uc800\uc5d0\uc11c DDL\uc744 \uc801\uc6a9\ud558\uace0, \uad6c\uc131 \ud589\uc5d0 \ub530\ub77c \ub300\uc0c1\uc774 \ub2ec\ub77c\uc9c0\ub294 \ubb38\uc744 \uc791\uc131\ud558\ub294 \ub4f1 \ub3d9\uc801 SQL\uc744 \ub04a\uc784\uc5c6\uc774 \uc0ac\uc6a9\ud569\ub2c8\ub2e4. \ub300\ubd80\ubd84\uc758 \ucf54\ub4dc \uacc4\ubcf4 \ucd94\ucd9c\uc740 \uc774\ub7ec\ud55c \ucf54\ub4dc\uc5d0\uc11c \uc2e4\ud328\ud569\ub2c8\ub2e4.<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>v_sql := &#039;INSERT INTO mart.revenue_archive (day_id, region_name, total_amount) SELECT day_id, region_name, total_amount FROM mart.revenue_daily WHERE day_id = :d&#039;; EXECUTE IMMEDIATE v_sql USING v_day_id;<\/code><\/pre>\n\n\n\n<p>SQLFlow\ub294 \ud504\ub85c\uc2dc\uc800 \ub0b4\uc758 \ub3d9\uc801 SQL\uc744 \ud574\uc11d\ud558\uace0 \uc870\ub9bd\ub41c \ubb38\uc744 \ubd84\uc11d\ud558\ubbc0\ub85c, \uadf8 \ud750\ub984\uc740 \ub2e4\uc74c\uacfc \uac19\uc2b5\ub2c8\ub2e4. <code>\ub9c8\ud2b8.\uc77c\uc77c\uc218\uc775<\/code> ~ \uc548\uc73c\ub85c <code>\ub9c8\ud2b8.\uc218\uc775_\uc544\uce74\uc774\ube0c<\/code> \uc870\uc6a9\ud788 \ubc84\ub824\uc9c0\ub294 \ub300\uc2e0 \ud3ec\ucc29\ub429\ub2c8\ub2e4. \uadc0\ud558\uc758 \uc7ac\uc0b0\uc774 \uc0ac\uc6a9\ud558\ub294 \uacbd\uc6b0 <code>\uc989\uc2dc \uc2e4\ud589<\/code> \uc5b4\ub5a4 \uacc4\ubcf4 \ub3c4\uad6c\ub97c \uc2e0\ub8b0\ud558\uae30 \uc804\uc5d0 \ubc18\ub4dc\uc2dc \ud655\uc778\ud574\uc57c \ud560 \uc720\uc77c\ud55c \uae30\ub2a5\uc740 \ubc14\ub85c \uc774\uac83\uc785\ub2c8\ub2e4. \uc9c1\uc811 \uc791\uc131\ud55c \ub3d9\uc801 SQL \ud504\ub85c\uc2dc\uc800 \uc911 \ud558\ub098\ub97c \ud574\ub2f9 \ub3c4\uad6c\ub97c \ud1b5\ud574 \uc2e4\ud589\ud558\uace0 \ub300\uc0c1 \ud14c\uc774\ube14\uc774 \uadf8\ub798\ud504\uc5d0 \ub098\ud0c0\ub098\ub294\uc9c0 \ud655\uc778\ud558\ub294 \uac83\uc785\ub2c8\ub2e4.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">\uc624\ub77c\ud074 \ucf54\ub4dc\uc758 \uc9c1\uc811 \ubc0f \uac04\uc811 \uacc4\ubcf4<\/h2>\n\n\n\n<p>SQLFlow\ub294 \uad6c\ubcc4\ud569\ub2c8\ub2e4 <strong>\uc9c1\uacc4 \ud608\ud1b5<\/strong> (\uc6d0\ubcf8 \uc5f4\uc758 \uac12\uc774 \ub300\uc0c1 \uc5f4\uc5d0 \uc800\uc7a5\ub428) <strong>\uac04\uc811 \ud608\ud1b5<\/strong> (\uc5f4\uc774 \uacb0\uacfc\ub97c \ud1b5\ud574 \uc548\ub0b4\ud569\ub2c8\ub2e4) <code>\uc5b4\ub514<\/code> \uc220\ubd80, <code>\uac00\uc785\ud558\ub2e4<\/code> \uc0c1\ud0dc, <code>\uadf8\ub8f9\ud654 \uae30\uc900<\/code>(\ub610\ub294 \ucd9c\ub825\uc5d0 \ub098\ud0c0\ub098\uc9c0 \uc54a\ub3c4\ub85d \uc9d1\uacc4\ud560 \uc218\ub3c4 \uc788\uc2b5\ub2c8\ub2e4.) \uc704 \uc608\uc2dc\uc5d0\uc11c, <code>\uc8fc\ubb38 \uc0c1\ud0dc<\/code> \ub9c8\ud2b8\uc5d0 \ub3c4\ub2ec\ud558\uc9c0 \uc54a\uc9c0\ub9cc, \uac12\uc744 \ubcc0\uacbd\ud558\uba74 \ub9c8\ud2b8 \uc548\uc758 \ubaa8\ub4e0 \uc22b\uc790\uac00 \ubcc0\uacbd\ub429\ub2c8\ub2e4. \ub450 \uac00\uc9c0 \uad00\uacc4 \uc720\ud615\uc740 \ub2e4\uc774\uc5b4\uadf8\ub7a8\uc5d0\uc11c \uac1c\ubcc4\uc801\uc73c\ub85c \uc804\ud658\ud560 \uc218 \uc788\uc73c\ubbc0\ub85c \uc601\ud5a5 \ubd84\uc11d\uc5d0\uc11c \ud544\ud130 \uc804\uc6a9 \uc885\uc18d\uc131\uc744 \uc758\ub3c4\uc801\uc73c\ub85c \ud3ec\ud568\ud558\uac70\ub098 \uc81c\uc678\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4. \ub300\ubd80\ubd84\uc758 \uacbd\uc7c1 \ub3c4\uad6c\ub294 \uc774\ub7ec\ud55c \uad6c\ubd84\uc744 \ubaa8\ub378\ub9c1\ud558\uc9c0 \uc54a\uc544 \uc601\ud5a5 \ubd84\uc11d \ubc94\uc704\uac00 \ub108\ubb34 \uc881\uac70\ub098(\ud544\ud130 \uc5f4 \ub204\ub77d) \ub108\ubb34 \ubcf5\uc7a1\ud569\ub2c8\ub2e4(\ubaa8\ub4e0 \uac83\uc774 \uc11c\ub85c \uc5f0\uacb0\ub428).<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Oracle \ucf54\ub4dc\ub97c SQLFlow\ub85c \uac00\uc838\uc624\uae30<\/h2>\n\n\n\n<figure class=\"wp-block-table\"><table><thead><tr><th>\uc785\ub825 \ubc29\uc2dd<\/th><th>\uc5b8\uc81c \uc0ac\uc6a9\ud574\uc57c \ud560\uae4c\uc694?<\/th><\/tr><\/thead><tbody>\n<tr><td>SQL \ub610\ub294 PL\/SQL\uc744 \ubd99\uc5ec\ub123\uc73c\uc138\uc694<\/td><td>\ube0c\ub77c\uc6b0\uc800\uc5d0\uc11c \ud2b9\uc815 \ud328\ud0a4\uc9c0, \uc808\ucc28 \ub610\ub294 \uc2a4\ud06c\ub9bd\ud2b8\uc5d0 \ub300\ud55c \ube60\ub978 \ud655\uc778<\/td><\/tr>\n<tr><td>\ud30c\uc77c \uc5c5\ub85c\ub4dc<\/td><td>\ub0b4\ubcf4\ub0b8 DDL \ubc0f PL\/SQL \uc18c\uc2a4 \ucf54\ub4dc\ub97c \uc77c\uad04 \ubd84\uc11d<\/td><\/tr>\n<tr><td>JDBC \uc2e4\uc2dc\uac04 \uc5f0\uacb0<\/td><td>\ub370\uc774\ud130\ubca0\uc774\uc2a4\uc5d0\uc11c \uc2a4\ud0a4\ub9c8 \uba54\ud0c0\ub370\uc774\ud130, \ubdf0 \uc815\uc758 \ubc0f \uc800\uc7a5\ub41c \ucf54\ub4dc\ub97c \uc9c1\uc811 \uac00\uc838\uc635\ub2c8\ub2e4.<\/td><\/tr>\n<tr><td>Grabit \uba54\ud0c0\ub370\uc774\ud130 \ucd94\ucd9c<\/td><td>Grabit \ubcf4\uc870 \ub3c4\uad6c\ub97c \uc0ac\uc6a9\ud558\uc5ec \uba54\ud0c0\ub370\uc774\ud130\ub97c \ucd94\ucd9c\ud558\uace0 SQLFlow\uc5d0 \uc785\ub825\ud569\ub2c8\ub2e4.<\/td><\/tr>\n<\/tbody><\/table><\/figure>\n\n\n\n<p>\uc5b4\ub5a4 \ubc29\ubc95\uc744 \uc120\ud0dd\ud558\ub4e0 SQLFlow\ub294 SQL \ubc0f PL\/SQL \ud14d\uc2a4\ud2b8\uc640 \uc2a4\ud0a4\ub9c8 \uba54\ud0c0\ub370\uc774\ud130\uc5d0 \ub300\ud55c \uc815\uc801 \ubd84\uc11d\uc744 \uc218\ud589\ud569\ub2c8\ub2e4. \ud14c\uc774\ube14\uc758 \ud589\uc740 \uc808\ub300 \uc77d\uc9c0 \uc54a\uc2b5\ub2c8\ub2e4. \uc740\ud589 \ubc0f \uae30\ud0c0 \uaddc\uc81c \ub300\uc0c1 Oracle \ud658\uacbd\uc758 \uacbd\uc6b0, <a href=\"https:\/\/www.gudusoft.com\/ko\/sqlflow-on-premise-%eb%b2%84%ec%a0%84\/\">\uc628\ud504\ub808\ubbf8\uc2a4 \uc5d0\ub514\uc158<\/a> Docker \ub610\ub294 Kubernetes \ud658\uacbd\uc5d0\uc11c \ub124\ud2b8\uc6cc\ud06c \ub0b4\uc5d0\uc11c \uc2e4\ud589\ub418\uba70, \uc644\uc804\ud55c \uc5d0\uc5b4\uac2d \ud658\uacbd\uc744 \uc9c0\uc6d0\ud558\ubbc0\ub85c \uc18c\uc2a4 \ucf54\ub4dc\ub294 \uc778\ud504\ub77c \uc678\ubd80\ub85c \uc720\ucd9c\ub418\uc9c0 \uc54a\uc2b5\ub2c8\ub2e4. \uc5d4\ud130\ud504\ub77c\uc774\uc988 \uaddc\ubaa8\uc5d0\uc11c\ub294 100\uac1c \uc774\uc0c1\uc758 \ub370\uc774\ud130\ubca0\uc774\uc2a4\uc640 \ubc31\ub9cc \uac1c \uc774\uc0c1\uc758 \uc5f4\uc744 \ud3ec\ud568\ud558\ub294 \ub300\uaddc\ubaa8 \ud658\uacbd\uc744 \uc77c\uad04 \uc2a4\uce94\ud560 \uc218 \uc788\uc73c\uba70, \uc99d\ubd84 \uc2a4\uce94 \uae30\ub2a5\uacfc DataHub, Microsoft Purview, OpenMetadata\uc6a9 \ub0b4\ubcf4\ub0b4\uae30 \uc5b4\ub311\ud130\ub3c4 \uc81c\uacf5\ud569\ub2c8\ub2e4.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Oracle \ub9c8\uc774\uadf8\ub808\uc774\uc158 \ubc0f \ud63c\ud569 \ud658\uacbd<\/h2>\n\n\n\n<p>\ub9ac\ub2c8\uc9c0\ub294 \uc624\ub77c\ud074 \ud658\uacbd\uc774 \uc9c1\uba74\ud558\ub294 \uac00\uc7a5 \uc911\uc694\ud55c \uc2dc\uc810, \uc989 \ub9c8\uc774\uadf8\ub808\uc774\uc158 \uc2dc\uc810\uc5d0 \uac00\uc7a5 \ud070 \uac00\uce58\ub97c \uc9c0\ub2d9\ub2c8\ub2e4. \uc6cc\ud06c\ub85c\ub4dc\ub97c Snowflake, BigQuery \ub610\ub294 Databricks\ub85c \uc774\uc804\ud558\uae30 \uc804\uc5d0 \ub9ac\ub2c8\uc9c0 \uadf8\ub798\ud504\ub97c \ud1b5\ud574 \ube44\uc988\ub2c8\uc2a4\uc5d0\uc11c \uc0ac\uc6a9\ud558\ub294 \ubcf4\uace0\uc11c\ub97c \uc2e4\uc81c\ub85c \uc81c\uacf5\ud558\ub294 \ud328\ud0a4\uc9c0\uac00 \ubb34\uc5c7\uc778\uc9c0, \ub354 \uc774\uc0c1 \uc0ac\uc6a9\ub418\uc9c0 \uc54a\ub294 \ud14c\uc774\ube14\uc740 \ubb34\uc5c7\uc778\uc9c0, \uadf8\ub9ac\uace0 \uac1d\uccb4\ub97c \uc5b4\ub5a4 \uc21c\uc11c\ub85c \uc774\ub3d9\ud574\uc57c \ud558\ub294\uc9c0 \ud30c\uc545\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4. \ub9c8\uc774\uadf8\ub808\uc774\uc158 \ud6c4 \uc0c8 \ud50c\ub7ab\ud3fc\uc5d0\uc11c \ubd84\uc11d\uc744 \ub2e4\uc2dc \uc2e4\ud589\ud558\uba74 \uace0\uc544 \uac1d\uccb4\uac00 \uc5c6\ub294\uc9c0 \ud655\uc778\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4. SQLFlow\ub294 \ubc29\uc5b8\ubcc4 \ubb38\ubc95\uc744 \uc0ac\uc6a9\ud558\ub294 39\uac1c\uc758 \ubc29\uc5b8\uc744 \ubd84\uc11d\ud558\ubbc0\ub85c \ub3d9\uc77c\ud55c \ub3c4\uad6c\ub85c \ub9c8\uc774\uadf8\ub808\uc774\uc158\uc758 \uc2dc\uc791\uacfc \ub05d\uc744 \ubaa8\ub450 \ucc98\ub9ac\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n\n\n\n<p>\ub300\uaddc\ubaa8 \uc790\uc0b0 \uad00\ub9ac \uc2dc\uc2a4\ud15c \uc911 \uc624\ub77c\ud074\ub9cc \uc0ac\uc6a9\ud558\ub294 \uacbd\uc6b0\ub294 \ub4dc\ubb45\ub2c8\ub2e4. \ub3d9\uc77c\ud55c \uc808\ucc28\uc801 \uad6c\ubb38 \ubd84\uc11d \uae4a\uc774\ub97c \uc0ac\uc6a9\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4. <a href=\"https:\/\/www.gudusoft.com\/ko\/sql-%ec%84%9c%eb%b2%84-%eb%8d%b0%ec%9d%b4%ed%84%b0-%ea%b3%84%eb%b3%b4\/\">SQL Server T-SQL \uacc4\ubcf4<\/a>\uadf8\ub9ac\uace0 \ub2e4\uc74c\uacfc \uac19\uc740 \ucc3d\uace0 \ud50c\ub7ab\ud3fc <a href=\"https:\/\/www.gudusoft.com\/ko\/%ed%85%8c%eb%9d%bc%eb%8d%b0%ec%9d%b4%ed%84%b0-%eb%8d%b0%ec%9d%b4%ed%84%b0-%ea%b3%84%eb%b3%b4\/\">\ud14c\ub77c\ub370\uc774\ud130<\/a> \uac01 \ubc29\uc5b8\ubcc4\ub85c \ud2b9\ud654\ub41c \uad6c\ubb38 \ubd84\uc11d\uae30\ub97c \uac00\uc9c0\uace0 \uc788\uc2b5\ub2c8\ub2e4. \ud558\ub098\uc758 \uacc4\ubcf4 \uc800\uc7a5\uc18c\uc5d0 \uc804\uccb4 \uacc4\ubcf4\ub97c \uc800\uc7a5\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">\uc624\ud508\uc18c\uc2a4 \ud30c\uc11c\uac00 \uc801\ud569\ud55c \uc704\uce58<\/h2>\n\n\n\n<p>\uc624\ud508\uc18c\uc2a4 \ud504\ub85c\uc81d\ud2b8\ub294 \ub2e4\uc74c\uacfc \uac19\uc2b5\ub2c8\ub2e4. <code>sqllineage<\/code> \uadf8\ub9ac\uace0 <code>sqlglot<\/code> \uac1c\ubcc4 \ucffc\ub9ac\ub97c \ubd84\uc11d\ud558\ub294 \ub370\ub294 \uc815\ub9d0 \ud0c1\uc6d4\ud558\uba70, \ub3c5\ub9bd\ud615 SELECT \ubc0f INSERT \ubb38\uc5d0\uc11c \ud14c\uc774\ube14 \uc218\uc900\uc758 \uacc4\ubcf4\ub97c \ucd94\ucd9c\ud558\ub294 \ub370\ub294 \ucda9\ubd84\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4. \uc624\ub77c\ud074 \uc791\uc5c5\uc5d0\uc11c \ubd80\uc871\ud55c \ubd80\ubd84\uc740 \uc808\ucc28\uc801 \uacc4\uce35, \uc989 \ud328\ud0a4\uc9c0 \ubcf8\ubb38, \ub9e4\uac1c\ubcc0\uc218 \ud750\ub984, \ud2b8\ub9ac\uac70 \ub4f1\uc785\ub2c8\ub2e4. <code>\uc989\uc2dc \uc2e4\ud589<\/code> \uc774\ub7ec\ud55c \uad6c\ubb38\ub4e4\uc740 \ubc94\uc6a9 SQL \ud30c\uc11c\uac00 \ucc98\ub9ac\ud558\ub3c4\ub85d \uc124\uacc4\ub418\uc9c0 \uc54a\uc558\uc73c\uba70, \uc624\ub77c\ud074 \ud658\uacbd\uc5d0\uc11c\ub294 \ub300\ubd80\ubd84\uc758 \ubcc0\ud658 \ub85c\uc9c1\uc774 \ubc14\ub85c \uc774\ub7ec\ud55c \uad6c\ubb38\uc5d0 \uc9d1\uc911\ub418\uc5b4 \uc788\uc2b5\ub2c8\ub2e4. \uac00\uc7a5 \uc815\ud655\ud55c \ud3c9\uac00\ub294 \uacbd\ud5d8\uc801\uc778 \uc811\uadfc \ubc29\uc2dd\uc744 \ucde8\ud574\uc57c \ud569\ub2c8\ub2e4. \uac00\uc7a5 \ud070 \ud328\ud0a4\uc9c0 \ubcf8\ubb38\uc744 \uc120\ud0dd\ud558\uc5ec \uc5ec\ub7ec \ub3c4\uad6c\ub97c \ud1b5\ud574 \uc2e4\ud589\ud574 \ubcf4\uace0, \uac01 \ub3c4\uad6c\uac00 \uba87 \uac1c\uc758 \ub300\uc0c1 \ud14c\uc774\ube14\uc744 \ucc3e\uc544\ub0b4\ub294\uc9c0 \uc138\uc5b4\ubcf4\uc2ed\uc2dc\uc624.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">\uc790\uc8fc \ubb3b\ub294 \uc9c8\ubb38<\/h2>\n\n\n\n<h3 class=\"wp-block-heading\">SQLFlow\ub294 Oracle \uc800\uc7a5 \ud504\ub85c\uc2dc\uc800 \ubc0f \ud328\ud0a4\uc9c0\ub97c \ud1b5\ud574 \ucd94\uc801 \uacc4\ubcf4\ub97c \ucd94\uc801\ud560 \uc218 \uc788\uc2b5\ub2c8\uae4c?<\/h3>\n\n\n<p>\uc608. SQLFlow\ub294 Oracle SQL \ud30c\uc11c\uc640\ub294 \ubcc4\ub3c4\ub85c \ud328\ud0a4\uc9c0, \ud504\ub85c\uc2dc\uc800, \ud568\uc218 \ubc0f \ud2b8\ub9ac\uac70\ub97c \ubd84\uc11d\ud558\ub294 \uc804\uc6a9 PL\/SQL \ud30c\uc11c\ub97c \uac16\ucd94\uace0 \uc788\uc2b5\ub2c8\ub2e4. \ud504\ub85c\uc2dc\uc800 \ub9e4\uac1c\ubcc0\uc218\uc640 \uc784\uc2dc \ud14c\uc774\ube14\uc744 \ud1b5\ud574 \uacc4\ubcf4\ub97c \ucd94\uc801\ud560 \uc218 \uc788\uc73c\uba70, \ub300\ud654\ud615 \ud638\ucd9c \uadf8\ub798\ud504\ub97c \ud1b5\ud574 \ud328\ud0a4\uc9c0 \uac04 \ud504\ub85c\uc2dc\uc800 \ud638\ucd9c\uc744 \ud655\uc778\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">SQLFlow\ub294 EXECUTE IMMEDIATE \ub3d9\uc801 SQL\uc744 \ucc98\ub9ac\ud560 \uc218 \uc788\uc2b5\ub2c8\uae4c?<\/h3>\n\n\n<p>\uc608. PL\/SQL \ud504\ub85c\uc2dc\uc800 \ub0b4\uc5d0\uc11c \uad6c\uc131\ub41c \ub3d9\uc801 SQL\uc740 \uac74\ub108\ub6f0\uc9c0 \uc54a\uace0 \ud574\uc11d \ubc0f \ubd84\uc11d\ub418\ubbc0\ub85c, \ub2e4\uc74c\uacfc \uac19\uc774 \uad6c\uc131\ub41c \ubb38\uc740 \uc2e4\ud589\ub429\ub2c8\ub2e4. <code>\uc989\uc2dc \uc2e4\ud589<\/code> \uc18c\uc2a4-\ub300\uc0c1 \ud750\ub984\uc744 \uacc4\ubcf4 \uadf8\ub798\ud504\uc5d0 \ucd94\uac00\ud569\ub2c8\ub2e4.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">SQLFlow\ub294 Oracle \ub370\uc774\ud130\uc5d0 \ub300\ud55c \uc811\uadfc \uad8c\ud55c\uc774 \ud544\uc694\ud55c\uac00\uc694?<\/h3>\n\n\n<p>\uc544\ub2c8\uc694. SQLFlow\ub294 SQL \ubc0f PL\/SQL \ucf54\ub4dc\uc5d0 \ub300\ud55c \uc815\uc801 \ubd84\uc11d\uc744 \uc218\ud589\ud558\uace0 \uc120\ud0dd\uc801\uc73c\ub85c JDBC\ub97c \ud1b5\ud574 \uc2a4\ud0a4\ub9c8 \uba54\ud0c0\ub370\uc774\ud130\ub97c \uc77d\uc2b5\ub2c8\ub2e4. \ud14c\uc774\ube14 \ud589 \ub370\uc774\ud130\ub294 \uc808\ub300 \uc77d\uc9c0 \uc54a\uc2b5\ub2c8\ub2e4. \uc628\ud504\ub808\ubbf8\uc2a4 \ubc84\uc804\uc744 \uc0ac\uc6a9\ud558\ub294 \uacbd\uc6b0 SQL \ud14d\uc2a4\ud2b8\uc870\ucc28\ub3c4 \ub124\ud2b8\uc6cc\ud06c \ub0b4\uc5d0 \uc720\uc9c0\ub429\ub2c8\ub2e4.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">Oracle \ubb34\ub8cc \ubc84\uc804\uc5d0\uc11c \uceec\ub7fc \uc218\uc900 \uacc4\ubcf4 \uae30\ub2a5\uc744 \uc0ac\uc6a9\ud560 \uc218 \uc788\uc2b5\ub2c8\uae4c?<\/h3>\n\n\n<p>\uc608. <a href=\"https:\/\/sqlflow.gudusoft.com\/?utm_source=gudusoft&amp;utm_medium=website&amp;utm_campaign=oracle-data-lineage-tool\">SQLFlow \ud074\ub77c\uc6b0\ub4dc<\/a> \ubb34\ub8cc \ud2f0\uc5b4\uac00 \uc788\uc2b5\ub2c8\ub2e4. \ube0c\ub77c\uc6b0\uc800\uc5d0 Oracle SQL \ub610\ub294 PL\/SQL \ucf54\ub4dc\ub97c \ubd99\uc5ec\ub123\uc73c\uba74 \uc5f4 \uc218\uc900 \uacc4\ubcf4 \ub2e4\uc774\uc5b4\uadf8\ub7a8\uc744 \ubcfc \uc218 \uc788\uc2b5\ub2c8\ub2e4. \ud504\ub9ac\ubbf8\uc5c4\uc740 \uc6d4 $49.99\uc774\uba70, \uc628\ud504\ub808\ubbf8\uc2a4\ub294 \uc6d4 $500 \ub610\ub294 \uc120\ud0dd\ud55c \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc720\ud615\ub2f9 1\ud68c $4,800\uc785\ub2c8\ub2e4. \uc790\uc138\ud55c \ub0b4\uc6a9\uc740 \ub2e4\uc74c\uc744 \ucc38\uc870\ud558\uc138\uc694. <a href=\"https:\/\/www.gudusoft.com\/ko\/%ea%b0%80%ea%b2%a9\/\">\uac00\uaca9<\/a> \uc790\uc138\ud55c \ub0b4\uc6a9\uc740 \ub2e4\uc74c\uc744 \ucc38\uc870\ud558\uc138\uc694.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">Oracle \ub370\uc774\ud130 \uacc4\ubcf4\ub97c \ub370\uc774\ud130 \uce74\ud0c8\ub85c\uadf8\ub85c \ub0b4\ubcf4\ub0bc \uc218 \uc788\uc2b5\ub2c8\uae4c?<\/h3>\n\n\n<p>\uc608. \ub9ac\ub2c8\uc9c0 \ub370\uc774\ud130\ub294 JSON, CSV \ub610\ub294 PNG \ud615\uc2dd\uc73c\ub85c \ub0b4\ubcf4\ub0b4\uc9c0\uba70 REST API\ub97c \ud1b5\ud574 \ucffc\ub9ac\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4. \ub610\ud55c \uc5d4\ud130\ud504\ub77c\uc774\uc988 \ubc30\ud3ec \ud658\uacbd\uc5d0\ub294 DataHub, Microsoft Purview \ubc0f OpenMetadata\uc6a9 \ub0b4\ubcf4\ub0b4\uae30 \uc5b4\ub311\ud130\uac00 \ud3ec\ud568\ub418\uc5b4 \uc788\uc73c\ubbc0\ub85c SQLFlow\ub294 \ud604\uc7ac \uc2e4\ud589 \uc911\uc778 \uce74\ud0c8\ub85c\uadf8\uc758 PL\/SQL \uae30\ubc18 \ub9ac\ub2c8\uc9c0 \uc5d4\uc9c4\uc73c\ub85c \uc0ac\uc6a9\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n\n\n\n<div class=\"wp-block-group alignfull has-background is-layout-constrained\" style=\"background-color:#60d5f6;padding-top:32px;padding-bottom:32px\"><div class=\"wp-block-group__inner-container\">\n\n<h2 class=\"wp-block-heading\">PL\/SQL \ucf54\ub4dc\uc5d0 \uc228\uaca8\uc9c4 \uacc4\ubcf4\ub97c \ud655\uc778\ud558\uc138\uc694<\/h2>\n\n\n<p>\ud328\ud0a4\uc9c0 \ubcf8\ubb38\uc744 \ubb34\ub8cc \uc2dc\uac01\ud654 \ub3c4\uad6c\uc5d0 \ubd99\uc5ec\ub123\uac70\ub098, \uc628\ud504\ub808\ubbf8\uc2a4\uc5d0 \uc788\ub294 \uc804\uccb4 Oracle \ud658\uacbd\uc744 \uc2a4\uce94\ud558\ub294 \uac83\uc5d0 \ub300\ud574 \uc800\ud76c\uc640 \uc0c1\ub2f4\ud574 \ubcf4\uc138\uc694.<\/p>\n\n\n<div class=\"wp-block-buttons is-layout-flex\">\n<div class=\"wp-block-button\"><a class=\"wp-block-button__link wp-element-button\" href=\"https:\/\/sqlflow.gudusoft.com\/?utm_source=gudusoft&amp;utm_medium=website&amp;utm_campaign=oracle-data-lineage-tool\" target=\"_blank\" rel=\"noreferrer noopener\">SQLFlow\ub97c \ubb34\ub8cc\ub85c \uc0ac\uc6a9\ud574 \ubcf4\uc138\uc694.<\/a><\/div>\n\n<div class=\"wp-block-button\"><a class=\"wp-block-button__link wp-element-button\" href=\"https:\/\/www.gudusoft.com\/ko\/%ec%97%b0%eb%9d%bd%ed%95%98%eb%8b%a4\/\">\uae30\uc5c5\uc6a9 \ub370\ubaa8\ub97c \uc694\uccad\ud558\uc138\uc694<\/a><\/div>\n<\/div>\n\n<\/div><\/div>\n\n\n\n<script type=\"application\/ld+json\">{\n    \"@context\": \"https:\\\/\\\/schema.org\",\n    \"@graph\": [\n        {\n            \"@type\": \"SoftwareApplication\",\n            \"name\": \"Gudu SQLFlow\",\n            \"applicationCategory\": \"DeveloperApplication\",\n            \"applicationSubCategory\": \"Oracle Data Lineage Tool\",\n            \"operatingSystem\": \"Web, Linux, Windows, macOS\",\n            \"url\": \"https:\\\/\\\/www.gudusoft.com\\\/oracle-data-lineage-tool\\\/\",\n            \"description\": \"Oracle data lineage tool with a dedicated PL\\\/SQL parser: analyzes packages, procedures, functions, and triggers, resolves EXECUTE IMMEDIATE dynamic SQL, and produces column-level lineage diagrams and procedure call graphs.\",\n            \"featureList\": \"PL\\\/SQL package and procedure analysis, trigger lineage, EXECUTE IMMEDIATE dynamic SQL resolution, procedure call graph, column-level lineage, direct vs indirect lineage, JDBC metadata import, DataHub\\\/Purview\\\/OpenMetadata export\",\n            \"softwareVersion\": \"8.2.3\",\n            \"offers\": [\n                {\n                    \"@type\": \"Offer\",\n                    \"name\": \"SQLFlow Cloud Free\",\n                    \"price\": \"0\",\n                    \"priceCurrency\": \"USD\"\n                },\n                {\n                    \"@type\": \"Offer\",\n                    \"name\": \"SQLFlow Cloud Premium\",\n                    \"price\": \"49.99\",\n                    \"priceCurrency\": \"USD\",\n                    \"priceSpecification\": {\n                        \"@type\": \"UnitPriceSpecification\",\n                        \"price\": \"49.99\",\n                        \"priceCurrency\": \"USD\",\n                        \"billingIncrement\": 1,\n                        \"unitText\": \"MONTH\"\n                    }\n                },\n                {\n                    \"@type\": \"Offer\",\n                    \"name\": \"SQLFlow On-Premise\",\n                    \"price\": \"4800\",\n                    \"priceCurrency\": \"USD\"\n                }\n            ],\n            \"publisher\": {\n                \"@type\": \"Organization\",\n                \"name\": \"Gudu Software\",\n                \"url\": \"https:\\\/\\\/www.gudusoft.com\\\/\"\n            }\n        },\n        {\n            \"@type\": \"FAQPage\",\n            \"mainEntity\": [\n                {\n                    \"@type\": \"Question\",\n                    \"name\": \"Can SQLFlow trace lineage through Oracle stored procedures and packages?\",\n                    \"acceptedAnswer\": {\n                        \"@type\": \"Answer\",\n                        \"text\": \"Yes. SQLFlow has a dedicated PL\\\/SQL parser, separate from its Oracle SQL parser, that analyzes packages, procedures, functions, and triggers. Lineage is traced through procedure parameters and temp tables, and an interactive call graph shows procedure-to-procedure invocations across packages.\"\n                    }\n                },\n                {\n                    \"@type\": \"Question\",\n                    \"name\": \"Does SQLFlow handle EXECUTE IMMEDIATE dynamic SQL?\",\n                    \"acceptedAnswer\": {\n                        \"@type\": \"Answer\",\n                        \"text\": \"Yes. Dynamic SQL assembled inside PL\\\/SQL procedures is resolved and analyzed rather than skipped, so statements built with EXECUTE IMMEDIATE contribute their source-to-target flows to the lineage graph.\"\n                    }\n                },\n                {\n                    \"@type\": \"Question\",\n                    \"name\": \"Does SQLFlow need access to my Oracle data?\",\n                    \"acceptedAnswer\": {\n                        \"@type\": \"Answer\",\n                        \"text\": \"No. SQLFlow performs static analysis of SQL and PL\\\/SQL code and optionally reads schema metadata over JDBC. It never reads table row data. With the On-Premise edition, even the SQL text stays inside your network.\"\n                    }\n                },\n                {\n                    \"@type\": \"Question\",\n                    \"name\": \"Is Oracle column-level lineage available in the free version?\",\n                    \"acceptedAnswer\": {\n                        \"@type\": \"Answer\",\n                        \"text\": \"Yes. SQLFlow Cloud has a free tier: paste Oracle SQL or PL\\\/SQL in the browser and get column-level lineage diagrams. Premium is $49.99\\\/month; On-Premise is $500\\\/month or $4,800 one-time per selected database type.\"\n                    }\n                },\n                {\n                    \"@type\": \"Question\",\n                    \"name\": \"Can I export Oracle lineage to a data catalog?\",\n                    \"acceptedAnswer\": {\n                        \"@type\": \"Answer\",\n                        \"text\": \"Yes. Lineage exports as JSON, CSV, or PNG, is queryable over a REST API, and enterprise deployments include export adapters for DataHub, Microsoft Purview, and OpenMetadata, so SQLFlow can serve as the PL\\\/SQL-aware lineage engine behind the catalog you already run.\"\n                    }\n                }\n            ]\n        }\n    ]\n}<\/script>","protected":false},"excerpt":{"rendered":"<p>Oracle data lineage is the column-level map of how data moves through an Oracle estate: which source tables and columns feed each target table, view, or materialized view, and which PL\/SQL packages, procedures, functions, and triggers do the moving. Because in most Oracle shops the transformation logic lives in PL\/SQL rather than in standalone queries, accurate lineage requires a tool that parses PL\/SQL as a procedural language, not just Oracle SQL. Gudu SQLFlow ships a dedicated PL\/SQL parser that does exactly that, including dynamic SQL built with EXECUTE IMMEDIATE. Test it on your own code: paste an Oracle package body\u2026<\/p>","protected":false},"author":1,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":[],"blocksy_meta":{"styles_descriptor":{"styles":{"desktop":"","tablet":"","mobile":""},"google_fonts":[],"version":5}},"_links":{"self":[{"href":"https:\/\/www.gudusoft.com\/ko\/wp-json\/wp\/v2\/pages\/3136"}],"collection":[{"href":"https:\/\/www.gudusoft.com\/ko\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/www.gudusoft.com\/ko\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/www.gudusoft.com\/ko\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.gudusoft.com\/ko\/wp-json\/wp\/v2\/comments?post=3136"}],"version-history":[{"count":95,"href":"https:\/\/www.gudusoft.com\/ko\/wp-json\/wp\/v2\/pages\/3136\/revisions"}],"predecessor-version":[{"id":6755,"href":"https:\/\/www.gudusoft.com\/ko\/wp-json\/wp\/v2\/pages\/3136\/revisions\/6755"}],"wp:attachment":[{"href":"https:\/\/www.gudusoft.com\/ko\/wp-json\/wp\/v2\/media?parent=3136"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}