{"id":11974,"date":"2022-10-03T17:17:04","date_gmt":"2022-10-03T08:17:04","guid":{"rendered":"https:\/\/prodskill.com\/?p=11974"},"modified":"2022-10-05T00:13:54","modified_gmt":"2022-10-04T15:13:54","slug":"oracle-character-set-migration-10-convert-clob","status":"publish","type":"post","link":"https:\/\/prodskill.com\/ko\/oracle-character-set-migration-10-convert-clob\/","title":{"rendered":"Oracle Character Set \ubcc0\ud658(10): 6.3. CLOB type \ud55c\uae00 \ubcc0\ud658 \ubc29\ubc95"},"content":{"rendered":"\n<p>CLOB type \ud55c\uae00 \ubcc0\ud658 \ubc29\ubc95 \uc5d0 \ub300\ud574 \uc0b4\ud3b4\ubcf8\ub2e4. US7ASCII character set DB\uc5d0\uc11c \ud55c\uae00\uc774 \ud3ec\ud568\ub41c CLOB type\uc744 AL32UTF8\ub85c \ubcc0\ud658\ud558\ub294 \ubc29\ubc95\uacfc \ubcc0\ud658 \uacb0\uacfc\ub97c \ud655\uc778\ud560 \uc218 \uc788\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\/oracle-character-set-migration-9-dblink-ctas-utl_raw\/\">Oracle Character Set \ubcc0\ud658(9): 6. \uc0ac\uc6a9\uc790 \uad6c\ud604 Character Set \ubcc0\ud658 \ubc29\ubc95 (2)<\/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=\"\ubaa9\ucc28 \ud1a0\uae00\"><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-3'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/prodskill.com\/ko\/oracle-character-set-migration-10-convert-clob\/#63_CLOB_type_%ED%95%9C%EA%B8%80_%EB%B3%80%ED%99%98_%EB%B0%A9%EB%B2%95\" >6.3. CLOB type \ud55c\uae00 \ubcc0\ud658 \ubc29\ubc95<\/a><ul class='ez-toc-list-level-4' ><li class='ez-toc-heading-level-4'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/prodskill.com\/ko\/oracle-character-set-migration-10-convert-clob\/#631_CLOB_%EB%8D%B0%EC%9D%B4%ED%84%B0_%ED%99%95%EC%9D%B8\" >6.3.1. CLOB \ub370\uc774\ud130 \ud655\uc778<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-4'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/prodskill.com\/ko\/oracle-character-set-migration-10-convert-clob\/#632_CLOB_%EB%8D%B0%EC%9D%B4%ED%84%B0_%EB%B3%80%ED%99%98\" >6.3.2. CLOB \ub370\uc774\ud130 \ubcc0\ud658<\/a><\/li><\/ul><\/li><\/ul><\/nav><\/div>\n<h3 class=\"wp-block-heading\" id=\"6.3._CLOB_\ubcc0\ud658_\ubc29\ubc95\"><span class=\"ez-toc-section\" id=\"63_CLOB_type_%ED%95%9C%EA%B8%80_%EB%B3%80%ED%99%98_%EB%B0%A9%EB%B2%95\"><\/span>6.3. CLOB type \ud55c\uae00 \ubcc0\ud658 \ubc29\ubc95<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p><a href=\"https:\/\/prodskill.com\/oracle-character-set-migration-8-datapump-export-import\/\">Oracle Character Set \ubcc0\ud658(8): 6. \uc0ac\uc6a9\uc790 \uad6c\ud604 Character Set \ubcc0\ud658 \ubc29\ubc95 (1)<\/a><\/p>\n\n\n\n<p>\uc704 \uae00\uc5d0\uc11c \ub2e4\uc74c\uacfc \uac19\uc740 \ub0b4\uc6a9\uc744 \uc5b8\uae09\ud588\uc5c8\ub2e4.<\/p>\n\n\n\n<blockquote class=\"wp-block-quote is-layout-flow wp-block-quote-is-layout-flow\"><p>\ucc38\uace0\ub85c,&nbsp;US7ASCII&nbsp;to&nbsp;AL32UTF8&nbsp;\ubcc0\ud658\uc758&nbsp;\uacbd\uc6b0\ub294&nbsp;CLOB&nbsp;type&nbsp;\uceec\ub7fc\uc774&nbsp;\uc815\uc0c1\uc801\uc73c\ub85c&nbsp;\ubcc0\ud658\ub418\uc9c0&nbsp;\uc54a\uc544&nbsp;\ubcc4\ub3c4&nbsp;\ucc98\ub9ac\uac00&nbsp;\ud544\uc694\ud558\ub2e4.<br>\ub2e4\uc74c \uae00\uc5d0\uc11c \uc124\uba85 \uc608\uc815\uc774\ub2e4.<\/p><\/blockquote>\n\n\n\n<p>\uc774 \uae00\uc5d0\uc11c US7ASCII \uc5d0\uc11c AL32UTF8\ub85c DB Link\ub97c \uc774\uc6a9\ud558\uc5ec \ud55c\uae00\uc774 \ud3ec\ud568\ub41c CLOB type\uc744 AL32UTF8\ub85c \ubcc0\ud658\ud558\ub294 \ubc29\ubc95\uc744 \uc124\uba85\ud55c\ub2e4. Oracle \uae30\ubcf8 package\uc778 DBMS_LOB\uc744 \ud65c\uc6a9\ud55c\ub2e4.<\/p>\n\n\n\n<p>\uba3c\uc800 ORAUS7, ORAMSWIN949, ORAUTF \uc138 \uac1c instance\uc5d0\uc11c CLOB \ub370\uc774\ud130\ub97c \ud655\uc778\ud574 \ubcf4\uc790.<\/p>\n\n\n\n<h4 class=\"wp-block-heading\" id=\"6.3.1._CLOB_\ub370\uc774\ud130_\ud655\uc778\"><span class=\"ez-toc-section\" id=\"631_CLOB_%EB%8D%B0%EC%9D%B4%ED%84%B0_%ED%99%95%EC%9D%B8\"><\/span>6.3.1. CLOB \ub370\uc774\ud130 \ud655\uc778<span class=\"ez-toc-section-end\"><\/span><\/h4>\n\n\n\n<p>ORAUS7, ORAMSWIN949, ORAUTF \uc138 \uac1c instance\uc5d0 \uc544\ub798 INSERT \ubb38\uc7a5\uc744 \uc2e4\ud589\ud558\uc5ec CLOB \uceec\ub7fc(REF_DES)\uc5d0 \ub370\uc774\ud130\ub97c \ucc44\uc6b4\ub2e4.<\/p>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"sql\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">INSERT INTO SUB_MON_STAT\n(USE_MON, LINE_NUM, SUB_STA_ID, SUB_STA_NM, RIDE_PASGR_NUM,\n ALIGHT_PASGR_NUM, WORK_DT, COMMT,\n REF_DES, REF_IMG)\nVALUES\n('201301', '1\ud638\uc120', '0150', '\uc11c\uc6b8\uc5ed', 2199181,\n 1855268, '20130723', RPAD('\uc11c\uc6b8\uc5ed', 3000, '\uc11c\uc6b8\uc5ed'),\n RPAD('\uc11c\uc6b8\uc5ed', 3000, '\uc11c\uc6b8\uc5ed'), UTL_RAW.CAST_TO_RAW('12345'))\n;<\/pre>\n\n\n\n<p>\uac01 \uceec\ub7fc\uc758 data type\uc740 \uc544\ub798\uc640 \uac19\ub2e4.<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><a href=\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-84.png\"><img loading=\"lazy\" decoding=\"async\" width=\"894\" height=\"253\" src=\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-84.png\" alt=\"Oracle Character Set \ubcc0\ud658 \ud14c\uc2a4\ud2b8 \ud14c\uc774\ube14 \uad6c\uc131\" class=\"wp-image-11938\" srcset=\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-84.png 894w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-84-300x85.png 300w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-84-768x217.png 768w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-84-18x5.png 18w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-84-24x7.png 24w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-84-36x10.png 36w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-84-48x14.png 48w\" sizes=\"auto, (max-width: 894px) 100vw, 894px\" \/><\/a><figcaption>Oracle Character Set \ubcc0\ud658 \ud14c\uc2a4\ud2b8 \ud14c\uc774\ube14 \uad6c\uc131<\/figcaption><\/figure>\n<\/div>\n\n\n<p>\uc774\uc81c \ub2e4\uc74c SQL\ub85c \uac01 instance\uc5d0\uc11c ref_des \uceec\ub7fc(CLOB type) \ub370\uc774\ud130\ub97c \ud655\uc778\ud574 \ubcf4\uc790.<\/p>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"sql\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">select dbms_lob.getlength(ref_des) chr_len\n      ,lengthb(dbms_lob.substr(ref_des, dbms_lob.getlength(ref_des), 1)) byte_len\n      ,dump(dbms_lob.substr(ref_des, dbms_lob.getlength(ref_des), 1), 1016) dp\n      ,ref_des\n  from sub_mon_stat\n where ref_des is not null\n   and rownum &lt;= 1\n;<\/pre>\n\n\n\n<p><strong>\u25bc ORAUS7<\/strong><\/p>\n\n\n\n<p>CLOB \ub370\uc774\ud130\uc758 Character set\uc740 US7ASCII\uc774\uace0, \ud55c\uae00\uc740 \uc815\uc0c1\uc801\uc73c\ub85c \ud45c\uc2dc\ub418\uc9c0 \uc54a\ub294\ub2e4.<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-large\"><a href=\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-97.png\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"702\" src=\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-97-1024x702.png\" alt=\"ORAUS7 CLOB \ub370\uc774\ud130 \ud655\uc778\" class=\"wp-image-11975\" srcset=\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-97-1024x702.png 1024w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-97-300x206.png 300w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-97-768x527.png 768w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-97-18x12.png 18w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-97-24x16.png 24w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-97-36x25.png 36w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-97-48x33.png 48w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-97.png 1050w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/a><figcaption>ORAUS7 CLOB \ub370\uc774\ud130 \ud655\uc778<\/figcaption><\/figure>\n<\/div>\n\n\n<p>\ubb38\uc790\uc218(chr_len)\ub294 3,000 \uc774\uace0, \ubc14\uc774\ud2b8\uc218(byte_len)\ub3c4 3,000\uc774\ub2e4. \uc989 \ud55c \ubb38\uc790\uac00 1 \ubc14\uc774\ud2b8\ub85c \uc800\uc7a5\ub428\uc744 \uc54c \uc218 \uc788\ub2e4.<\/p>\n\n\n\n<p>SQL Developer\uc5d0\uc11c NLS_LANG\uc744 \uc124\uc815\ud558\ub294 \ubc29\ubc95\uc744 \ucc3e\uc9c0 \ubabb\ud558\uc5ec sqlplus\uc5d0\uc11c \uc2e4\ud589\ud558\uc5ec \ud55c\uae00\uc774 \ud45c\uc2dc\ub418\ub294 \uac83\uc744 \ud655\uc778\ud588\ub2e4.<\/p>\n\n\n\n<p>\uc544\ub798\uc640 \uac19\uc774 NLS_LANG\uc744 US7ASCII\ub85c \uc124\uc815\ud558\uba74 \ud55c\uae00\uc774 \ud45c\uc2dc\ub41c\ub2e4.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><a href=\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-98.png\"><img loading=\"lazy\" decoding=\"async\" width=\"873\" height=\"736\" src=\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-98.png\" alt=\"ORAUS7 CLOB \ud55c\uae00 \ub370\uc774\ud130 \ud655\uc778 (sqlplus, NLS_LANG=US7ASCII)\" class=\"wp-image-11976\" srcset=\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-98.png 873w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-98-300x253.png 300w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-98-768x647.png 768w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-98-14x12.png 14w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-98-24x20.png 24w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-98-36x30.png 36w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-98-48x40.png 48w\" sizes=\"auto, (max-width: 873px) 100vw, 873px\" \/><\/a><figcaption>ORAUS7 CLOB \ud55c\uae00 \ub370\uc774\ud130 \ud655\uc778 (sqlplus, NLS_LANG=US7ASCII)<\/figcaption><\/figure>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"sql\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">C:\\Users\\ymlee>set NLS_LANG=AMERICAN_AMERICA.US7ASCII\n\nC:\\Users\\ymlee>sqlplus leg\/leg@oraus7\n\nSQL*Plus: Release 11.2.0.1.0 Production on Sun Jul 24 21:42:43 2022\n\nCopyright (c) 1982, 2010, Oracle.  All rights reserved.\n\n\nConnected to:\nOracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production\nWith the Partitioning, OLAP, Data Mining and Real Application Testing options\n\nSQL> set pagesize 100\nSQL> set linesize 200\nSQL> select dbms_lob.getlength(ref_des) chr_len\n  2        ,lengthb(dbms_lob.substr(ref_des, dbms_lob.getlength(ref_des), 1)) byte_len\n  3        ,substr(dump(dbms_lob.substr(ref_des, dbms_lob.getlength(ref_des), 1), 1016), 1, 200) dp\n  4        ,ref_des\n  5    from sub_mon_stat\n  6   where ref_des is not null\n  7     and rownum &lt;= 1\n  8\nSQL> \/\n\n   CHR_LEN   BYTE_LEN\n---------- ----------\nDP\n--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------\nREF_DES\n--------------------------------------------------------------------------------\n      3000       3000\nTyp=1 Len=3000 CharacterSet=US7ASCII: bc,ad,bf,ef,bf,aa,bc,ad,bf,ef,bf,aa,bc,ad,bf,ef,bf,aa,bc,ad,bf,ef,bf,aa,bc,ad,bf,ef,bf,aa,bc,ad,bf,ef,bf,aa,bc,ad,bf,ef,bf,aa,bc,ad,bf,ef,bf,aa,bc,ad,bf,ef,bf,aa,\n\uc11c\uc6b8\uc5ed\uc11c\uc6b8\uc5ed\uc11c\uc6b8\uc5ed\uc11c\uc6b8\uc5ed\uc11c\uc6b8\uc5ed\uc11c\uc6b8\uc5ed\uc11c\uc6b8\uc5ed\uc11c\uc6b8\uc5ed\uc11c\uc6b8\uc5ed\uc11c\uc6b8\uc5ed\uc11c\uc6b8\uc5ed\uc11c\uc6b8\uc5ed\uc11c\uc6b8\uc5ed\uc11c\n\n\nSQL><\/pre>\n\n\n\n<p><strong>\u25bc ORAMSWIN949<\/strong><\/p>\n\n\n\n<p>CLOB \ub370\uc774\ud130\uc758 Character set\uc740 KO16MSWIN949\uc774\uace0, \ud55c\uae00\uc740 \uc815\uc0c1\uc801\uc73c\ub85c \ud45c\uc2dc\ub41c\ub2e4.<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-large\"><a href=\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-99.png\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"702\" src=\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-99-1024x702.png\" alt=\"KO16MSWIN949 CLOB \ub370\uc774\ud130 \ud655\uc778\" class=\"wp-image-11977\" srcset=\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-99-1024x702.png 1024w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-99-300x206.png 300w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-99-768x527.png 768w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-99-18x12.png 18w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-99-24x16.png 24w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-99-36x25.png 36w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-99-48x33.png 48w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-99.png 1050w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/a><figcaption>KO16MSWIN949 CLOB \ub370\uc774\ud130 \ud655\uc778<\/figcaption><\/figure>\n<\/div>\n\n\n<p>\ubb38\uc790\uc218(chr_len)\ub294 1,500 \uc774\uace0, \ubc14\uc774\ud2b8\uc218(byte_len)\ub294 3,000\uc774\ub2e4. \uc989 \ud55c \ubb38\uc790\uac00 2 \ubc14\uc774\ud2b8\ub85c \uc800\uc7a5\ub428\uc744 \uc54c \uc218 \uc788\ub2e4.<\/p>\n\n\n\n<p><strong>\u25bc ORAUTF<\/strong><\/p>\n\n\n\n<p>CLOB \ub370\uc774\ud130\uc758 Character set\uc740 AL32UTF8\uc774\uace0, \ud55c\uae00\uc740 \uc815\uc0c1\uc801\uc73c\ub85c \ud45c\uc2dc\ub41c\ub2e4.<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-large\"><a href=\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-100.png\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"702\" src=\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-100-1024x702.png\" alt=\"\" class=\"wp-image-11978\" srcset=\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-100-1024x702.png 1024w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-100-300x206.png 300w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-100-768x527.png 768w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-100-18x12.png 18w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-100-24x16.png 24w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-100-36x25.png 36w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-100-48x33.png 48w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-100.png 1050w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/a><figcaption>ORAUTF CLOB \ub370\uc774\ud130 \ud655\uc778<\/figcaption><\/figure>\n<\/div>\n\n\n<p>\ubb38\uc790\uc218(chr_len)\ub294 1,334 \uc774\uace0, \ubc14\uc774\ud2b8\uc218(byte_len)\ub294 4,000\uc774\ub2e4. \uc989 \ud55c \ubb38\uc790\uac00 3 \ubc14\uc774\ud2b8\ub85c \uc800\uc7a5\ub428\uc744 \uc54c \uc218 \uc788\ub2e4.<\/p>\n\n\n\n<p>(\uc815\ud655\ud55c \ubc14\uc774\ud2b8\uc218\ub294 4,002 \uc774\ub098, dbms_lob.substr\ub85c \ubc18\ud658\ub418\ub294 \ucd5c\ub300 \ubc14\uc774\ud2b8\uc218\uac00 4,000\uc774\ub77c\uc11c \uc57d\uac04 \ucc28\uc774\uac00 \uc788\ub2e4)<\/p>\n\n\n\n<h4 class=\"wp-block-heading\" id=\"6.3.2._CLOB_\ub370\uc774\ud130_\ubcc0\ud658\"><span class=\"ez-toc-section\" id=\"632_CLOB_%EB%8D%B0%EC%9D%B4%ED%84%B0_%EB%B3%80%ED%99%98\"><\/span>6.3.2. CLOB \ub370\uc774\ud130 \ubcc0\ud658<span class=\"ez-toc-section-end\"><\/span><\/h4>\n\n\n\n<p>CLOB \ub370\uc774\ud130\ub294 DB Link\ub97c \ud1b5\ud574 select\ub97c \uc2e4\ud589\ud560 \uc218 \uc5c6\ub2e4. &#8220;ORA-22992: \uc6d0\uaca9 \ud14c\uc774\ube14\ub85c\ubd80\ud130 \uc120\ud0dd\ub41c LOB \uc704\uce58\ub97c \uc0ac\uc6a9\ud560 \uc218 \uc5c6\uc2b5\ub2c8\ub2e4&#8221; \uc624\ub958\uac00 \ubc1c\uc0dd\ud55c\ub2e4.<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-large\"><a href=\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-101.png\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"702\" src=\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-101-1024x702.png\" alt=\"CLOB \ub370\uc774\ud130\ub97c DB Link\ub85c query\ud560 \ub54c ORA-22992 \uc624\ub958\" class=\"wp-image-11979\" srcset=\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-101-1024x702.png 1024w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-101-300x206.png 300w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-101-768x527.png 768w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-101-18x12.png 18w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-101-24x16.png 24w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-101-36x25.png 36w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-101-48x33.png 48w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-101.png 1050w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/a><figcaption>CLOB \ub370\uc774\ud130\ub97c DB Link\ub85c query\ud560 \ub54c ORA-22992 \uc624\ub958<\/figcaption><\/figure>\n<\/div>\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"sql\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">select use_mon, line_num, sub_sta_id, sub_sta_nm, ride_pasgr_num, alight_pasgr_num, work_dt, commt\n      ,ref_des\n  from sub_mon_stat@dl_us7 a\n;\n\nORA-22992: \uc6d0\uaca9 \ud14c\uc774\ube14\ub85c \ubd80\ud130 \uc120\ud0dd\ub41c LOB \uc704\uce58\ub97c \uc0ac\uc6a9\ud560 \uc218 \uc5c6\uc2b5\ub2c8\ub2e4\n22992. 00000 -  \"cannot use LOB locators selected from remote tables\"\n*Cause:    A remote LOB column cannot be referenced.\n*Action:   Remove references to LOBs in remote tables.<\/pre>\n\n\n\n<p>\ub2e4\uc74c\uacfc \uac19\uc774 CTAS(Create Table As Select) \uad6c\ubb38\uc744 \uc0ac\uc6a9\ud558\uc5ec \ub370\uc774\ud130\ub97c \ubcf5\uc0ac\ud560 \uc218\ub294 \uc788\ub2e4.<\/p>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"sql\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">create table sub_mon_stat_from_oraus7\nas\nselect use_mon, line_num, sub_sta_id, sub_sta_nm, ride_pasgr_num, alight_pasgr_num, work_dt\n      ,ref_des\n  from sub_mon_stat@dl_us7 a\n;\n\nselect dbms_lob.getlength(ref_des) chr_len\n      ,lengthb(dbms_lob.substr(ref_des, 1333, 1)) byte_len\n      ,dump(dbms_lob.substr(ref_des, 1333, 1), 1016) dp\n      ,ref_des\n  from sub_mon_stat_from_oraus7\n where ref_des is not null\n   and rownum &lt;= 1\n;<\/pre>\n\n\n\n<p>\uc704 query \uc2e4\ud589 \uacb0\uacfc\ub97c \ubcf4\uba74 CLOB \uceec\ub7fc\uc758 Character set\uc740 AL32UTF8\ub85c \ubcc0\ud658\ub418\uc5c8\uc73c\ub098, \ud55c\uae00 \ubb38\uc790\uc5f4\uc740 \uc815\uc0c1\uc801\uc73c\ub85c \ubcc0\ud658\ub418\uc9c0 \uc54a\uc558\ub2e4.<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-large\"><a href=\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-102.png\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"702\" src=\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-102-1024x702.png\" alt=\"CTAS\ub85c \uc0dd\uc131\ud55c Table \ub370\uc774\ud130 \ud655\uc778\" class=\"wp-image-11980\" srcset=\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-102-1024x702.png 1024w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-102-300x206.png 300w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-102-768x527.png 768w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-102-18x12.png 18w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-102-24x16.png 24w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-102-36x25.png 36w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-102-48x33.png 48w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-102.png 1050w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/a><figcaption>CTAS\ub85c \uc0dd\uc131\ud55c Table \ub370\uc774\ud130 \ud655\uc778<\/figcaption><\/figure>\n<\/div>\n\n\n<p>CLOB \uceec\ub7fc\uc758 \ud55c\uae00\uc744 \ubcc0\ud658\ud558\ub294 \uacfc\uc815\uc740 \ub2e4\uc74c\uacfc \uac19\ub2e4.<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><a href=\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-103.png\"><img loading=\"lazy\" decoding=\"async\" width=\"612\" height=\"395\" src=\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-103.png\" alt=\"CLOB \uceec\ub7fc\uc758 \ud55c\uae00\uc744 \ubcc0\ud658\ud558\ub294 \uacfc\uc815 \uc694\uc57d\" class=\"wp-image-11981\" srcset=\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-103.png 612w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-103-300x194.png 300w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-103-18x12.png 18w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-103-24x15.png 24w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-103-36x23.png 36w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-103-48x31.png 48w\" sizes=\"auto, (max-width: 612px) 100vw, 612px\" \/><\/a><figcaption>CLOB \uceec\ub7fc\uc758 \ud55c\uae00\uc744 \ubcc0\ud658\ud558\ub294 \uacfc\uc815 \uc694\uc57d<\/figcaption><\/figure>\n<\/div>\n\n\n<ol class=\"wp-block-list\"><li>Source DB(Instance #1, ORAUS7)\uc5d0\uc11c CLOB \uceec\ub7fc\uc758 data type\uc744 BLOB\uc73c\ub85c \ubcc0\ud658\ud55c View \uc0dd\uc131<\/li><li>Target DB(Instance #3, ORAUTF)\uc5d0\uc11c CTAS(Create Table As Select) \uad6c\ubb38\uc73c\ub85c Table \uc0dd\uc131<\/li><li>\uc704\uc5d0\uc11c \uc0dd\uc131\ud55c Table\uc758 BLOB data type\uc744 CLOB type\uc73c\ub85c \ubcc0\ud658\ud558\uc5ec Table \uc0dd\uc131<\/li><\/ol>\n\n\n\n<p>\ud558\ub098\uc529 \uc0b4\ud3b4\ubcf4\uc790.<\/p>\n\n\n\n<p><strong>1. Source&nbsp;DB(Instance&nbsp;#1,&nbsp;ORAUS7)\uc5d0\uc11c CLOB&nbsp;\uceec\ub7fc\uc758&nbsp;data&nbsp;type\uc744&nbsp;BLOB\uc73c\ub85c&nbsp;\ubcc0\ud658\ud55c&nbsp;View&nbsp;\uc0dd\uc131<\/strong><\/p>\n\n\n\n<p>CLOB \uceec\ub7fc\uc758 data type\uc744 BLOB\uc73c\ub85c \ubcc0\ud658\ud558\uba74 DB Link\ub85c query\ud560 \ub54c Character set\uc774 \ubcc0\ud658\ub418\uc9c0 \uc54a\ub294\ub2e4.<\/p>\n\n\n\n<p>DBMS_LOB.CONVERTTOBLOB procedure\ub97c \uc774\uc6a9\ud558\uc5ec CLOB\uc744&nbsp;BLOB\uc73c\ub85c&nbsp;\ubcc0\ud658\ud558\ub294&nbsp;\ud568\uc218\ub97c \ub2e4\uc74c\uacfc \uac19\uc774 \uc0dd\uc131\ud55c\ub2e4.<\/p>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"sql\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">CREATE OR REPLACE FUNCTION FN_CLOB_TO_BLOB (P_CLOB CLOB) RETURN BLOB\nAS\n L_BLOB          BLOB;\n L_DEST_OFFSET   INTEGER := 1;\n L_SOURCE_OFFSET INTEGER := 1;\n L_LANG_CONTEXT  INTEGER := DBMS_LOB.DEFAULT_LANG_CTX;\n L_WARNING       INTEGER := DBMS_LOB.WARN_INCONVERTIBLE_CHAR;\nBEGIN\n  IF DBMS_LOB.GETLENGTH(P_CLOB) != 0 THEN\n      DBMS_LOB.CREATETEMPORARY(L_BLOB, TRUE);\n      DBMS_LOB.CONVERTTOBLOB\n      (\n       DEST_LOB    =>L_BLOB,\n       SRC_CLOB    =>P_CLOB,\n       AMOUNT      =>DBMS_LOB.LOBMAXSIZE,\n       DEST_OFFSET =>L_DEST_OFFSET,\n       SRC_OFFSET  =>L_SOURCE_OFFSET,\n       BLOB_CSID   =>DBMS_LOB.DEFAULT_CSID,\n       LANG_CONTEXT=>L_LANG_CONTEXT,\n       WARNING     =>L_WARNING\n      );\n  END IF;\n  RETURN L_BLOB;\nEND;<\/pre>\n\n\n\n<p>\uadf8\ub9ac\uace0, \uc704 \ud568\uc218\ub97c \uc774\uc6a9\ud55c View\ub97c \uc0dd\uc131\ud55c\ub2e4.<\/p>\n\n\n\n<p>\ud14c\uc2a4\ud2b8 \ubaa9\uc801\uc73c\ub85c \uc77c\ubd80 \uceec\ub7fc\uacfc CLOB \uceec\ub7fc\uc778 REF_DES\uc5d0 \uac12\uc774 \uc788\ub294 \ud589\ub9cc \uc120\ud0dd\ud558\ub3c4\ub85d \ud588\ub2e4.<\/p>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"sql\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">CREATE OR REPLACE VIEW VW_SUB_MON_STAT_BLOB\nAS\nSELECT  USE_MON, SUB_STA_ID\n       ,FN_CLOB_TO_BLOB(REF_DES) REF_DES_BLOB\n  FROM  SUB_MON_STAT\n WHERE  REF_DES IS NOT NULL;<\/pre>\n\n\n\n<div style=\"height:40px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<p><strong>2. Target DB(Instance #3, ORAUTF)\uc5d0\uc11c CTAS(Create Table As Select) \uad6c\ubb38\uc73c\ub85c Table \uc0dd\uc131<\/strong><\/p>\n\n\n\n<p>\ub2e4\uc74c \uad6c\ubb38\uc73c\ub85c DB Link\uc5d0\uc11c \ub370\uc774\ud130\ub97c \uac00\uc838\uc640\uc11c Table\uc744 \uc0dd\uc131\ud55c\ub2e4.<\/p>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"sql\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">CREATE  TABLE SUB_MON_STAT_BLOB\nAS\nSELECT  A.*\n  FROM  VW_SUB_MON_STAT_BLOB@DL_US7 A;<\/pre>\n\n\n\n<div style=\"height:40px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<p><strong>3. \uc704\uc5d0\uc11c \uc0dd\uc131\ud55c Table\uc758 BLOB data type\uc744 CLOB type\uc73c\ub85c \ubcc0\ud658\ud558\uc5ec Table \uc0dd\uc131<\/strong><\/p>\n\n\n\n<p>DBMS_LOB.CONVERTTOCLOB procedure\ub97c \uc774\uc6a9\ud558\uc5ec BLOB\uc744 CLOB\uc73c\ub85c \ubcc0\ud658\ud558\ub294 \ud568\uc218\ub97c \ub2e4\uc74c\uacfc \uac19\uc774 \uc0dd\uc131\ud55c\ub2e4.<\/p>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"sql\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">CREATE OR REPLACE FUNCTION FN_BLOB_TO_CLOB (P_BLOB BLOB) RETURN CLOB\nAS\n L_CLOB          CLOB;\n L_DEST_OFFSET   INTEGER := 1;\n L_SOURCE_OFFSET INTEGER := 1;\n L_LANG_CONTEXT  INTEGER := DBMS_LOB.DEFAULT_LANG_CTX;\n L_WARNING       INTEGER := DBMS_LOB.WARN_INCONVERTIBLE_CHAR;\nBEGIN\n  DBMS_LOB.CREATETEMPORARY(L_CLOB, TRUE);\n  DBMS_LOB.CONVERTTOCLOB\n  (\n   DEST_LOB    =>L_CLOB,\n   SRC_BLOB    =>P_BLOB,\n   AMOUNT      =>DBMS_LOB.LOBMAXSIZE,\n   DEST_OFFSET =>L_DEST_OFFSET,\n   SRC_OFFSET  =>L_SOURCE_OFFSET,\n   --BLOB_CSID   =>DBMS_LOB.DEFAULT_CSID,\n   BLOB_CSID   =>846, -- NLS_CHARSET_ID('KO16MSWIN949')\n   LANG_CONTEXT=>L_LANG_CONTEXT,\n   WARNING     =>L_WARNING\n  );\n  RETURN L_CLOB;\nEND;<\/pre>\n\n\n\n<p>DBMS_LOB.CONVERTTOCLOB procedure\uc758 parameter\uc911 BLOB_CSID\ub294 &#8220;\uc6d0\ubcf8 \ub370\uc774\ud130\uc758 Character set ID(The character set ID of the source data)&#8221;\ub97c \uc758\ubbf8\ud55c\ub2e4.<\/p>\n\n\n\n<p>\uc790\uc138\ud55c \ub0b4\uc6a9\uc740 \uc544\ub798 \ubb38\uc11c\ub97c \ucc38\uc870\ud558\uae30 \ubc14\ub780\ub2e4.<\/p>\n\n\n\n<p><a href=\"https:\/\/docs.oracle.com\/cd\/E11882_01\/appdev.112\/e40758\/d_lob.htm#ARPLS602\" target=\"_blank\" rel=\"noreferrer noopener\">DBMS_LOB &#8211; CONVERTTOCLOB Procedure (oracle.com)<\/a><\/p>\n\n\n\n<p>BLOB_CSID\ub294 \ubb38\uc790\uc5f4\uc774 \uc544\ub2cc \uc815\uc218\ud615\uc73c\ub85c \uac12\uc744 \uc9c0\uc815\ud574\uc57c \ud558\uace0 NLS_CHARSET_ID \ud568\uc218\ub85c \uadf8 \uac12\uc744 \uc54c \uc218 \uc788\ub2e4.<\/p>\n\n\n\n<p>\uc6d0\ubcf8 \ub370\uc774\ud130\uc758 Character set\uc774 KO16MSWIN949\uc774\ubbc0\ub85c \ub2e4\uc74c\uacfc \uac19\uc774 \uc2e4\ud589\ud558\uc5ec 846\uc744 \ud655\uc778\ud588\ub2e4.<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><a href=\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-104.png\"><img loading=\"lazy\" decoding=\"async\" width=\"461\" height=\"194\" src=\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-104.png\" alt=\"NLS_CHARSET_ID \ud568\uc218\ub85c BLOB_CSID \ud655\uc778\" class=\"wp-image-11982\" srcset=\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-104.png 461w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-104-300x126.png 300w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-104-18x8.png 18w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-104-24x10.png 24w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-104-36x15.png 36w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-104-48x20.png 48w\" sizes=\"auto, (max-width: 461px) 100vw, 461px\" \/><\/a><figcaption>NLS_CHARSET_ID \ud568\uc218\ub85c BLOB_CSID \ud655\uc778<\/figcaption><\/figure>\n<\/div>\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"sql\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">SELECT NLS_CHARSET_ID('KO16MSWIN949')\n  FROM DUAL;<\/pre>\n\n\n\n<p>\uadf8\ub9ac\uace0, \uc704 \ud568\uc218\ub97c \uc774\uc6a9\ud558\uc5ec Table\uc744 \uc0dd\uc131\ud558\uac70\ub098 query\ud560 \uc218 \uc788\ub2e4.<\/p>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"sql\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">CREATE  TABLE SUB_MON_STAT_BLOB_TO_CLOB\nAS\nSELECT  USE_MON, SUB_STA_ID\n       ,FN_BLOB_TO_CLOB(REF_DES_BLOB) REF_DES\n  FROM  SUB_MON_STAT_BLOB A;\n\nselect *\n  from sub_mon_stat_blob_to_clob\n;\n\n-- Table \uc0dd\uc131\ud558\uc9c0 \uc54a\uc744 \uacbd\uc6b0\ub294 \ub2e4\uc74c\uacfc \uac19\uc774 query \uac00\ub2a5\nselect use_mon, sub_sta_id\n       ,fn_blob_to_clob(ref_des_blob) ref_des\n  from sub_mon_stat_blob\n;<\/pre>\n\n\n\n<p>\ub2e4\uc74c\uacfc \uac19\uc774 \ud55c\uae00\uc774 \uc815\uc0c1\uc801\uc73c\ub85c \ubcc0\ud658\ub41c \uac83\uc744 \ud655\uc778\ud560 \uc218 \uc788\ub2e4.<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-large\"><a href=\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-105.png\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"702\" src=\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-105-1024x702.png\" alt=\"CLOB \ud55c\uae00 \ubcc0\ud658\uacb0\uacfc \ud655\uc778\" class=\"wp-image-11983\" srcset=\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-105-1024x702.png 1024w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-105-300x206.png 300w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-105-768x527.png 768w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-105-18x12.png 18w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-105-24x16.png 24w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-105-36x25.png 36w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-105-48x33.png 48w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-105.png 1050w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/a><figcaption>CLOB \ud55c\uae00 \ubcc0\ud658\uacb0\uacfc \ud655\uc778<\/figcaption><\/figure>\n<\/div>\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity is-style-dots\"\/>\n\n\n\n<p>\uc5ec\uae30\uae4c\uc9c0 US7ASCII character set DB\uc5d0\uc11c \ud55c\uae00\uc774 \ud3ec\ud568\ub41c CLOB type\uc744 AL32UTF8\ub85c \ubcc0\ud658\ud558\ub294 \ubc29\ubc95\uc744 \uc0b4\ud3b4\ubcf4\uc558\ub2e4.<\/p>\n\n\n\n<p>\uc5ec\ub7ec \uacfc\uc815\uc744 \uac70\uccd0\uc11c \ubcc0\ud658\ud558\ub2e4 \ubcf4\ub2c8 \uc870\uae08 \ubcf5\uc7a1\ud574 \ubcf4\uc774\ub098, \ud55c \ub2e8\uacc4\uc529 \ubcf4\uba74 \uc5b4\ub824\uc6b8 \uac83\uc740 \uc5c6\ub2e4.<\/p>\n\n\n\n<p>\uc774 \uae00\uae4c\uc9c0 \ud558\uc5ec Oracle Character set \ubcc0\ud658\uc5d0 \ub300\ud55c \uc5f0\uc7ac\ub97c \ub9c8\uce5c\ub2e4.<\/p>\n\n\n\n<p>\ud544\uc694\ud55c \uc0ac\ub78c\uc5d0\uac8c \uc870\uae08\uc774\ub098\ub9c8 \ub3c4\uc6c0\uc774 \ub418\uc5c8\uc73c\uba74 \ud55c\ub2e4.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>CLOB type \ud55c\uae00 \ubcc0\ud658 \ubc29\ubc95 \uc5d0 \ub300\ud574 \uc0b4\ud3b4\ubcf8\ub2e4. US7ASCII character set DB\uc5d0\uc11c \ud55c\uae00\uc774 \ud3ec\ud568\ub41c CLOB type\uc744 AL32UTF8\ub85c \ubcc0\ud658\ud558\ub294 \ubc29\ubc95\uacfc \ubcc0\ud658 \uacb0\uacfc\ub97c \ud655\uc778\ud560 \uc218 \uc788\ub2e4. \uc774\uc804 \uae00\uc5d0\uc11c \uc774\uc5b4\uc9c0\ub294 \ub0b4\uc6a9\uc774\ub2e4. Oracle Character Set \ubcc0\ud658(9): 6. \uc0ac\uc6a9\uc790 \uad6c\ud604 Character Set \ubcc0\ud658 \ubc29\ubc95 (2)&#46;&#46;&#46;<\/p>\n","protected":false},"author":1,"featured_media":11981,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[32],"tags":[242,248,249,254,255,259,260,263],"class_list":["post-11974","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-oracle","tag-oracle","tag-character-set-","tag-character-set-conversion","tag-us7ascii","tag-ko16mswin949","tag-al32utf8","tag-db-link","tag-dbms_lob"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.4 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Oracle Character Set \ubcc0\ud658(10): 6.3. CLOB type \ud55c\uae00 \ubcc0\ud658 \ubc29\ubc95 - \uc0dd\uc0b0\uc131 Skill<\/title>\n<meta name=\"description\" content=\"CLOB type \ud55c\uae00 \ubcc0\ud658 \ubc29\ubc95 \uc5d0 \ub300\ud574 \uc0b4\ud3b4\ubcf8\ub2e4. US7ASCII character set DB\uc5d0\uc11c \ud55c\uae00\uc774 \ud3ec\ud568\ub41c CLOB type\uc744 AL32UTF8\ub85c \ubcc0\ud658\ud558\ub294 \ubc29\ubc95\uacfc \ubcc0\ud658 \uacb0\uacfc\ub97c \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\/ko\/oracle-character-set-migration-10-convert-clob\/\" \/>\n<meta property=\"og:locale\" content=\"ko_KR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Oracle Character Set \ubcc0\ud658(10): 6.3. CLOB type \ud55c\uae00 \ubcc0\ud658 \ubc29\ubc95 - \uc0dd\uc0b0\uc131 Skill\" \/>\n<meta property=\"og:description\" content=\"CLOB type \ud55c\uae00 \ubcc0\ud658 \ubc29\ubc95 \uc5d0 \ub300\ud574 \uc0b4\ud3b4\ubcf8\ub2e4. US7ASCII character set DB\uc5d0\uc11c \ud55c\uae00\uc774 \ud3ec\ud568\ub41c CLOB type\uc744 AL32UTF8\ub85c \ubcc0\ud658\ud558\ub294 \ubc29\ubc95\uacfc \ubcc0\ud658 \uacb0\uacfc\ub97c \ud655\uc778\ud560 \uc218 \uc788\ub2e4.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/prodskill.com\/ko\/oracle-character-set-migration-10-convert-clob\/\" \/>\n<meta property=\"og:site_name\" content=\"\uc0dd\uc0b0\uc131 Skill\" \/>\n<meta property=\"article:published_time\" content=\"2022-10-03T08:17:04+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2022-10-04T15:13:54+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-103.png\" \/>\n\t<meta property=\"og:image:width\" content=\"612\" \/>\n\t<meta property=\"og:image:height\" content=\"395\" \/>\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=\"\uae00\uc4f4\uc774\" \/>\n\t<meta name=\"twitter:data1\" content=\"Zerom\" \/>\n\t<meta name=\"twitter:label2\" content=\"\uc608\uc0c1 \ub418\ub294 \ud310\ub3c5 \uc2dc\uac04\" \/>\n\t<meta name=\"twitter:data2\" content=\"8\ubd84\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/prodskill.com\\\/oracle-character-set-migration-10-convert-clob\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/prodskill.com\\\/oracle-character-set-migration-10-convert-clob\\\/\"},\"author\":{\"name\":\"Zerom\",\"@id\":\"https:\\\/\\\/prodskill.com\\\/ko\\\/#\\\/schema\\\/person\\\/bbad0870c78008c82edbe0960fe768bd\"},\"headline\":\"Oracle Character Set \ubcc0\ud658(10): 6.3. CLOB type \ud55c\uae00 \ubcc0\ud658 \ubc29\ubc95\",\"datePublished\":\"2022-10-03T08:17:04+00:00\",\"dateModified\":\"2022-10-04T15:13:54+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/prodskill.com\\\/oracle-character-set-migration-10-convert-clob\\\/\"},\"wordCount\":318,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\\\/\\\/prodskill.com\\\/ko\\\/#\\\/schema\\\/person\\\/bbad0870c78008c82edbe0960fe768bd\"},\"image\":{\"@id\":\"https:\\\/\\\/prodskill.com\\\/oracle-character-set-migration-10-convert-clob\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/prodskill.com\\\/wp-content\\\/uploads\\\/2022\\\/10\\\/image-103.png\",\"keywords\":[\"ORACLE\",\"Character Set \ubcc0\ud658\",\"Character Set Conversion\",\"US7ASCII\",\"KO16MSWIN949\",\"AL32UTF8\",\"DB Link\",\"DBMS_LOB\"],\"articleSection\":[\"ORACLE\"],\"inLanguage\":\"ko-KR\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/prodskill.com\\\/oracle-character-set-migration-10-convert-clob\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/prodskill.com\\\/oracle-character-set-migration-10-convert-clob\\\/\",\"url\":\"https:\\\/\\\/prodskill.com\\\/oracle-character-set-migration-10-convert-clob\\\/\",\"name\":\"Oracle Character Set \ubcc0\ud658(10): 6.3. CLOB type \ud55c\uae00 \ubcc0\ud658 \ubc29\ubc95 - \uc0dd\uc0b0\uc131 Skill\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/prodskill.com\\\/ko\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/prodskill.com\\\/oracle-character-set-migration-10-convert-clob\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/prodskill.com\\\/oracle-character-set-migration-10-convert-clob\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/prodskill.com\\\/wp-content\\\/uploads\\\/2022\\\/10\\\/image-103.png\",\"datePublished\":\"2022-10-03T08:17:04+00:00\",\"dateModified\":\"2022-10-04T15:13:54+00:00\",\"description\":\"CLOB type \ud55c\uae00 \ubcc0\ud658 \ubc29\ubc95 \uc5d0 \ub300\ud574 \uc0b4\ud3b4\ubcf8\ub2e4. US7ASCII character set DB\uc5d0\uc11c \ud55c\uae00\uc774 \ud3ec\ud568\ub41c CLOB type\uc744 AL32UTF8\ub85c \ubcc0\ud658\ud558\ub294 \ubc29\ubc95\uacfc \ubcc0\ud658 \uacb0\uacfc\ub97c \ud655\uc778\ud560 \uc218 \uc788\ub2e4.\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/prodskill.com\\\/oracle-character-set-migration-10-convert-clob\\\/#breadcrumb\"},\"inLanguage\":\"ko-KR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/prodskill.com\\\/oracle-character-set-migration-10-convert-clob\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"ko-KR\",\"@id\":\"https:\\\/\\\/prodskill.com\\\/oracle-character-set-migration-10-convert-clob\\\/#primaryimage\",\"url\":\"https:\\\/\\\/prodskill.com\\\/wp-content\\\/uploads\\\/2022\\\/10\\\/image-103.png\",\"contentUrl\":\"https:\\\/\\\/prodskill.com\\\/wp-content\\\/uploads\\\/2022\\\/10\\\/image-103.png\",\"width\":612,\"height\":395},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/prodskill.com\\\/oracle-character-set-migration-10-convert-clob\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/prodskill.com\\\/ko\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Oracle Character Set \ubcc0\ud658(10): 6.3. CLOB type \ud55c\uae00 \ubcc0\ud658 \ubc29\ubc95\"}]},{\"@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\":\"ko-KR\"},{\"@type\":[\"Person\",\"Organization\"],\"@id\":\"https:\\\/\\\/prodskill.com\\\/ko\\\/#\\\/schema\\\/person\\\/bbad0870c78008c82edbe0960fe768bd\",\"name\":\"Zerom\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"ko-KR\",\"@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\\\/ko\\\/author\\\/proda\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Oracle Character Set \ubcc0\ud658(10): 6.3. CLOB type \ud55c\uae00 \ubcc0\ud658 \ubc29\ubc95 - \uc0dd\uc0b0\uc131 Skill","description":"CLOB type \ud55c\uae00 \ubcc0\ud658 \ubc29\ubc95 \uc5d0 \ub300\ud574 \uc0b4\ud3b4\ubcf8\ub2e4. US7ASCII character set DB\uc5d0\uc11c \ud55c\uae00\uc774 \ud3ec\ud568\ub41c CLOB type\uc744 AL32UTF8\ub85c \ubcc0\ud658\ud558\ub294 \ubc29\ubc95\uacfc \ubcc0\ud658 \uacb0\uacfc\ub97c \ud655\uc778\ud560 \uc218 \uc788\ub2e4.","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\/ko\/oracle-character-set-migration-10-convert-clob\/","og_locale":"ko_KR","og_type":"article","og_title":"Oracle Character Set \ubcc0\ud658(10): 6.3. CLOB type \ud55c\uae00 \ubcc0\ud658 \ubc29\ubc95 - \uc0dd\uc0b0\uc131 Skill","og_description":"CLOB type \ud55c\uae00 \ubcc0\ud658 \ubc29\ubc95 \uc5d0 \ub300\ud574 \uc0b4\ud3b4\ubcf8\ub2e4. US7ASCII character set DB\uc5d0\uc11c \ud55c\uae00\uc774 \ud3ec\ud568\ub41c CLOB type\uc744 AL32UTF8\ub85c \ubcc0\ud658\ud558\ub294 \ubc29\ubc95\uacfc \ubcc0\ud658 \uacb0\uacfc\ub97c \ud655\uc778\ud560 \uc218 \uc788\ub2e4.","og_url":"https:\/\/prodskill.com\/ko\/oracle-character-set-migration-10-convert-clob\/","og_site_name":"\uc0dd\uc0b0\uc131 Skill","article_published_time":"2022-10-03T08:17:04+00:00","article_modified_time":"2022-10-04T15:13:54+00:00","og_image":[{"width":612,"height":395,"url":"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-103.png","type":"image\/png"}],"author":"Zerom","twitter_card":"summary_large_image","twitter_misc":{"\uae00\uc4f4\uc774":"Zerom","\uc608\uc0c1 \ub418\ub294 \ud310\ub3c5 \uc2dc\uac04":"8\ubd84"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/prodskill.com\/oracle-character-set-migration-10-convert-clob\/#article","isPartOf":{"@id":"https:\/\/prodskill.com\/oracle-character-set-migration-10-convert-clob\/"},"author":{"name":"Zerom","@id":"https:\/\/prodskill.com\/ko\/#\/schema\/person\/bbad0870c78008c82edbe0960fe768bd"},"headline":"Oracle Character Set \ubcc0\ud658(10): 6.3. CLOB type \ud55c\uae00 \ubcc0\ud658 \ubc29\ubc95","datePublished":"2022-10-03T08:17:04+00:00","dateModified":"2022-10-04T15:13:54+00:00","mainEntityOfPage":{"@id":"https:\/\/prodskill.com\/oracle-character-set-migration-10-convert-clob\/"},"wordCount":318,"commentCount":0,"publisher":{"@id":"https:\/\/prodskill.com\/ko\/#\/schema\/person\/bbad0870c78008c82edbe0960fe768bd"},"image":{"@id":"https:\/\/prodskill.com\/oracle-character-set-migration-10-convert-clob\/#primaryimage"},"thumbnailUrl":"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-103.png","keywords":["ORACLE","Character Set \ubcc0\ud658","Character Set Conversion","US7ASCII","KO16MSWIN949","AL32UTF8","DB Link","DBMS_LOB"],"articleSection":["ORACLE"],"inLanguage":"ko-KR","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/prodskill.com\/oracle-character-set-migration-10-convert-clob\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/prodskill.com\/oracle-character-set-migration-10-convert-clob\/","url":"https:\/\/prodskill.com\/oracle-character-set-migration-10-convert-clob\/","name":"Oracle Character Set \ubcc0\ud658(10): 6.3. CLOB type \ud55c\uae00 \ubcc0\ud658 \ubc29\ubc95 - \uc0dd\uc0b0\uc131 Skill","isPartOf":{"@id":"https:\/\/prodskill.com\/ko\/#website"},"primaryImageOfPage":{"@id":"https:\/\/prodskill.com\/oracle-character-set-migration-10-convert-clob\/#primaryimage"},"image":{"@id":"https:\/\/prodskill.com\/oracle-character-set-migration-10-convert-clob\/#primaryimage"},"thumbnailUrl":"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-103.png","datePublished":"2022-10-03T08:17:04+00:00","dateModified":"2022-10-04T15:13:54+00:00","description":"CLOB type \ud55c\uae00 \ubcc0\ud658 \ubc29\ubc95 \uc5d0 \ub300\ud574 \uc0b4\ud3b4\ubcf8\ub2e4. US7ASCII character set DB\uc5d0\uc11c \ud55c\uae00\uc774 \ud3ec\ud568\ub41c CLOB type\uc744 AL32UTF8\ub85c \ubcc0\ud658\ud558\ub294 \ubc29\ubc95\uacfc \ubcc0\ud658 \uacb0\uacfc\ub97c \ud655\uc778\ud560 \uc218 \uc788\ub2e4.","breadcrumb":{"@id":"https:\/\/prodskill.com\/oracle-character-set-migration-10-convert-clob\/#breadcrumb"},"inLanguage":"ko-KR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/prodskill.com\/oracle-character-set-migration-10-convert-clob\/"]}]},{"@type":"ImageObject","inLanguage":"ko-KR","@id":"https:\/\/prodskill.com\/oracle-character-set-migration-10-convert-clob\/#primaryimage","url":"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-103.png","contentUrl":"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-103.png","width":612,"height":395},{"@type":"BreadcrumbList","@id":"https:\/\/prodskill.com\/oracle-character-set-migration-10-convert-clob\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/prodskill.com\/ko\/"},{"@type":"ListItem","position":2,"name":"Oracle Character Set \ubcc0\ud658(10): 6.3. CLOB type \ud55c\uae00 \ubcc0\ud658 \ubc29\ubc95"}]},{"@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":"ko-KR"},{"@type":["Person","Organization"],"@id":"https:\/\/prodskill.com\/ko\/#\/schema\/person\/bbad0870c78008c82edbe0960fe768bd","name":"Zerom","image":{"@type":"ImageObject","inLanguage":"ko-KR","@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\/ko\/author\/proda\/"}]}},"_links":{"self":[{"href":"https:\/\/prodskill.com\/ko\/wp-json\/wp\/v2\/posts\/11974","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/prodskill.com\/ko\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/prodskill.com\/ko\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/prodskill.com\/ko\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/prodskill.com\/ko\/wp-json\/wp\/v2\/comments?post=11974"}],"version-history":[{"count":0,"href":"https:\/\/prodskill.com\/ko\/wp-json\/wp\/v2\/posts\/11974\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/prodskill.com\/ko\/wp-json\/wp\/v2\/media\/11981"}],"wp:attachment":[{"href":"https:\/\/prodskill.com\/ko\/wp-json\/wp\/v2\/media?parent=11974"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/prodskill.com\/ko\/wp-json\/wp\/v2\/categories?post=11974"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/prodskill.com\/ko\/wp-json\/wp\/v2\/tags?post=11974"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}