{"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\/de\/oracle-character-set-migration-9-dblink-ctas-utl_raw\/","title":{"rendered":"Oracle-Zeichensatzkonvertierung (9): 6. So konvertieren Sie vom Benutzer implementierte Zeichens\u00e4tze (2)"},"content":{"rendered":"<p>Vorherigen Post (<a href=\"https:\/\/prodskill.com\/de\/oracle-character-set-migration-8-datapump-export-import\/\">Oracle-Zeichensatzkonvertierung(8): 6. So konvertieren Sie einen vom Benutzer implementierten Zeichensatz (1)<\/a>) wird die vom Benutzer implementierte Zeichensatzkonvertierungsmethode untersucht. Sie k\u00f6nnen \u00fcberpr\u00fcfen, wie Sie mithilfe von DB Link-, CTAS- und UTL_RAW-Paketen von KO16MSWIN949, US7ASCII in AL32UTF8 konvertieren.<\/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;Inhaltsverzeichnis&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=\"Inhaltsverzeichnis umschalten\"><span class=\"ez-toc-js-icon-con\"><span class=\"\"><span class=\"eztoc-hide\" style=\"display:none;\">Umschalten<\/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\/de\/oracle-character-set-migration-9-dblink-ctas-utl_raw\/#623_%EB%B0%A9%EB%B2%953_DB_Link_CTAS_UTL_RAW\" >6.2.3. Methode 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\/de\/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) Holen Sie sich ORAUS7-Daten von 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\/de\/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) Holen Sie sich ORAMSWIN949-Daten von 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\/de\/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) Holen Sie sich ORAUS7-Daten von 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\/de\/oracle-character-set-migration-9-dblink-ctas-utl_raw\/#%EC%B0%B8%EA%B3%A0\" >Bezug<\/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\/de\/oracle-character-set-migration-9-dblink-ctas-utl_raw\/#RAW_data_type_%EC%82%B4%ED%8E%B4%EB%B3%B4%EA%B8%B0\" >Entdecken Sie RAW-Datentypen<\/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\/de\/oracle-character-set-migration-9-dblink-ctas-utl_raw\/#Character_set_%EB%B3%80%ED%99%98_%ED%95%A8%EC%88%98_CONVERT\" >Zeichensatzkonvertierungsfunktion 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\/de\/oracle-character-set-migration-9-dblink-ctas-utl_raw\/#%EC%A3%BC%EC%9D%98%EC%82%AC%ED%95%AD\" >Vorsichtsma\u00dfnahmen<\/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. Methode 3) DB Link &amp; CTAS &amp; UTL_RAW<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>Dies ist eine Methode zum Konvertieren von Zeichens\u00e4tzen beim Importieren von Daten \u00fcber DB Link.<\/p>\n\n\n\n<p>Konfigurieren Sie drei DB-Instances auf einem Server und f\u00fchren Sie drei Tests durch.<\/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-Konfiguration, Testfall<\/figcaption><\/figure>\n<\/div>\n\n\n<ol class=\"wp-block-list\">\n<li>Holen Sie sich ORAUS7-Daten von ORAMSWIN949<\/li>\n\n\n\n<li>Holen Sie sich ORAMSWIN949-Daten von ORAUTF<\/li>\n\n\n\n<li>Holen Sie sich ORAUS7-Daten von ORAUTF<\/li>\n<\/ol>\n\n\n\n<p>In ORAUS7 gespeicherte Hangul-Daten k\u00f6nnen wie folgt \u00fcberpr\u00fcft werden.<\/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\">\u00dcberpr\u00fcfen Sie die in ORAUS7 gespeicherten Hangul-Daten<\/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>Die folgenden Tests verwenden Oracle SQL Developer.<\/p>\n\n\n\n<p>SQL Developer ist ein von Oracle bereitgestelltes und kostenloses Tool. Sie k\u00f6nnen es von der unten stehenden URL herunterladen.<\/p>\n\n\n\n<p><a href=\"https:\/\/www.oracle.com\/database\/sqldeveloper\/technologies\/download\/\" target=\"_blank\" rel=\"noreferrer noopener\">Downloads f\u00fcr Oracle SQL-Entwickler<\/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) Holen Sie sich ORAUS7-Daten von ORAMSWIN949<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>Sie k\u00f6nnen Daten importieren, indem Sie einen DL_US7-DB-Link erstellen und den DB-Link \u201edl_us7\u201c angeben. Das Skript ist wie folgt.<\/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>Koreanische Zeichen im Ausf\u00fchrungsergebnis werden nicht normal angezeigt, sondern erscheinen als ?-Zeichen (Fragezeichen).<\/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) Ergebnis des Imports von ORAUS7-Daten aus ORAMSWIN949<\/figcaption><\/figure>\n<\/div>\n\n\n<p>Beim Datenimport \u00fcber DB Link wird der Zeichensatz des Servers (hier ORAUS7) in den Zeichensatz des Clients (hier ORAMSWIN949) konvertiert.<\/p>\n\n\n\n<p>Das in US7ASCII gespeicherte Hangul wird falsch gespeichert, sodass es nicht in MSWIN949 konvertiert werden kann, sodass es als Fragezeichen angezeigt wird.<\/p>\n\n\n\n<p>Um in dieser Situation die koreanischen ORAUS7-Daten normal anzuzeigen, wenden Sie die folgende Methode an.<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Erstellen Sie eine Ansicht in ORAUS7 mit der Funktion UTL_RAW.CAST_TO_RAW, um zu verhindern, dass Spalten des Datentyps VARCHAR2, die koreanische Zeichen enthalten, in Zeichens\u00e4tze konvertiert werden.\n<ul class=\"wp-block-list\">\n<li>Wenden Sie die Funktion UTL_RAW.CAST_TO_RAW auf Spalten an, die koreanische Zeichen enthalten.<\/li>\n\n\n\n<li>Der RAW-Datentyp konvertiert den Zeichensatz nicht.<\/li>\n<\/ul>\n<\/li>\n\n\n\n<li>ORAMSWIN949 fragt die oben erstellte Ansicht ab, konvertiert den RAW-Datentyp zur\u00fcck in VARCHAR2 und konvertiert es in normales Hangul, indem es den Quellzeichensatz und den Zielzeichensatz mit der Funktion CONVERT angibt.<\/li>\n<\/ul>\n\n\n\n<p>Erstellen Sie mit dem folgenden Skript eine Ansicht, die den Datentyp VARCHAR2 in den Datentyp RAW in der ORAUS7-Instanz konvertiert.<\/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>Das Ausf\u00fchrungsergebnis wird normalerweise wie folgt auf Koreanisch angezeigt.<\/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) Ergebnis des Imports von ORAUS7-Daten \u00fcber Ansicht 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) Holen Sie sich ORAMSWIN949-Daten von ORAUTF<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>Der Zeichensatz wird normalerweise auf DB Link von MSWIN949 in UTF8 konvertiert, und Koreanisch wird gut importiert.<\/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>Das Ausf\u00fchrungsergebnis ist wie folgt.<\/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\">Testergebnis #2) Holen Sie sich ORAMSWIN949-Daten von 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) Holen Sie sich ORAUS7-Daten von ORAUTF<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>Wie in \u201eTest #1) Importieren von ORAUS7-Daten aus ORAMSWIN949\u201c werden koreanische Zeichen als ? (Fragezeichen) angezeigt.<\/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>Das Ausf\u00fchrungsergebnis ist wie folgt.<\/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) Ergebnis des Imports von ORAUS7-Daten aus ORAUTF<\/figcaption><\/figure>\n<\/div>\n\n\n<p>Um Koreanisch normal anzuzeigen, wird die im Schritt \u201eTest #1) Importieren von ORAUS7-Daten aus ORAMSWIN949\u201c erstellte Ansicht so verwendet, wie sie ist, und nur der CONVERT-Funktionsparameter der in ORAUTF \u00fcber DB Link ausgef\u00fchrten SQL muss geringf\u00fcgig ge\u00e4ndert werden.<\/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 wird angegeben, da der zweite Parameter der CONVERT-Funktion den Zielzeichensatz angibt.<\/p>\n\n\n\n<p>Das Ausf\u00fchrungsergebnis ist wie folgt.<\/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) Ergebnis des Imports von ORAUS7-Daten durch 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>Bezug<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>Entdecken Sie RAW-Datentypen<span class=\"ez-toc-section-end\"><\/span><\/h4>\n\n\n\n<p>Nachfolgend finden Sie einige Ausz\u00fcge aus der Oracle-Dokumentation zu RAW-Datentypen.<\/p>\n\n\n\n<p>Quelle:&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- und LONG RAW-Datentypen<\/p>\n\n\n\n<p>Die Datentypen RAW und LONG RAW speichern Daten, die nicht explizit von Oracle Database konvertiert werden sollen, wenn Daten zwischen verschiedenen Systemen verschoben werden.&nbsp;<span style=\"background-color: #f6e199;\">Diese Datentypen sind f\u00fcr bin\u00e4re Daten oder Bytefolgen vorgesehen.<\/span> Beispielsweise k\u00f6nnen Sie LONG RAW verwenden, um Grafiken, Sound, Dokumente oder Arrays von Bin\u00e4rdaten zu speichern, deren Interpretation von der Verwendung abh\u00e4ngt.<\/p>\n\n\n\n<p>\u2026<\/p>\n\n\n\n<p>RAW ist ein Datentyp mit variabler L\u00e4nge wie VARCHAR2, mit Ausnahme von Oracle Net (das Client-Software mit einer Datenbank oder einer Datenbank mit einer anderen verbindet) und den Import- und Exportdienstprogrammen von Oracle&nbsp;<span style=\"background-color: #f6e199;\">F\u00fchren Sie keine Zeichenkonvertierung durch, wenn Sie RAW- oder LONG RAW-Daten \u00fcbertragen<\/span> Im Gegensatz dazu konvertieren Oracle Net und die Import- und Export-Dienstprogramme von Oracle automatisch CHAR-, VARCHAR2- und LONG-Daten zwischen verschiedenen Datenbankzeichens\u00e4tzen, wenn Daten zwischen Datenbanken transportiert werden, oder zwischen dem Datenbankzeichensatz und dem Client-Zeichensatz, wenn Daten transportiert werden zwischen einer Datenbank und einem Client. Der Client-Zeichensatz wird durch den Typ der Client-Schnittstelle, z. B. OCI oder JDBC, und die Client-Konfiguration (z. B. die Umgebungsvariable NLS_LANG) bestimmt.<\/p>\n<\/blockquote>\n\n\n\n<p>Die Bedeutung des Satzes mit umgekehrter Farbe unter den obigen Inhalten ist wie folgt.<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Diese Datentypen sind f\u00fcr bin\u00e4re Daten oder Bytefolgen vorgesehen<br>\u2013&gt; RAW-Datentyp wird zum Speichern von Bin\u00e4rdaten verwendet.<\/li>\n\n\n\n<li>F\u00fchren Sie keine Zeichenkonvertierung durch, wenn Sie RAW- oder LONG RAW-Daten \u00fcbertragen<br>\u2013&gt; Beim \u00dcbertragen des RAW-Datentyps \u00fcber DB Link (Oracle Net) wird der Zeichensatz nicht konvertiert.<\/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>Zeichensatzkonvertierungsfunktion CONVERT<span class=\"ez-toc-section-end\"><\/span><\/h4>\n\n\n\n<p>Nachfolgend finden Sie einige Ausz\u00fcge aus der Oracle-Dokumentation zur CONVERT-Funktion.<\/p>\n\n\n\n<p>Quelle:&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\">Zeichensatzkonvertierungsfunktion 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 wandelt eine Zeichenkette von einem Zeichensatz in einen anderen um.<\/p>\n\n\n\n<p>&nbsp; \u2013 Das Argument char ist der umzuwandelnde Wert. Es kann jeder der Datentypen CHAR, VARCHAR2, NCHAR, NVARCHAR2, CLOB oder NCLOB sein.<\/p>\n\n\n\n<p>&nbsp; \u2013 Das Argument dest_char_set ist der Name des Zeichensatzes, in den char konvertiert wird.<\/p>\n\n\n\n<p>&nbsp; \u2013 Das Argument source_char_set ist der Name des Zeichensatzes, in dem char in der Datenbank gespeichert ist. Der Standardwert ist der Datenbankzeichensatz.<\/p>\n\n\n\n<p>Der R\u00fcckgabewert f\u00fcr CHAR und VARCHAR2 ist VARCHAR2. F\u00fcr NCHAR und NVARCHAR2 ist es NVARCHAR2. F\u00fcr CLOB ist es CLOB und f\u00fcr NCLOB ist 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>Vorsichtsma\u00dfnahmen<span class=\"ez-toc-section-end\"><\/span><\/h4>\n\n\n\n<p>RAW-Datentyp kann bis zu 2000 Byte verwendet werden. Es kann nach Oracle 12c R2 erweitert werden, jedoch im Allgemeinen bis zu 2000 Bytes. In US7ASCII wird Hangul in 2 Bytes gespeichert, daher kann diese Methode nur bis zu 1000 Hangul-Zeichen angewendet werden.<\/p>\n\n\n\n<p>(Wenn englische Buchstaben und Zahlen enthalten sind, kann sich die Anzahl der konvertierbaren Zeichen erh\u00f6hen.)<\/p>\n\n\n\n<p>Um Daten von mehr als 2000 Byte zu konvertieren, scheint es m\u00f6glich, die Ansicht in zwei oder mehr Spalten zu unterteilen und sie nach der Konvertierung in der Instanz (z. B. ORAUTF), die die Ansicht liest, zusammenzufassen, dies wurde jedoch nicht getestet.<\/p>\n\n\n\n<p>Beachten Sie die maximale Anzahl an Bytes, die konvertiert werden k\u00f6nnen.<\/p>","protected":false},"excerpt":{"rendered":"<p>Als Fortsetzung des vorherigen Artikels (Oracle Character Set Conversion (8): 6. How to Convert a User-implemented Character Set (1)) schauen wir uns an, wie man einen benutzerimplementierten Zeichensatz konvertiert. Sie k\u00f6nnen \u00fcberpr\u00fcfen, wie Sie mithilfe von DB Link-, CTAS- und UTL_RAW-Paketen von KO16MSWIN949, US7ASCII in AL32UTF8 konvertieren. 6.2.3. Methode 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":[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.4 - 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\/de\/oracle-character-set-migration-9-dblink-ctas-utl_raw\/\" \/>\n<meta property=\"og:locale\" content=\"de_DE\" \/>\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\/de\/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=\"Verfasst von\" \/>\n\t<meta name=\"twitter:data1\" content=\"Zerom\" \/>\n\t<meta name=\"twitter:label2\" content=\"Gesch\u00e4tzte Lesezeit\" \/>\n\t<meta name=\"twitter:data2\" content=\"5\u00a0Minuten\" \/>\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\":\"de\",\"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\":\"de\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/prodskill.com\\\/oracle-character-set-migration-9-dblink-ctas-utl_raw\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"de\",\"@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\":\"de\"},{\"@type\":[\"Person\",\"Organization\"],\"@id\":\"https:\\\/\\\/prodskill.com\\\/ko\\\/#\\\/schema\\\/person\\\/bbad0870c78008c82edbe0960fe768bd\",\"name\":\"Zerom\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"de\",\"@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\\\/de\\\/author\\\/proda\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Oracle-Zeichensatzkonvertierung (9): 6. Benutzerimplementierte Zeichensatzkonvertierungsmethode (2) - Produktivit\u00e4tskompetenz","description":"Sehen wir uns an, wie benutzerdefinierte Zeichens\u00e4tze konvertiert werden. Sie k\u00f6nnen sehen, wie Sie mit den Paketen DB Link, CTAS und UTL_RAW von KO16MSWIN949, US7ASCII nach AL32UTF8 konvertieren.","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\/de\/oracle-character-set-migration-9-dblink-ctas-utl_raw\/","og_locale":"de_DE","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\/de\/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":{"Verfasst von":"Zerom","Gesch\u00e4tzte Lesezeit":"5\u00a0Minuten"},"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":"de","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-Zeichensatzkonvertierung (9): 6. Benutzerimplementierte Zeichensatzkonvertierungsmethode (2) - Produktivit\u00e4tskompetenz","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":"Sehen wir uns an, wie benutzerdefinierte Zeichens\u00e4tze konvertiert werden. Sie k\u00f6nnen sehen, wie Sie mit den Paketen DB Link, CTAS und UTL_RAW von KO16MSWIN949, US7ASCII nach AL32UTF8 konvertieren.","breadcrumb":{"@id":"https:\/\/prodskill.com\/oracle-character-set-migration-9-dblink-ctas-utl_raw\/#breadcrumb"},"inLanguage":"de","potentialAction":[{"@type":"ReadAction","target":["https:\/\/prodskill.com\/oracle-character-set-migration-9-dblink-ctas-utl_raw\/"]}]},{"@type":"ImageObject","inLanguage":"de","@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":"Produktivit\u00e4tsf\u00e4higkeiten","description":"Meta-Denken, Meta-Arbeiten","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":"de"},{"@type":["Person","Organization"],"@id":"https:\/\/prodskill.com\/ko\/#\/schema\/person\/bbad0870c78008c82edbe0960fe768bd","name":"Nullm","image":{"@type":"ImageObject","inLanguage":"de","@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\/de\/author\/proda\/"}]}},"_links":{"self":[{"href":"https:\/\/prodskill.com\/de\/wp-json\/wp\/v2\/posts\/11964","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/prodskill.com\/de\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/prodskill.com\/de\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/prodskill.com\/de\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/prodskill.com\/de\/wp-json\/wp\/v2\/comments?post=11964"}],"version-history":[{"count":1,"href":"https:\/\/prodskill.com\/de\/wp-json\/wp\/v2\/posts\/11964\/revisions"}],"predecessor-version":[{"id":12418,"href":"https:\/\/prodskill.com\/de\/wp-json\/wp\/v2\/posts\/11964\/revisions\/12418"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/prodskill.com\/de\/wp-json\/wp\/v2\/media\/11972"}],"wp:attachment":[{"href":"https:\/\/prodskill.com\/de\/wp-json\/wp\/v2\/media?parent=11964"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/prodskill.com\/de\/wp-json\/wp\/v2\/categories?post=11964"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/prodskill.com\/de\/wp-json\/wp\/v2\/tags?post=11964"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}