{"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\/es\/oracle-character-set-migration-9-dblink-ctas-utl_raw\/","title":{"rendered":"Conversi\u00f3n de juegos de caracteres de Oracle (9): 6. C\u00f3mo convertir juegos de caracteres implementados por el usuario (2)"},"content":{"rendered":"<p>Publicaci\u00f3n anterior (<a href=\"https:\/\/prodskill.com\/es\/oracle-character-set-migration-8-datapump-export-import\/\">Conversi\u00f3n de conjuntos de caracteres de Oracle(8): 6. C\u00f3mo convertir un conjunto de caracteres implementado por el usuario (1)<\/a>), se examina el m\u00e9todo de conversi\u00f3n de juego de caracteres implementado por el usuario. Puede verificar c\u00f3mo convertir de KO16MSWIN949, US7ASCII a AL32UTF8 usando los paquetes DB Link, CTAS y UTL_RAW.<\/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;Tabla de contenidos&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=\"Pesta\u00f1a de contenido alternativo\"><span class=\"ez-toc-js-icon-con\"><span class=\"\"><span class=\"eztoc-hide\" style=\"display:none;\">Palanca<\/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\/es\/oracle-character-set-migration-9-dblink-ctas-utl_raw\/#623_%EB%B0%A9%EB%B2%953_DB_Link_CTAS_UTL_RAW\" >6.2.3. M\u00e9todo 3) Enlace DB y CTAS y 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\/es\/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\" >Prueba #1) Obtenga datos ORAUS7 de 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\/es\/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\" >Prueba #2) Obtenga datos ORAMSWIN949 de 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\/es\/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\" >Prueba #3) Obtener datos ORAUS7 de 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\/es\/oracle-character-set-migration-9-dblink-ctas-utl_raw\/#%EC%B0%B8%EA%B3%A0\" >Referencia<\/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\/es\/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 los tipos de datos RAW<\/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\/es\/oracle-character-set-migration-9-dblink-ctas-utl_raw\/#Character_set_%EB%B3%80%ED%99%98_%ED%95%A8%EC%88%98_CONVERT\" >Funci\u00f3n de conversi\u00f3n de juego de caracteres CONVERTIR<\/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\/es\/oracle-character-set-migration-9-dblink-ctas-utl_raw\/#%EC%A3%BC%EC%9D%98%EC%82%AC%ED%95%AD\" >Precauciones<\/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. M\u00e9todo 3) Enlace DB y CTAS y UTL_RAW<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>Este es un m\u00e9todo para convertir juegos de caracteres mientras se importan datos a trav\u00e9s de DB Link.<\/p>\n\n\n\n<p>Configure tres instancias de base de datos en un servidor y ejecute tres pruebas.<\/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\">Servidor de base de datos, configuraci\u00f3n de enlace de base de datos, caso de prueba<\/figcaption><\/figure>\n<\/div>\n\n\n<ol class=\"wp-block-list\">\n<li>Obtenga datos de ORAUS7 de ORAMSWIN949<\/li>\n\n\n\n<li>Obtenga datos de ORAMSWIN949 de ORAUTF<\/li>\n\n\n\n<li>Obtenga datos de ORAUS7 de ORAUTF<\/li>\n<\/ol>\n\n\n\n<p>Los datos Hangul almacenados en ORAUS7 se pueden verificar de la siguiente manera.<\/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\">Verifique los datos Hangul almacenados en 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>Las siguientes pruebas utilizan Oracle SQL Developer.<\/p>\n\n\n\n<p>SQL Developer es una herramienta proporcionada por Oracle y es gratuita. Puede descargarlo desde la siguiente URL.<\/p>\n\n\n\n<p><a href=\"https:\/\/www.oracle.com\/database\/sqldeveloper\/technologies\/download\/\" target=\"_blank\" rel=\"noreferrer noopener\">Descargas para desarrolladores de Oracle SQL<\/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>Prueba #1) Obtenga datos ORAUS7 de ORAMSWIN949<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>Puede importar datos creando un enlace de base de datos DL_US7 y especificando el enlace de base de datos &quot;dl_us7&quot;. El gui\u00f3n es el siguiente.<\/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>Los caracteres coreanos en el resultado de la ejecuci\u00f3n no se muestran normalmente, sino que aparecen como caracteres ? (signo de interrogaci\u00f3n).<\/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\">Prueba #1-1) Resultado de la importaci\u00f3n de datos ORAUS7 desde ORAMSWIN949<\/figcaption><\/figure>\n<\/div>\n\n\n<p>Cuando los datos se importan a trav\u00e9s de DB Link, el juego de caracteres del servidor (ORAUS7 en este caso) se convierte al juego de caracteres del cliente (ORAMSWIN949 en este caso).<\/p>\n\n\n\n<p>Hangul almacenado en US7ASCII se almacena incorrectamente, por lo que no se puede convertir a MSWIN949, por lo que se muestra como un signo de interrogaci\u00f3n.<\/p>\n\n\n\n<p>Para mostrar los datos coreanos de ORAUS7 normalmente en esta situaci\u00f3n, aplique el siguiente m\u00e9todo.<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Cree una vista en ORAUS7 utilizando la funci\u00f3n UTL_RAW.CAST_TO_RAW para evitar que las columnas de tipo de datos VARCHAR2 que contienen caracteres coreanos se conviertan en conjuntos de caracteres.\n<ul class=\"wp-block-list\">\n<li>Aplique la funci\u00f3n UTL_RAW.CAST_TO_RAW a las columnas que contengan caracteres coreanos.<\/li>\n\n\n\n<li>El tipo de datos RAW no convierte el juego de caracteres.<\/li>\n<\/ul>\n<\/li>\n\n\n\n<li>ORAMSWIN949 consulta la Vista creada anteriormente, convierte el tipo de datos RAW de nuevo a VARCHAR2 y lo convierte a Hangul normal especificando el conjunto de caracteres de origen y el conjunto de caracteres de destino con la funci\u00f3n CONVERTIR.<\/li>\n<\/ul>\n\n\n\n<p>Cree una vista que convierta el tipo de datos VARCHAR2 al tipo de datos RAW en la instancia de ORAUS7 con el siguiente script.<\/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>El resultado de la ejecuci\u00f3n normalmente se muestra en coreano de la siguiente manera.<\/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\">Prueba #1-2) Resultado de la importaci\u00f3n de datos ORAUS7 a trav\u00e9s de Ver en 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>Prueba #2) Obtenga datos ORAMSWIN949 de ORAUTF<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>El juego de caracteres normalmente se convierte de MSWIN949 a UTF8 en DB Link, y el coreano se importa bien.<\/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>El resultado de la ejecuci\u00f3n es el siguiente.<\/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\">Resultado de la prueba #2) Obtener datos ORAMSWIN949 de 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>Prueba #3) Obtener datos ORAUS7 de ORAUTF<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>Al igual que en \u201cPrueba #1) Importaci\u00f3n de datos de ORAUS7 desde ORAMSWIN949\u201d, los caracteres coreanos se muestran como ? (signo de interrogaci\u00f3n).<\/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>El resultado de la ejecuci\u00f3n es el siguiente.<\/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\">Prueba #3-1) Resultado de la importaci\u00f3n de datos ORAUS7 desde ORAUTF<\/figcaption><\/figure>\n<\/div>\n\n\n<p>Para mostrar el coreano normalmente, la vista creada en el paso &quot;Prueba #1) Importaci\u00f3n de datos de ORAUS7 desde ORAMSWIN949&quot; se usa tal cual, y solo se debe cambiar ligeramente el par\u00e1metro de la funci\u00f3n CONVERTIR del SQL ejecutado en ORAUTF a trav\u00e9s de DB Link.<\/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>Se especifica AL32UTF8 porque el segundo par\u00e1metro de la funci\u00f3n CONVERTIR significa el conjunto de caracteres de destino.<\/p>\n\n\n\n<p>El resultado de la ejecuci\u00f3n es el siguiente.<\/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\">Prueba #3-2) Resultado de importar datos de ORAUS7 a trav\u00e9s de Ver en 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>Referencia<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 los tipos de datos RAW<span class=\"ez-toc-section-end\"><\/span><\/h4>\n\n\n\n<p>A continuaci\u00f3n se proporcionan algunos extractos de la documentaci\u00f3n de Oracle sobre los tipos de datos RAW.<\/p>\n\n\n\n<p>fuente:&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>Tipos de datos RAW y LONG RAW<\/p>\n\n\n\n<p>Los tipos de datos RAW y LONG RAW almacenan datos que Oracle Database no debe convertir expl\u00edcitamente al mover datos entre diferentes sistemas.&nbsp;<span style=\"background-color: #f6e199;\">Estos tipos de datos est\u00e1n destinados a datos binarios o cadenas de bytes.<\/span> Por ejemplo, puede usar LONG RAW para almacenar gr\u00e1ficos, sonido, documentos o matrices de datos binarios, cuya interpretaci\u00f3n depende del uso.<\/p>\n\n\n\n<p>\u2026<\/p>\n\n\n\n<p>RAW es un tipo de datos de longitud variable como VARCHAR2, excepto que Oracle Net (que conecta el software del cliente a una base de datos o una base de datos a otra) y las utilidades de importaci\u00f3n y exportaci\u00f3n de Oracle&nbsp;<span style=\"background-color: #f6e199;\">no realice la conversi\u00f3n de caracteres al transmitir datos RAW o LONG RAW<\/span> Por el contrario, Oracle Net y las utilidades de importaci\u00f3n y exportaci\u00f3n de Oracle convierten autom\u00e1ticamente los datos CHAR, VARCHAR2 y LONG entre diferentes juegos de caracteres de base de datos, si los datos se transportan entre bases de datos, o entre el juego de caracteres de la base de datos y el juego de caracteres del cliente, si se transportan datos. entre una base de datos y un cliente. El juego de caracteres del cliente est\u00e1 determinado por el tipo de interfaz del cliente, como OCI o JDBC, y la configuraci\u00f3n del cliente (por ejemplo, la variable de entorno NLS_LANG).<\/p>\n<\/blockquote>\n\n\n\n<p>El significado de la oraci\u00f3n con color invertido entre los contenidos anteriores es el siguiente.<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Estos tipos de datos est\u00e1n destinados a datos binarios o cadenas de bytes.<br>\u2013&gt; El tipo de datos RAW se utiliza para almacenar datos binarios.<\/li>\n\n\n\n<li>no realice la conversi\u00f3n de caracteres al transmitir datos RAW o LONG RAW<br>\u2013&gt; Cuando se transmite el tipo de datos RAW a trav\u00e9s de DB Link (Oracle Net), el conjunto de caracteres no se convierte.<\/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>Funci\u00f3n de conversi\u00f3n de juego de caracteres CONVERTIR<span class=\"ez-toc-section-end\"><\/span><\/h4>\n\n\n\n<p>A continuaci\u00f3n se proporcionan algunos extractos de la documentaci\u00f3n de Oracle sobre la funci\u00f3n CONVERTIR.<\/p>\n\n\n\n<p>fuente:&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\">Funci\u00f3n de conversi\u00f3n de juego de caracteres CONVERT Sintaxis<\/figcaption><\/figure>\n<\/div>\n\n\n<blockquote class=\"wp-block-quote is-layout-flow wp-block-quote-is-layout-flow\">\n<p>CONVERT convierte una cadena de caracteres de un juego de caracteres a otro.<\/p>\n\n\n\n<p>&nbsp; \u2013 El argumento char es el valor a convertir. Puede ser cualquiera de los tipos de datos CHAR, VARCHAR2, NCHAR, NVARCHAR2, CLOB o NCLOB.<\/p>\n\n\n\n<p>&nbsp; \u2013 El argumento dest_char_set es el nombre del conjunto de caracteres al que se convierte char.<\/p>\n\n\n\n<p>&nbsp; \u2013 El argumento source_char_set es el nombre del conjunto de caracteres en el que se almacena char en la base de datos. El valor predeterminado es el juego de caracteres de la base de datos.<\/p>\n\n\n\n<p>El valor de retorno para CHAR y VARCHAR2 es VARCHAR2. Para NCHAR y NVARCHAR2, es NVARCHAR2. Para CLOB, es CLOB y para NCLOB, es 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>Precauciones<span class=\"ez-toc-section-end\"><\/span><\/h4>\n\n\n\n<p>El tipo de datos RAW se puede utilizar hasta 2000 bytes. Puede extenderse despu\u00e9s de Oracle 12c R2, pero generalmente hasta 2000 bytes. En US7ASCII, Hangul se almacena en 2 bytes, por lo que este m\u00e9todo solo se puede aplicar hasta 1000 caracteres Hangul.<\/p>\n\n\n\n<p>(Si se incluyen letras y n\u00fameros en ingl\u00e9s, la cantidad de caracteres convertibles puede aumentar).<\/p>\n\n\n\n<p>Para convertir datos que excedan los 2000 bytes, parece posible dividir la vista en dos o m\u00e1s columnas y combinarlas despu\u00e9s de convertirlas en la instancia (por ejemplo, ORAUTF) que lee la vista, pero esto no se ha probado.<\/p>\n\n\n\n<p>Preste atenci\u00f3n al n\u00famero m\u00e1ximo de bytes que se pueden convertir.<\/p>","protected":false},"excerpt":{"rendered":"<p>Continuando con el art\u00edculo anterior (Conversi\u00f3n de conjuntos de caracteres de Oracle (8): 6. C\u00f3mo convertir un conjunto de caracteres implementado por el usuario (1)), veremos c\u00f3mo convertir un conjunto de caracteres implementado por el usuario. Puede verificar c\u00f3mo convertir de KO16MSWIN949, US7ASCII a AL32UTF8 usando los paquetes DB Link, CTAS y UTL_RAW. 6.2.3. M\u00e9todo 3) Enlace DB y CTAS y 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":[242,248,249,254,255,259,260,261,262],"class_list":["post-11964","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-ctas","tag-utl_raw"],"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\/es\/oracle-character-set-migration-9-dblink-ctas-utl_raw\/\" \/>\n<meta property=\"og:locale\" content=\"es_ES\" \/>\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\/es\/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=\"Escrito por\" \/>\n\t<meta name=\"twitter:data1\" content=\"Zerom\" \/>\n\t<meta name=\"twitter:label2\" content=\"Tiempo de lectura\" \/>\n\t<meta name=\"twitter:data2\" content=\"5 minutos\" \/>\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\":[\"ORACLE\",\"Character Set \ubcc0\ud658\",\"Character Set Conversion\",\"US7ASCII\",\"KO16MSWIN949\",\"AL32UTF8\",\"DB Link\",\"CTAS\",\"UTL_RAW\"],\"articleSection\":[\"ORACLE\"],\"inLanguage\":\"es\",\"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\":\"es\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/prodskill.com\\\/oracle-character-set-migration-9-dblink-ctas-utl_raw\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"es\",\"@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\":\"es\"},{\"@type\":[\"Person\",\"Organization\"],\"@id\":\"https:\\\/\\\/prodskill.com\\\/ko\\\/#\\\/schema\\\/person\\\/bbad0870c78008c82edbe0960fe768bd\",\"name\":\"Zerom\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"es\",\"@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\\\/es\\\/author\\\/proda\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Conversi\u00f3n de conjuntos de caracteres de Oracle (9): 6. M\u00e9todo de conversi\u00f3n de conjuntos de caracteres implementado por el usuario (2) - Habilidad de productividad","description":"Veamos c\u00f3mo convertir conjuntos de caracteres implementados por el usuario. Puede ver c\u00f3mo convertir de KO16MSWIN949 y US7ASCII a AL32UTF8 usando los paquetes DB Link, CTAS y UTL_RAW.","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\/es\/oracle-character-set-migration-9-dblink-ctas-utl_raw\/","og_locale":"es_ES","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\/es\/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":{"Escrito por":"Zerom","Tiempo de lectura":"5 minutos"},"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":["ORACLE","Character Set \ubcc0\ud658","Character Set Conversion","US7ASCII","KO16MSWIN949","AL32UTF8","DB Link","CTAS","UTL_RAW"],"articleSection":["ORACLE"],"inLanguage":"es","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":"Conversi\u00f3n de conjuntos de caracteres de Oracle (9): 6. M\u00e9todo de conversi\u00f3n de conjuntos de caracteres implementado por el usuario (2) - Habilidad de productividad","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":"Veamos c\u00f3mo convertir conjuntos de caracteres implementados por el usuario. Puede ver c\u00f3mo convertir de KO16MSWIN949 y US7ASCII a AL32UTF8 usando los paquetes DB Link, CTAS y UTL_RAW.","breadcrumb":{"@id":"https:\/\/prodskill.com\/oracle-character-set-migration-9-dblink-ctas-utl_raw\/#breadcrumb"},"inLanguage":"es","potentialAction":[{"@type":"ReadAction","target":["https:\/\/prodskill.com\/oracle-character-set-migration-9-dblink-ctas-utl_raw\/"]}]},{"@type":"ImageObject","inLanguage":"es","@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":"Habilidades de productividad","description":"Meta Pensamiento, Meta Trabajo","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":"es"},{"@type":["Person","Organization"],"@id":"https:\/\/prodskill.com\/ko\/#\/schema\/person\/bbad0870c78008c82edbe0960fe768bd","name":"Cerom","image":{"@type":"ImageObject","inLanguage":"es","@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\/es\/author\/proda\/"}]}},"_links":{"self":[{"href":"https:\/\/prodskill.com\/es\/wp-json\/wp\/v2\/posts\/11964","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/prodskill.com\/es\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/prodskill.com\/es\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/prodskill.com\/es\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/prodskill.com\/es\/wp-json\/wp\/v2\/comments?post=11964"}],"version-history":[{"count":1,"href":"https:\/\/prodskill.com\/es\/wp-json\/wp\/v2\/posts\/11964\/revisions"}],"predecessor-version":[{"id":12418,"href":"https:\/\/prodskill.com\/es\/wp-json\/wp\/v2\/posts\/11964\/revisions\/12418"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/prodskill.com\/es\/wp-json\/wp\/v2\/media\/11972"}],"wp:attachment":[{"href":"https:\/\/prodskill.com\/es\/wp-json\/wp\/v2\/media?parent=11964"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/prodskill.com\/es\/wp-json\/wp\/v2\/categories?post=11964"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/prodskill.com\/es\/wp-json\/wp\/v2\/tags?post=11964"}],"curies":[{"name":"gracias","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}