{"id":429,"date":"2021-04-13T11:53:53","date_gmt":"2021-04-13T02:53:53","guid":{"rendered":"http:\/\/dev.e-luda.com\/dev-note\/?p=638"},"modified":"2022-04-22T14:32:15","modified_gmt":"2022-04-22T05:32:15","slug":"oracle-table-column-%ec%a0%95%eb%b3%b4-%ec%a1%b0%ed%9a%8c1","status":"publish","type":"post","link":"http:\/\/dev.e-luda.com\/dev-note\/?p=429","title":{"rendered":"oracle table, column \uc815\ubcf4 \uc870\ud68c1"},"content":{"rendered":"\n<div class=\"wp-block-codemirror-blocks-code-block code-block\"><pre class=\"CodeMirror\" data-setting=\"{&quot;mode&quot;:&quot;sql&quot;,&quot;mime&quot;:&quot;text\/x-sql&quot;,&quot;theme&quot;:&quot;material&quot;,&quot;lineNumbers&quot;:false,&quot;styleActiveLine&quot;:false,&quot;lineWrapping&quot;:false,&quot;readOnly&quot;:true,&quot;language&quot;:&quot;SQL&quot;,&quot;modeName&quot;:&quot;sql&quot;}\">SELECT SUBSTR(a.TABLE_NAME,0,2) AS &quot;\uc5c5\ubb34\uad6c\ubd84&quot;\n     , a.TABLE_NAME AS &quot;\ud14c\uc774\ube14\uba85&quot;\n     , b.COMMENTS AS &quot;\ud14c\uc774\ube14\ud55c\uae00\uba85&quot;\n     , a.COLUMN_ID AS &quot;\uceec\ub7fc\uc21c\ubc88&quot;\n     , a.COLUMN_NAME AS &quot;\uceec\ub7fc\uba85&quot;\n     , c.COMMENTS AS &quot;\uceec\ub7fc\ud55c\uae00\uba85&quot;\n     , a.DATA_TYPE AS &quot;\ud0c0\uc785&quot;\n     , CASE WHEN NVL(a.DATA_SCALE,0) = 0 THEN TO_CHAR(a.DATA_LENGTH)\n            ELSE a.DATA_LENGTH||'('||a.DATA_SCALE||')'\n       END AS &quot;\uae38\uc774&quot;\n     , CASE WHEN d.COLUMN_NAME IS NOT NULL THEN TO_CHAR(d.KEY_SEQ)\n            ELSE ''\n       END AS &quot;KEY&quot;\n     , CASE WHEN a.nullable = 'N' THEN 'Y'\n            ELSE ''\n       END AS &quot;NOT NULL&quot;\n     , a.DATA_DEFAULT AS &quot;\ucd08\uae30\uac12&quot;\n  FROM ALL_TAB_COLUMNS a\n INNER JOIN ALL_TAB_COMMENTS b\n    ON a.OWNER = b.OWNER\n   AND a.TABLE_NAME = b.TABLE_NAME\n  LEFT OUTER JOIN ALL_COL_COMMENTS c\n    ON a.OWNER = c.OWNER\n   AND a.TABLE_NAME = c.TABLE_NAME\n   AND a.COLUMN_NAME = c.COLUMN_NAME\n  LEFT OUTER JOIN (\n       SELECT ia.OWNER\n            , ia.TABLE_NAME\n            , ib.COLUMN_NAME\n            , ib.POSITION AS KEY_SEQ\n         FROM ALL_CONSTRAINTS ia\n        INNER JOIN ALL_CONS_COLUMNS ib\n           ON ia.OWNER  = ib.OWNER\n          AND ia.TABLE_NAME = ib.TABLE_NAME\n          AND ia.CONSTRAINT_NAME = ib.CONSTRAINT_NAME\n          AND ia.CONSTRAINT_TYPE = 'P'\n       ) d\n    ON a.OWNER = d.OWNER\n   AND a.TABLE_NAME = d.TABLE_NAME\n   AND a.COLUMN_NAME = d.COLUMN_NAME\n WHERE a.OWNER = 'SEMA_ERP' \/* bx-erp : ERP, semis : SEMA_OWN  *\/\n   AND a.TABLE_NAME LIKE '%_HIST%' \/*\uc870\ud68c\ud560 Table\uba85*\/\n--   AND a.TABLE_NAME = 'AM_CARDCONFMDTALSRECPT' \/*\uc870\ud68c\ud560 Table\uba85*\/\n--   AND b.COMMENTS LIKE '%\uc6d0\ucc9c\uc9d5\uc218%' \/*\uc870\ud68c\ud560 Table\uba85*\/\n--   AND a.TABLE_NAME  = 'AM_SLIP_WRT_M'\n--   AND a.COLUMN_NAME LIKE '%ACNUT_NM_DIV_CD%'\n--    AND c.COMMENTS LIKE '%\ud1b5\ud654%\ucf54\ub4dc%'\n--   AND a.column_name NOT LIKE '%#_%'ESCAPE'#'\n-- ORDER BY a.TABLE_NAME\n--     , a.COLUMN_ID\nORDER BY a.TABLE_NAME\n    , a.COLUMN_ID\n--    , a.COLUMN_NAME \n;<\/pre><\/div>\n","protected":false},"excerpt":{"rendered":"","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[31],"tags":[],"class_list":["post-429","post","type-post","status-publish","format-standard","hentry","category-oracle"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v18.6 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>oracle table, column \uc815\ubcf4 \uc870\ud68c1 - \ub9c8\ubc95\uc0ac\ub9ac\uc758\uac1c\ubc1c\ub178\ud2b8<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"http:\/\/dev.e-luda.com\/dev-note\/?p=429\" \/>\n<meta property=\"og:locale\" content=\"ko_KR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"oracle table, column \uc815\ubcf4 \uc870\ud68c1 - \ub9c8\ubc95\uc0ac\ub9ac\uc758\uac1c\ubc1c\ub178\ud2b8\" \/>\n<meta property=\"og:url\" content=\"http:\/\/dev.e-luda.com\/dev-note\/?p=429\" \/>\n<meta property=\"og:site_name\" content=\"\ub9c8\ubc95\uc0ac\ub9ac\uc758\uac1c\ubc1c\ub178\ud2b8\" \/>\n<meta property=\"article:published_time\" content=\"2021-04-13T02:53:53+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2022-04-22T05:32:15+00:00\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"wizardlee\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"2\ubd84\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebSite\",\"@id\":\"http:\/\/dev.e-luda.com\/dev-note\/#website\",\"url\":\"http:\/\/dev.e-luda.com\/dev-note\/\",\"name\":\"\ub9c8\ubc95\uc0ac\ub9ac\uc758\uac1c\ubc1c\ub178\ud2b8\",\"description\":\"\ub2e4\ub978 \uc6cc\ub4dc\ud504\ub808\uc2a4 \uc0ac\uc774\ud2b8\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"http:\/\/dev.e-luda.com\/dev-note\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"ko-KR\"},{\"@type\":\"WebPage\",\"@id\":\"http:\/\/dev.e-luda.com\/dev-note\/?p=429#webpage\",\"url\":\"http:\/\/dev.e-luda.com\/dev-note\/?p=429\",\"name\":\"oracle table, column \uc815\ubcf4 \uc870\ud68c1 - \ub9c8\ubc95\uc0ac\ub9ac\uc758\uac1c\ubc1c\ub178\ud2b8\",\"isPartOf\":{\"@id\":\"http:\/\/dev.e-luda.com\/dev-note\/#website\"},\"datePublished\":\"2021-04-13T02:53:53+00:00\",\"dateModified\":\"2022-04-22T05:32:15+00:00\",\"author\":{\"@id\":\"http:\/\/dev.e-luda.com\/dev-note\/#\/schema\/person\/7e381f3b46b7824adbe15ff43b53c42c\"},\"breadcrumb\":{\"@id\":\"http:\/\/dev.e-luda.com\/dev-note\/?p=429#breadcrumb\"},\"inLanguage\":\"ko-KR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"http:\/\/dev.e-luda.com\/dev-note\/?p=429\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"http:\/\/dev.e-luda.com\/dev-note\/?p=429#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"http:\/\/dev.e-luda.com\/dev-note\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"oracle table, column \uc815\ubcf4 \uc870\ud68c1\"}]},{\"@type\":\"Person\",\"@id\":\"http:\/\/dev.e-luda.com\/dev-note\/#\/schema\/person\/7e381f3b46b7824adbe15ff43b53c42c\",\"name\":\"wizardlee\",\"image\":{\"@type\":\"ImageObject\",\"@id\":\"http:\/\/dev.e-luda.com\/dev-note\/#personlogo\",\"inLanguage\":\"ko-KR\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/6eaa1dedfb9710f350bbf8ccb317e7cfa2a5a277b535c6558bc57169262ec430?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/6eaa1dedfb9710f350bbf8ccb317e7cfa2a5a277b535c6558bc57169262ec430?s=96&d=mm&r=g\",\"caption\":\"wizardlee\"},\"sameAs\":[\"http:\/\/dev.e-luda.com\/dev-note\"],\"url\":\"http:\/\/dev.e-luda.com\/dev-note\/?author=1\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"oracle table, column \uc815\ubcf4 \uc870\ud68c1 - \ub9c8\ubc95\uc0ac\ub9ac\uc758\uac1c\ubc1c\ub178\ud2b8","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":"http:\/\/dev.e-luda.com\/dev-note\/?p=429","og_locale":"ko_KR","og_type":"article","og_title":"oracle table, column \uc815\ubcf4 \uc870\ud68c1 - \ub9c8\ubc95\uc0ac\ub9ac\uc758\uac1c\ubc1c\ub178\ud2b8","og_url":"http:\/\/dev.e-luda.com\/dev-note\/?p=429","og_site_name":"\ub9c8\ubc95\uc0ac\ub9ac\uc758\uac1c\ubc1c\ub178\ud2b8","article_published_time":"2021-04-13T02:53:53+00:00","article_modified_time":"2022-04-22T05:32:15+00:00","twitter_card":"summary_large_image","twitter_misc":{"Written by":"wizardlee","Est. reading time":"2\ubd84"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebSite","@id":"http:\/\/dev.e-luda.com\/dev-note\/#website","url":"http:\/\/dev.e-luda.com\/dev-note\/","name":"\ub9c8\ubc95\uc0ac\ub9ac\uc758\uac1c\ubc1c\ub178\ud2b8","description":"\ub2e4\ub978 \uc6cc\ub4dc\ud504\ub808\uc2a4 \uc0ac\uc774\ud2b8","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"http:\/\/dev.e-luda.com\/dev-note\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"ko-KR"},{"@type":"WebPage","@id":"http:\/\/dev.e-luda.com\/dev-note\/?p=429#webpage","url":"http:\/\/dev.e-luda.com\/dev-note\/?p=429","name":"oracle table, column \uc815\ubcf4 \uc870\ud68c1 - \ub9c8\ubc95\uc0ac\ub9ac\uc758\uac1c\ubc1c\ub178\ud2b8","isPartOf":{"@id":"http:\/\/dev.e-luda.com\/dev-note\/#website"},"datePublished":"2021-04-13T02:53:53+00:00","dateModified":"2022-04-22T05:32:15+00:00","author":{"@id":"http:\/\/dev.e-luda.com\/dev-note\/#\/schema\/person\/7e381f3b46b7824adbe15ff43b53c42c"},"breadcrumb":{"@id":"http:\/\/dev.e-luda.com\/dev-note\/?p=429#breadcrumb"},"inLanguage":"ko-KR","potentialAction":[{"@type":"ReadAction","target":["http:\/\/dev.e-luda.com\/dev-note\/?p=429"]}]},{"@type":"BreadcrumbList","@id":"http:\/\/dev.e-luda.com\/dev-note\/?p=429#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"http:\/\/dev.e-luda.com\/dev-note"},{"@type":"ListItem","position":2,"name":"oracle table, column \uc815\ubcf4 \uc870\ud68c1"}]},{"@type":"Person","@id":"http:\/\/dev.e-luda.com\/dev-note\/#\/schema\/person\/7e381f3b46b7824adbe15ff43b53c42c","name":"wizardlee","image":{"@type":"ImageObject","@id":"http:\/\/dev.e-luda.com\/dev-note\/#personlogo","inLanguage":"ko-KR","url":"https:\/\/secure.gravatar.com\/avatar\/6eaa1dedfb9710f350bbf8ccb317e7cfa2a5a277b535c6558bc57169262ec430?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/6eaa1dedfb9710f350bbf8ccb317e7cfa2a5a277b535c6558bc57169262ec430?s=96&d=mm&r=g","caption":"wizardlee"},"sameAs":["http:\/\/dev.e-luda.com\/dev-note"],"url":"http:\/\/dev.e-luda.com\/dev-note\/?author=1"}]}},"_links":{"self":[{"href":"http:\/\/dev.e-luda.com\/dev-note\/index.php?rest_route=\/wp\/v2\/posts\/429","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/dev.e-luda.com\/dev-note\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/dev.e-luda.com\/dev-note\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/dev.e-luda.com\/dev-note\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/dev.e-luda.com\/dev-note\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=429"}],"version-history":[{"count":1,"href":"http:\/\/dev.e-luda.com\/dev-note\/index.php?rest_route=\/wp\/v2\/posts\/429\/revisions"}],"predecessor-version":[{"id":553,"href":"http:\/\/dev.e-luda.com\/dev-note\/index.php?rest_route=\/wp\/v2\/posts\/429\/revisions\/553"}],"wp:attachment":[{"href":"http:\/\/dev.e-luda.com\/dev-note\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=429"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/dev.e-luda.com\/dev-note\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=429"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/dev.e-luda.com\/dev-note\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=429"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}