{"id":11964,"date":"2022-10-03T16:47:14","date_gmt":"2022-10-03T07:47:14","guid":{"rendered":"https:\/\/prodskill.com\/?p=11964"},"modified":"2023-09-12T18:00:04","modified_gmt":"2023-09-12T09:00:04","slug":"oracle-character-set-migration-9-dblink-ctas-utl_raw","status":"publish","type":"post","link":"https:\/\/prodskill.com\/en\/oracle-character-set-migration-9-dblink-ctas-utl_raw\/","title":{"rendered":"Oracle Character Set Conversion (9): 6. How to Convert User Implemented Character Sets (2)"},"content":{"rendered":"<p>Previous article(<a href=\"https:\/\/prodskill.com\/en\/oracle-character-set-migration-8-datapump-export-import\/\">Oracle Character Set Conversion(8): 6. How to Convert User Implemented Character Set (1)<\/a>), the user-implemented Character Set conversion method is examined. You can check how to convert from KO16MSWIN949, US7ASCII to AL32UTF8 using DB Link, CTAS, and UTL_RAW packages.<\/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;Table of Contents&gt;&gt;<\/p>\n<span class=\"ez-toc-title-toggle\"><a href=\"#\" class=\"ez-toc-pull-right ez-toc-btn ez-toc-btn-xs ez-toc-btn-default ez-toc-toggle\" aria-label=\"Toggle Table of Content\"><span class=\"ez-toc-js-icon-con\"><span class=\"\"><span class=\"eztoc-hide\" style=\"display:none;\">Toggle<\/span><span class=\"ez-toc-icon-toggle-span\"><svg style=\"fill: #999;color:#999\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" class=\"list-377408\" width=\"20px\" height=\"20px\" viewbox=\"0 0 24 24\" fill=\"none\"><path d=\"M6 6H4v2h2V6zm14 0H8v2h12V6zM4 11h2v2H4v-2zm16 0H8v2h12v-2zM4 16h2v2H4v-2zm16 0H8v2h12v-2z\" fill=\"currentColor\"><\/path><\/svg><svg style=\"fill: #999;color:#999\" class=\"arrow-unsorted-368013\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"10px\" height=\"10px\" viewbox=\"0 0 24 24\" version=\"1.2\" baseprofile=\"tiny\"><path d=\"M18.2 9.3l-6.2-6.3-6.2 6.3c-.2.2-.3.4-.3.7s.1.5.3.7c.2.2.4.3.7.3h11c.3 0 .5-.1.7-.3.2-.2.3-.5.3-.7s-.1-.5-.3-.7zM5.8 14.7l6.2 6.3 6.2-6.3c.2-.2.3-.5.3-.7s-.1-.5-.3-.7c-.2-.2-.4-.3-.7-.3h-11c-.3 0-.5.1-.7.3-.2.2-.3.5-.3.7s.1.5.3.7z\"\/><\/svg><\/span><\/span><\/span><\/a><\/span><\/div>\n<nav><ul class='ez-toc-list ez-toc-list-level-1' ><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/prodskill.com\/en\/oracle-character-set-migration-9-dblink-ctas-utl_raw\/#623_%EB%B0%A9%EB%B2%953_DB_Link_CTAS_UTL_RAW\" >6.2.3. Method 3) DB Link &amp; CTAS &amp; UTL_RAW<\/a><ul class='ez-toc-list-level-3' ><li class='ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/prodskill.com\/en\/oracle-character-set-migration-9-dblink-ctas-utl_raw\/#%ED%85%8C%EC%8A%A4%ED%8A%B8_1_ORAMSWIN949_%EC%97%90%EC%84%9C_ORAUS7_%EB%8D%B0%EC%9D%B4%ED%84%B0_%EA%B0%80%EC%A0%B8%EC%98%A4%EA%B8%B0\" >Test #1) Get ORAUS7 data from ORAMSWIN949<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/prodskill.com\/en\/oracle-character-set-migration-9-dblink-ctas-utl_raw\/#%ED%85%8C%EC%8A%A4%ED%8A%B8_2_ORAUTF_%EC%97%90%EC%84%9C_ORAMSWIN949_%EB%8D%B0%EC%9D%B4%ED%84%B0_%EA%B0%80%EC%A0%B8%EC%98%A4%EA%B8%B0\" >Test #2) Get ORAMSWIN949 data from ORAUTF<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/prodskill.com\/en\/oracle-character-set-migration-9-dblink-ctas-utl_raw\/#%ED%85%8C%EC%8A%A4%ED%8A%B8_3_ORAUTF_%EC%97%90%EC%84%9C_ORAUS7_%EB%8D%B0%EC%9D%B4%ED%84%B0_%EA%B0%80%EC%A0%B8%EC%98%A4%EA%B8%B0\" >Test #3) Get ORAUS7 data from ORAUTF<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/prodskill.com\/en\/oracle-character-set-migration-9-dblink-ctas-utl_raw\/#%EC%B0%B8%EA%B3%A0\" >Reference<\/a><ul class='ez-toc-list-level-4' ><li class='ez-toc-heading-level-4'><a class=\"ez-toc-link ez-toc-heading-6\" href=\"https:\/\/prodskill.com\/en\/oracle-character-set-migration-9-dblink-ctas-utl_raw\/#RAW_data_type_%EC%82%B4%ED%8E%B4%EB%B3%B4%EA%B8%B0\" >Explore RAW data types<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-4'><a class=\"ez-toc-link ez-toc-heading-7\" href=\"https:\/\/prodskill.com\/en\/oracle-character-set-migration-9-dblink-ctas-utl_raw\/#Character_set_%EB%B3%80%ED%99%98_%ED%95%A8%EC%88%98_CONVERT\" >Character set conversion function CONVERT<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-4'><a class=\"ez-toc-link ez-toc-heading-8\" href=\"https:\/\/prodskill.com\/en\/oracle-character-set-migration-9-dblink-ctas-utl_raw\/#%EC%A3%BC%EC%9D%98%EC%82%AC%ED%95%AD\" >Precautions<\/a><\/li><\/ul><\/li><\/ul><\/li><\/ul><\/nav><\/div>\n<h2 class=\"wp-block-heading\" id=\"6.2.3._\ubc29\ubc953)_DB_Link_&amp;_CTAS_&amp;_UTL_RAW\"><span class=\"ez-toc-section\" id=\"623_%EB%B0%A9%EB%B2%953_DB_Link_CTAS_UTL_RAW\"><\/span>6.2.3. Method 3) DB Link &amp; CTAS &amp; UTL_RAW<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>This is a method of converting character set while importing data through DB Link.<\/p>\n\n\n\n<p>Configure three DB instances on one server and run three tests.<\/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-89.png\"><img loading=\"lazy\" decoding=\"async\" width=\"873\" height=\"268\" src=\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-89.png\" alt=\"DB \uc11c\ubc84, DB Link \uad6c\uc131, \ud14c\uc2a4\ud2b8 \ucf00\uc774\uc2a4\" class=\"wp-image-11965\" srcset=\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-89.png 873w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-89-300x92.png 300w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-89-768x236.png 768w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-89-18x6.png 18w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-89-24x7.png 24w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-89-36x11.png 36w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-89-48x15.png 48w\" sizes=\"auto, (max-width: 873px) 100vw, 873px\" \/><\/a><figcaption class=\"wp-element-caption\">DB server, DB Link configuration, test case<\/figcaption><\/figure>\n<\/div>\n\n\n<ol class=\"wp-block-list\">\n<li>Get ORAUS7 data from ORAMSWIN949<\/li>\n\n\n\n<li>Get ORAMSWIN949 data from ORAUTF<\/li>\n\n\n\n<li>Get ORAUS7 data from ORAUTF<\/li>\n<\/ol>\n\n\n\n<p>Hangul data stored in ORAUS7 can be checked as follows.<\/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-90.png\"><img loading=\"lazy\" decoding=\"async\" width=\"608\" height=\"593\" src=\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-90.png\" alt=\"ORAUS7\uc5d0 \uc800\uc7a5\ub41c \ud55c\uae00 \ub370\uc774\ud130 \ud655\uc778\" class=\"wp-image-11966\" srcset=\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-90.png 608w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-90-300x293.png 300w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-90-12x12.png 12w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-90-24x24.png 24w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-90-36x36.png 36w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-90-48x48.png 48w\" sizes=\"auto, (max-width: 608px) 100vw, 608px\" \/><\/a><figcaption class=\"wp-element-caption\">Check Hangul data stored in ORAUS7<\/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=\"\" data-no-auto-translation=\"\">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 17 22:34:26 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 use_mon, line_num, sub_sta_id, sub_sta_nm, ride_pasgr_num, alight_pasgr_num, work_dt\n  2    from sub_mon_stat\n  3   where rownum &lt;= 10\n  4  ;\n\nUSE_MON  LINE_NUM       SUB_ SUB_STA_NM           RIDE_PASGR_NUM ALIGHT_PASGR_NUM WORK_DT\n-------- -------------- ---- -------------------- -------------- ---------------- --------\n201301   2\ud638\uc120          0214 \uac15\ubcc0                        1565310          1549316 20130723\n201301   2\ud638\uc120          0215 \uc7a0\uc2e4\ub098\ub8e8                     536413           505376 20130723\n201301   2\ud638\uc120          0216 \uc7a0\uc2e4                        2323516          2106978 20130723\n201301   2\ud638\uc120          0217 \uc2e0\ucc9c                         814104           786397 20130723\n201301   2\ud638\uc120          0218 \uc885\ud569\uc6b4\ub3d9\uc7a5                   374633           389860 20130723\n201301   2\ud638\uc120          0219 \uc0bc\uc131                        2015421          2050988 20130723\n201301   2\ud638\uc120          0220 \uc120\ub989                        1773445          1572999 20130723\n201301   2\ud638\uc120          0221 \uc5ed\uc0bc                        1496812          1644097 20130723\n201301   2\ud638\uc120          0222 \uac15\ub0a8                        3453154          3558986 20130723\n201301   2\ud638\uc120          0223 \uad50\ub300                        1195621          1323778 20130723\n\n10 rows selected.\n\nSQL><\/pre>\n\n\n\n<p>The tests below use Oracle SQL Developer.<\/p>\n\n\n\n<p>SQL Developer is a tool provided by Oracle and is free. You can download it from the URL below.<\/p>\n\n\n\n<p><a href=\"https:\/\/www.oracle.com\/database\/sqldeveloper\/technologies\/download\/\" target=\"_blank\" rel=\"noreferrer noopener\">Oracle SQL Developer Downloads<\/a><\/p>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"\ud14c\uc2a4\ud2b8_#1)_ORAMSWIN949_\uc5d0\uc11c_ORAUS7_\ub370\uc774\ud130_\uac00\uc838\uc624\uae30\"><span class=\"ez-toc-section\" id=\"%ED%85%8C%EC%8A%A4%ED%8A%B8_1_ORAMSWIN949_%EC%97%90%EC%84%9C_ORAUS7_%EB%8D%B0%EC%9D%B4%ED%84%B0_%EA%B0%80%EC%A0%B8%EC%98%A4%EA%B8%B0\"><\/span>Test #1) Get ORAUS7 data from ORAMSWIN949<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>You can import data by creating a DL_US7 DB Link and specifying the DB Link \u201cdl_us7\u201d. The script is as follows.<\/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=\"\" data-no-auto-translation=\"\">CREATE DATABASE LINK DL_US7\nCONNECT TO leg IDENTIFIED BY leg\nUSING '(DESCRIPTION =\n    (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))\n    (CONNECT_DATA =\n      (SERVER = DEDICATED)\n      (SERVICE_NAME = ORAUS7)\n    )\n  )'\n;\n\nselect use_mon, line_num, sub_sta_id, sub_sta_nm, ride_pasgr_num, alight_pasgr_num, work_dt, commt\n  from sub_mon_stat@dl_us7\n;<\/pre>\n\n\n\n<p>Korean characters in the execution result are not displayed normally, but appear as ? (question mark) characters.<\/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-91.png\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"702\" src=\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-91-1024x702.png\" alt=\"\ud14c\uc2a4\ud2b8 #1) ORAMSWIN949\u00a0\uc5d0\uc11c\u00a0ORAUS7\u00a0\ub370\uc774\ud130\u00a0\uac00\uc838\uc624\uae30 \uc2e4\ud589 \uacb0\uacfc\" class=\"wp-image-11967\" srcset=\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-91-1024x702.png 1024w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-91-300x206.png 300w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-91-768x527.png 768w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-91-18x12.png 18w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-91-24x16.png 24w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-91-36x25.png 36w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-91-48x33.png 48w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-91.png 1050w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/a><figcaption class=\"wp-element-caption\">Test #1-1) Result of importing ORAUS7 data from ORAMSWIN949<\/figcaption><\/figure>\n<\/div>\n\n\n<p>When data is imported through DB Link, the character set of the server (ORAUS7 in this case) is converted to the character set of the client (ORAMSWIN949 in this case).<\/p>\n\n\n\n<p>Hangul stored in US7ASCII is stored incorrectly, so it cannot be converted to MSWIN949, so it is displayed as a question mark.<\/p>\n\n\n\n<p>To display ORAUS7 Korean data normally in this situation, apply the following method.<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Create a view in ORAUS7 using the UTL_RAW.CAST_TO_RAW function to prevent VARCHAR2 data type columns containing Korean characters from being converted to character sets.\n<ul class=\"wp-block-list\">\n<li>Apply the UTL_RAW.CAST_TO_RAW function to columns containing Korean characters.<\/li>\n\n\n\n<li>RAW data type does not convert character set.<\/li>\n<\/ul>\n<\/li>\n\n\n\n<li>ORAMSWIN949 queries the View created above, converts the RAW data type back to VARCHAR2, and converts it to normal Hangul by specifying the source character set and destination character set with the CONVERT function.<\/li>\n<\/ul>\n\n\n\n<p>Create a view that converts VARCHAR2 data type to RAW data type in the ORAUS7 instance with the script below.<\/p>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"oracledb\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\" data-no-auto-translation=\"\">-- ORAUS7\uc5d0 View \uc0dd\uc131\ncreate or replace view vw_sub_mon_stat as\nselect use_mon\n      --,line_num\n      ,utl_raw.cast_to_raw(line_num) as line_num_raw\n      ,sub_sta_id\n      --,sub_sta_nm\n      ,utl_raw.cast_to_raw(sub_sta_nm) as sub_sta_nm_raw\n      ,ride_pasgr_num, alight_pasgr_num, work_dt, commt\n  from sub_mon_stat\n;<\/pre>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"oracledb\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\" data-no-auto-translation=\"\">-- ORAMSWIN949: utl_raw.cast_to_varchar2, convert \ud568\uc218 \uc801\uc6a9\ud558\uc5ec \ud55c\uae00 \ub370\uc774\ud130 \uc815\uc0c1 \ud45c\uc2dc\nselect use_mon\n      ,convert(utl_raw.cast_to_varchar2(line_num_raw), 'KO16MSWIN949', 'KO16MSWIN949') line_num\n      ,sub_sta_id\n      ,convert(utl_raw.cast_to_varchar2(sub_sta_nm_raw), 'KO16MSWIN949', 'KO16MSWIN949') sub_sta_nm\n      ,ride_pasgr_num, alight_pasgr_num, work_dt, commt\n  from vw_sub_mon_stat@dl_us7 a\n;<\/pre>\n\n\n\n<p>The execution result is normally displayed in Korean as follows.<\/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-92.png\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"702\" src=\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-92-1024x702.png\" alt=\"\" class=\"wp-image-11968\" srcset=\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-92-1024x702.png 1024w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-92-300x206.png 300w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-92-768x527.png 768w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-92-18x12.png 18w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-92-24x16.png 24w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-92-36x25.png 36w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-92-48x33.png 48w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-92.png 1050w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/a><figcaption class=\"wp-element-caption\">Test #1-2) Result of importing ORAUS7 data through View in ORAMSWIN949<\/figcaption><\/figure>\n<\/div>\n\n\n<h3 class=\"wp-block-heading\" id=\"\ud14c\uc2a4\ud2b8_#2)_ORAUTF_\uc5d0\uc11c_ORAMSWIN949_\ub370\uc774\ud130_\uac00\uc838\uc624\uae30\"><span class=\"ez-toc-section\" id=\"%ED%85%8C%EC%8A%A4%ED%8A%B8_2_ORAUTF_%EC%97%90%EC%84%9C_ORAMSWIN949_%EB%8D%B0%EC%9D%B4%ED%84%B0_%EA%B0%80%EC%A0%B8%EC%98%A4%EA%B8%B0\"><\/span>Test #2) Get ORAMSWIN949 data from ORAUTF<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>Characterset is normally converted from MSWIN949 to UTF8 on DB Link, and Korean is imported well.<\/p>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"oracledb\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\" data-no-auto-translation=\"\">-- ORAUTF\uc5d0\uc11c ORAMSWIN949 \ub370\uc774\ud130 \uac00\uc838\uc624\uae30\nselect use_mon, line_num, sub_sta_id, sub_sta_nm, ride_pasgr_num, alight_pasgr_num, work_dt, commt\n  from sub_mon_stat@dl_mswin949\n;<\/pre>\n\n\n\n<p>The execution result is as follows.<\/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-93.png\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"702\" src=\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-93-1024x702.png\" alt=\"\ud14c\uc2a4\ud2b8 #2) ORAUTF \uc5d0\uc11c ORAMSWIN949 \ub370\uc774\ud130 \uac00\uc838\uc624\uae30 \uc2e4\ud589 \uacb0\uacfc\" class=\"wp-image-11969\" srcset=\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-93-1024x702.png 1024w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-93-300x206.png 300w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-93-768x527.png 768w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-93-18x12.png 18w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-93-24x16.png 24w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-93-36x25.png 36w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-93-48x33.png 48w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-93.png 1050w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/a><figcaption class=\"wp-element-caption\">Result of test #2) Get ORAMSWIN949 data from ORAUTF<\/figcaption><\/figure>\n<\/div>\n\n\n<h3 class=\"wp-block-heading\" id=\"\ud14c\uc2a4\ud2b8_#3)_ORAUTF_\uc5d0\uc11c_ORAUS7_\ub370\uc774\ud130_\uac00\uc838\uc624\uae30\"><span class=\"ez-toc-section\" id=\"%ED%85%8C%EC%8A%A4%ED%8A%B8_3_ORAUTF_%EC%97%90%EC%84%9C_ORAUS7_%EB%8D%B0%EC%9D%B4%ED%84%B0_%EA%B0%80%EC%A0%B8%EC%98%A4%EA%B8%B0\"><\/span>Test #3) Get ORAUS7 data from ORAUTF<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>As in \u201cTest #1) Importing ORAUS7 data from ORAMSWIN949\u201d, Korean characters are displayed as ? (question mark).<\/p>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"oracledb\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\" data-no-auto-translation=\"\">select use_mon, line_num, sub_sta_id, sub_sta_nm, ride_pasgr_num, alight_pasgr_num, work_dt, commt\n  from sub_mon_stat@dl_us7\n;<\/pre>\n\n\n\n<p>The execution result is as follows.<\/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-94.png\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"702\" src=\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-94-1024x702.png\" alt=\"\" class=\"wp-image-11970\" srcset=\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-94-1024x702.png 1024w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-94-300x206.png 300w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-94-768x527.png 768w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-94-18x12.png 18w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-94-24x16.png 24w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-94-36x25.png 36w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-94-48x33.png 48w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-94.png 1050w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/a><figcaption class=\"wp-element-caption\">Test #3-1) Result of importing ORAUS7 data from ORAUTF<\/figcaption><\/figure>\n<\/div>\n\n\n<p>In order to display Korean normally, the view created in the \u201cTest #1) Importing ORAUS7 data from ORAMSWIN949\u201d step is used as it is, and only the CONVERT function parameter of the SQL executed in ORAUTF through DB Link needs to be slightly changed.<\/p>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"oracledb\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\" data-no-auto-translation=\"\">-- ORAUTF: utl_raw.cast_to_varchar2, convert \ud568\uc218 \uc801\uc6a9\ud558\uc5ec \ud55c\uae00 \ub370\uc774\ud130 \uc815\uc0c1 \ud45c\uc2dc\nselect use_mon\n      ,convert(utl_raw.cast_to_varchar2(line_num_raw), 'AL32UTF8', 'KO16MSWIN949') line_num\n      ,sub_sta_id\n      ,convert(utl_raw.cast_to_varchar2(sub_sta_nm_raw), 'AL32UTF8', 'KO16MSWIN949') sub_sta_nm\n      ,ride_pasgr_num, alight_pasgr_num, work_dt, commt\n  from vw_sub_mon_stat@dl_us7 a\n;<\/pre>\n\n\n\n<p>AL32UTF8 is specified because the second parameter of the CONVERT function means the destination character set.<\/p>\n\n\n\n<p>The execution result is as follows.<\/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-95.png\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"702\" src=\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-95-1024x702.png\" alt=\"\ud14c\uc2a4\ud2b8 #3-2) ORAUTF \uc5d0\uc11c View\ub97c \ud1b5\ud574 ORAUS7 \ub370\uc774\ud130 \uac00\uc838\uc624\uae30 \uc2e4\ud589 \uacb0\uacfc\" class=\"wp-image-11971\" srcset=\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-95-1024x702.png 1024w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-95-300x206.png 300w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-95-768x527.png 768w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-95-18x12.png 18w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-95-24x16.png 24w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-95-36x25.png 36w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-95-48x33.png 48w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-95.png 1050w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/a><figcaption class=\"wp-element-caption\">Test #3-2) Result of importing ORAUS7 data through View in ORAUTF<\/figcaption><\/figure>\n<\/div>\n\n\n<h3 class=\"wp-block-heading\" id=\"\ucc38\uace0\"><span class=\"ez-toc-section\" id=\"%EC%B0%B8%EA%B3%A0\"><\/span>Reference<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<h4 class=\"wp-block-heading\" id=\"RAW_data_type_\uc0b4\ud3b4\ubcf4\uae30\"><span class=\"ez-toc-section\" id=\"RAW_data_type_%EC%82%B4%ED%8E%B4%EB%B3%B4%EA%B8%B0\"><\/span>Explore RAW data types<span class=\"ez-toc-section-end\"><\/span><\/h4>\n\n\n\n<p>Some excerpts from the oracle documentation about RAW data types are given below.<\/p>\n\n\n\n<p>source:&nbsp;<a href=\"https:\/\/docs.oracle.com\/cd\/E11882_01\/server.112\/e41084\/sql_elements001.htm#SQLRF50993\" target=\"_blank\" rel=\"noreferrer noopener\">https:\/\/docs.oracle.com\/cd\/E11882_01\/server.112\/e41084\/sql_elements001.htm#SQLRF50993<\/a><\/p>\n\n\n\n<blockquote class=\"wp-block-quote is-layout-flow wp-block-quote-is-layout-flow\">\n<p>RAW and LONG RAW Data Types<\/p>\n\n\n\n<p>The RAW and LONG RAW data types store data that is not to be explicitly converted by Oracle Database when moving data between different systems.&nbsp;<span style=\"background-color: #f6e199;\">These data types are intended for binary data or byte strings.<\/span> For example, you can use LONG RAW to store graphics, sound, documents, or arrays of binary data, for which the interpretation is dependent on the use.<\/p>\n\n\n\n<p>\u2026<\/p>\n\n\n\n<p>RAW is a variable-length data type like VARCHAR2, except that Oracle Net (which connects client software to a database or one database to another) and the Oracle import and export utilities&nbsp;<span style=\"background-color: #f6e199;\">do not perform character conversion when transmitting RAW or LONG RAW data<\/span> In contrast, Oracle Net and the Oracle import and export utilities automatically convert CHAR, VARCHAR2, and LONG data between different database character sets, if data is transported between databases, or between the database character set and the client character set, if data is transported between a database and a client. The client character set is determined by the type of the client interface, such as OCI or JDBC, and the client configuration (for example, the NLS_LANG environment variable).<\/p>\n<\/blockquote>\n\n\n\n<p>The meaning of the sentence with inverted color among the above contents is as follows.<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>These data types are intended for binary data or byte strings<br>\u2013&gt; RAW data type is used to store binary data.<\/li>\n\n\n\n<li>do not perform character conversion when transmitting RAW or LONG RAW data<br>\u2013&gt; When transmitting RAW data type through DB Link (Oracle Net), character set is not converted.<\/li>\n<\/ul>\n\n\n\n<h4 class=\"wp-block-heading\" id=\"Chracter_set_\ubcc0\ud658_\ud568\uc218_CONVERT\"><span class=\"ez-toc-section\" id=\"Character_set_%EB%B3%80%ED%99%98_%ED%95%A8%EC%88%98_CONVERT\"><\/span>Character set conversion function CONVERT<span class=\"ez-toc-section-end\"><\/span><\/h4>\n\n\n\n<p>Some excerpts from the oracle documentation about the CONVERT function are given below.<\/p>\n\n\n\n<p>source:&nbsp;<a href=\"https:\/\/docs.oracle.com\/cd\/E11882_01\/server.112\/e41084\/functions034.htm#SQLRF00620\" target=\"_blank\" rel=\"noreferrer noopener\">https:\/\/docs.oracle.com\/cd\/E11882_01\/server.112\/e41084\/functions034.htm#SQLRF00620<\/a><\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><a href=\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-96.png\"><img loading=\"lazy\" decoding=\"async\" width=\"534\" height=\"172\" src=\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-96.png\" alt=\"Character set \ubcc0\ud658 \ud568\uc218 CONVERT Syntax\" class=\"wp-image-11972\" srcset=\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-96.png 534w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-96-300x97.png 300w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-96-18x6.png 18w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-96-24x8.png 24w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-96-36x12.png 36w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-96-48x15.png 48w\" sizes=\"auto, (max-width: 534px) 100vw, 534px\" \/><\/a><figcaption class=\"wp-element-caption\">Character set conversion function CONVERT Syntax<\/figcaption><\/figure>\n<\/div>\n\n\n<blockquote class=\"wp-block-quote is-layout-flow wp-block-quote-is-layout-flow\">\n<p>CONVERT converts a character string from one character set to another.<\/p>\n\n\n\n<p>&nbsp; \u2013 The char argument is the value to be converted. It can be any of the data types CHAR, VARCHAR2, NCHAR, NVARCHAR2, CLOB, or NCLOB.<\/p>\n\n\n\n<p>&nbsp; \u2013 The dest_char_set argument is the name of the character set to which char is converted.<\/p>\n\n\n\n<p>&nbsp; \u2013 The source_char_set argument is the name of the character set in which char is stored in the database. The default value is the database character set.<\/p>\n\n\n\n<p>The return value for CHAR and VARCHAR2 is VARCHAR2. For NCHAR and NVARCHAR2, it is NVARCHAR2. For CLOB, it is CLOB, and for NCLOB, it is NCLOB.<\/p>\n<\/blockquote>\n\n\n\n<h4 class=\"wp-block-heading\" id=\"\uc8fc\uc758\uc0ac\ud56d\"><span class=\"ez-toc-section\" id=\"%EC%A3%BC%EC%9D%98%EC%82%AC%ED%95%AD\"><\/span>Precautions<span class=\"ez-toc-section-end\"><\/span><\/h4>\n\n\n\n<p>RAW data type can be used up to 2000 bytes. It can be extended after Oracle 12c R2, but generally up to 2000 bytes. In US7ASCII, Hangul is stored in 2 bytes, so this method can be applied only up to 1000 Hangul characters.<\/p>\n\n\n\n<p>(If English letters and numbers are included, the number of convertible characters may increase.)<\/p>\n\n\n\n<p>To convert data exceeding 2000 bytes, it seems possible to divide the view into two or more columns and combine them after converting in the instance (eg ORAUTF) that reads the view, but this has not been tested.<\/p>\n\n\n\n<p>Pay attention to the maximum number of bytes that can be converted.<\/p>","protected":false},"excerpt":{"rendered":"<p>Continuing from the previous article (Oracle Character Set Conversion (8): 6. How to Convert a User-implemented Character Set (1)), we look at how to convert a user-implemented Character Set. You can check how to convert from KO16MSWIN949, US7ASCII to AL32UTF8 using DB Link, CTAS, and UTL_RAW packages. 6.2.3. Method 3) DB Link &amp; CTAS &amp; UTL_RAW...<\/p>","protected":false},"author":1,"featured_media":11972,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[32],"tags":[261,262,242,248,249,254,255,259,260],"class_list":["post-11964","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-oracle","tag-ctas","tag-utl_raw","tag-oracle","tag-character-set-","tag-character-set-conversion","tag-us7ascii","tag-ko16mswin949","tag-al32utf8","tag-db-link"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.3 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Oracle Character Set \ubcc0\ud658(9): 6. \uc0ac\uc6a9\uc790 \uad6c\ud604 Character Set \ubcc0\ud658 \ubc29\ubc95 (2) - \uc0dd\uc0b0\uc131 Skill<\/title>\n<meta name=\"description\" content=\"\uc0ac\uc6a9\uc790 \uad6c\ud604 Character Set \ubcc0\ud658 \ubc29\ubc95 \uc5d0 \ub300\ud574 \uc0b4\ud3b4\ubcf8\ub2e4. DB Link, CTAS, UTL_RAW package\ub97c \ud65c\uc6a9\ud558\uc5ec KO16MSWIN949, US7ASCII\uc5d0\uc11c AL32UTF8\ub85c \ubcc0\ud658\ud558\ub294 \ubc29\ubc95\uc744 \ud655\uc778\ud560 \uc218 \uc788\ub2e4.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/prodskill.com\/en\/oracle-character-set-migration-9-dblink-ctas-utl_raw\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Oracle Character Set \ubcc0\ud658(9): 6. \uc0ac\uc6a9\uc790 \uad6c\ud604 Character Set \ubcc0\ud658 \ubc29\ubc95 (2) - \uc0dd\uc0b0\uc131 Skill\" \/>\n<meta property=\"og:description\" content=\"\uc0ac\uc6a9\uc790 \uad6c\ud604 Character Set \ubcc0\ud658 \ubc29\ubc95 \uc5d0 \ub300\ud574 \uc0b4\ud3b4\ubcf8\ub2e4. DB Link, CTAS, UTL_RAW package\ub97c \ud65c\uc6a9\ud558\uc5ec KO16MSWIN949, US7ASCII\uc5d0\uc11c AL32UTF8\ub85c \ubcc0\ud658\ud558\ub294 \ubc29\ubc95\uc744 \ud655\uc778\ud560 \uc218 \uc788\ub2e4.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/prodskill.com\/en\/oracle-character-set-migration-9-dblink-ctas-utl_raw\/\" \/>\n<meta property=\"og:site_name\" content=\"\uc0dd\uc0b0\uc131 Skill\" \/>\n<meta property=\"article:published_time\" content=\"2022-10-03T07:47:14+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2023-09-12T09:00:04+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-96.png\" \/>\n\t<meta property=\"og:image:width\" content=\"534\" \/>\n\t<meta property=\"og:image:height\" content=\"172\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Zerom\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Zerom\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"5 minutes\" \/>\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-9-dblink-ctas-utl_raw\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/prodskill.com\\\/oracle-character-set-migration-9-dblink-ctas-utl_raw\\\/\"},\"author\":{\"name\":\"Zerom\",\"@id\":\"https:\\\/\\\/prodskill.com\\\/ko\\\/#\\\/schema\\\/person\\\/bbad0870c78008c82edbe0960fe768bd\"},\"headline\":\"Oracle Character Set \ubcc0\ud658(9): 6. \uc0ac\uc6a9\uc790 \uad6c\ud604 Character Set \ubcc0\ud658 \ubc29\ubc95 (2)\",\"datePublished\":\"2022-10-03T07:47:14+00:00\",\"dateModified\":\"2023-09-12T09:00:04+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/prodskill.com\\\/oracle-character-set-migration-9-dblink-ctas-utl_raw\\\/\"},\"wordCount\":623,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\\\/\\\/prodskill.com\\\/ko\\\/#\\\/schema\\\/person\\\/bbad0870c78008c82edbe0960fe768bd\"},\"image\":{\"@id\":\"https:\\\/\\\/prodskill.com\\\/oracle-character-set-migration-9-dblink-ctas-utl_raw\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/prodskill.com\\\/wp-content\\\/uploads\\\/2022\\\/10\\\/image-96.png\",\"keywords\":[\"CTAS\",\"UTL_RAW\",\"ORACLE\",\"Character Set \ubcc0\ud658\",\"Character Set Conversion\",\"US7ASCII\",\"KO16MSWIN949\",\"AL32UTF8\",\"DB Link\"],\"articleSection\":[\"ORACLE\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/prodskill.com\\\/oracle-character-set-migration-9-dblink-ctas-utl_raw\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/prodskill.com\\\/oracle-character-set-migration-9-dblink-ctas-utl_raw\\\/\",\"url\":\"https:\\\/\\\/prodskill.com\\\/oracle-character-set-migration-9-dblink-ctas-utl_raw\\\/\",\"name\":\"Oracle Character Set \ubcc0\ud658(9): 6. \uc0ac\uc6a9\uc790 \uad6c\ud604 Character Set \ubcc0\ud658 \ubc29\ubc95 (2) - \uc0dd\uc0b0\uc131 Skill\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/prodskill.com\\\/ko\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/prodskill.com\\\/oracle-character-set-migration-9-dblink-ctas-utl_raw\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/prodskill.com\\\/oracle-character-set-migration-9-dblink-ctas-utl_raw\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/prodskill.com\\\/wp-content\\\/uploads\\\/2022\\\/10\\\/image-96.png\",\"datePublished\":\"2022-10-03T07:47:14+00:00\",\"dateModified\":\"2023-09-12T09:00:04+00:00\",\"description\":\"\uc0ac\uc6a9\uc790 \uad6c\ud604 Character Set \ubcc0\ud658 \ubc29\ubc95 \uc5d0 \ub300\ud574 \uc0b4\ud3b4\ubcf8\ub2e4. DB Link, CTAS, UTL_RAW package\ub97c \ud65c\uc6a9\ud558\uc5ec KO16MSWIN949, US7ASCII\uc5d0\uc11c AL32UTF8\ub85c \ubcc0\ud658\ud558\ub294 \ubc29\ubc95\uc744 \ud655\uc778\ud560 \uc218 \uc788\ub2e4.\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/prodskill.com\\\/oracle-character-set-migration-9-dblink-ctas-utl_raw\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/prodskill.com\\\/oracle-character-set-migration-9-dblink-ctas-utl_raw\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/prodskill.com\\\/oracle-character-set-migration-9-dblink-ctas-utl_raw\\\/#primaryimage\",\"url\":\"https:\\\/\\\/prodskill.com\\\/wp-content\\\/uploads\\\/2022\\\/10\\\/image-96.png\",\"contentUrl\":\"https:\\\/\\\/prodskill.com\\\/wp-content\\\/uploads\\\/2022\\\/10\\\/image-96.png\",\"width\":534,\"height\":172},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/prodskill.com\\\/oracle-character-set-migration-9-dblink-ctas-utl_raw\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/prodskill.com\\\/ko\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Oracle Character Set \ubcc0\ud658(9): 6. \uc0ac\uc6a9\uc790 \uad6c\ud604 Character Set \ubcc0\ud658 \ubc29\ubc95 (2)\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/prodskill.com\\\/ko\\\/#website\",\"url\":\"https:\\\/\\\/prodskill.com\\\/ko\\\/\",\"name\":\"\uc0dd\uc0b0\uc131 Skill\",\"description\":\"Meta Thinking, Meta Working\",\"publisher\":{\"@id\":\"https:\\\/\\\/prodskill.com\\\/ko\\\/#\\\/schema\\\/person\\\/bbad0870c78008c82edbe0960fe768bd\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/prodskill.com\\\/ko\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":[\"Person\",\"Organization\"],\"@id\":\"https:\\\/\\\/prodskill.com\\\/ko\\\/#\\\/schema\\\/person\\\/bbad0870c78008c82edbe0960fe768bd\",\"name\":\"Zerom\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/prodskill.com\\\/wp-content\\\/uploads\\\/2022\\\/09\\\/productivity_clockgear.png\",\"url\":\"https:\\\/\\\/prodskill.com\\\/wp-content\\\/uploads\\\/2022\\\/09\\\/productivity_clockgear.png\",\"contentUrl\":\"https:\\\/\\\/prodskill.com\\\/wp-content\\\/uploads\\\/2022\\\/09\\\/productivity_clockgear.png\",\"width\":512,\"height\":512,\"caption\":\"Zerom\"},\"logo\":{\"@id\":\"https:\\\/\\\/prodskill.com\\\/wp-content\\\/uploads\\\/2022\\\/09\\\/productivity_clockgear.png\"},\"url\":\"https:\\\/\\\/prodskill.com\\\/en\\\/author\\\/proda\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Oracle Character Set Conversion (9): 6. User-Implemented Character Set Conversion Method (2) - Productivity Skill","description":"Let&#039;s take a look at how to convert user-implemented character sets. You can see how to convert from KO16MSWIN949, US7ASCII to AL32UTF8 using the DB Link, CTAS, and UTL_RAW packages.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/prodskill.com\/en\/oracle-character-set-migration-9-dblink-ctas-utl_raw\/","og_locale":"en_US","og_type":"article","og_title":"Oracle Character Set \ubcc0\ud658(9): 6. \uc0ac\uc6a9\uc790 \uad6c\ud604 Character Set \ubcc0\ud658 \ubc29\ubc95 (2) - \uc0dd\uc0b0\uc131 Skill","og_description":"\uc0ac\uc6a9\uc790 \uad6c\ud604 Character Set \ubcc0\ud658 \ubc29\ubc95 \uc5d0 \ub300\ud574 \uc0b4\ud3b4\ubcf8\ub2e4. DB Link, CTAS, UTL_RAW package\ub97c \ud65c\uc6a9\ud558\uc5ec KO16MSWIN949, US7ASCII\uc5d0\uc11c AL32UTF8\ub85c \ubcc0\ud658\ud558\ub294 \ubc29\ubc95\uc744 \ud655\uc778\ud560 \uc218 \uc788\ub2e4.","og_url":"https:\/\/prodskill.com\/en\/oracle-character-set-migration-9-dblink-ctas-utl_raw\/","og_site_name":"\uc0dd\uc0b0\uc131 Skill","article_published_time":"2022-10-03T07:47:14+00:00","article_modified_time":"2023-09-12T09:00:04+00:00","og_image":[{"width":534,"height":172,"url":"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-96.png","type":"image\/png"}],"author":"Zerom","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Zerom","Est. reading time":"5 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/prodskill.com\/oracle-character-set-migration-9-dblink-ctas-utl_raw\/#article","isPartOf":{"@id":"https:\/\/prodskill.com\/oracle-character-set-migration-9-dblink-ctas-utl_raw\/"},"author":{"name":"Zerom","@id":"https:\/\/prodskill.com\/ko\/#\/schema\/person\/bbad0870c78008c82edbe0960fe768bd"},"headline":"Oracle Character Set \ubcc0\ud658(9): 6. \uc0ac\uc6a9\uc790 \uad6c\ud604 Character Set \ubcc0\ud658 \ubc29\ubc95 (2)","datePublished":"2022-10-03T07:47:14+00:00","dateModified":"2023-09-12T09:00:04+00:00","mainEntityOfPage":{"@id":"https:\/\/prodskill.com\/oracle-character-set-migration-9-dblink-ctas-utl_raw\/"},"wordCount":623,"commentCount":0,"publisher":{"@id":"https:\/\/prodskill.com\/ko\/#\/schema\/person\/bbad0870c78008c82edbe0960fe768bd"},"image":{"@id":"https:\/\/prodskill.com\/oracle-character-set-migration-9-dblink-ctas-utl_raw\/#primaryimage"},"thumbnailUrl":"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-96.png","keywords":["CTAS","UTL_RAW","ORACLE","Character Set \ubcc0\ud658","Character Set Conversion","US7ASCII","KO16MSWIN949","AL32UTF8","DB Link"],"articleSection":["ORACLE"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/prodskill.com\/oracle-character-set-migration-9-dblink-ctas-utl_raw\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/prodskill.com\/oracle-character-set-migration-9-dblink-ctas-utl_raw\/","url":"https:\/\/prodskill.com\/oracle-character-set-migration-9-dblink-ctas-utl_raw\/","name":"Oracle Character Set Conversion (9): 6. User-Implemented Character Set Conversion Method (2) - Productivity Skill","isPartOf":{"@id":"https:\/\/prodskill.com\/ko\/#website"},"primaryImageOfPage":{"@id":"https:\/\/prodskill.com\/oracle-character-set-migration-9-dblink-ctas-utl_raw\/#primaryimage"},"image":{"@id":"https:\/\/prodskill.com\/oracle-character-set-migration-9-dblink-ctas-utl_raw\/#primaryimage"},"thumbnailUrl":"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-96.png","datePublished":"2022-10-03T07:47:14+00:00","dateModified":"2023-09-12T09:00:04+00:00","description":"Let&#039;s take a look at how to convert user-implemented character sets. You can see how to convert from KO16MSWIN949, US7ASCII to AL32UTF8 using the DB Link, CTAS, and UTL_RAW packages.","breadcrumb":{"@id":"https:\/\/prodskill.com\/oracle-character-set-migration-9-dblink-ctas-utl_raw\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/prodskill.com\/oracle-character-set-migration-9-dblink-ctas-utl_raw\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/prodskill.com\/oracle-character-set-migration-9-dblink-ctas-utl_raw\/#primaryimage","url":"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-96.png","contentUrl":"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-96.png","width":534,"height":172},{"@type":"BreadcrumbList","@id":"https:\/\/prodskill.com\/oracle-character-set-migration-9-dblink-ctas-utl_raw\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/prodskill.com\/ko\/"},{"@type":"ListItem","position":2,"name":"Oracle Character Set \ubcc0\ud658(9): 6. \uc0ac\uc6a9\uc790 \uad6c\ud604 Character Set \ubcc0\ud658 \ubc29\ubc95 (2)"}]},{"@type":"WebSite","@id":"https:\/\/prodskill.com\/ko\/#website","url":"https:\/\/prodskill.com\/ko\/","name":"Productivity Skills","description":"Meta Thinking, Meta Working","publisher":{"@id":"https:\/\/prodskill.com\/ko\/#\/schema\/person\/bbad0870c78008c82edbe0960fe768bd"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/prodskill.com\/ko\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":["Person","Organization"],"@id":"https:\/\/prodskill.com\/ko\/#\/schema\/person\/bbad0870c78008c82edbe0960fe768bd","name":"Zerom","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/productivity_clockgear.png","url":"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/productivity_clockgear.png","contentUrl":"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/productivity_clockgear.png","width":512,"height":512,"caption":"Zerom"},"logo":{"@id":"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/productivity_clockgear.png"},"url":"https:\/\/prodskill.com\/en\/author\/proda\/"}]}},"_links":{"self":[{"href":"https:\/\/prodskill.com\/en\/wp-json\/wp\/v2\/posts\/11964","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/prodskill.com\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/prodskill.com\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/prodskill.com\/en\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/prodskill.com\/en\/wp-json\/wp\/v2\/comments?post=11964"}],"version-history":[{"count":1,"href":"https:\/\/prodskill.com\/en\/wp-json\/wp\/v2\/posts\/11964\/revisions"}],"predecessor-version":[{"id":12418,"href":"https:\/\/prodskill.com\/en\/wp-json\/wp\/v2\/posts\/11964\/revisions\/12418"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/prodskill.com\/en\/wp-json\/wp\/v2\/media\/11972"}],"wp:attachment":[{"href":"https:\/\/prodskill.com\/en\/wp-json\/wp\/v2\/media?parent=11964"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/prodskill.com\/en\/wp-json\/wp\/v2\/categories?post=11964"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/prodskill.com\/en\/wp-json\/wp\/v2\/tags?post=11964"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}