{"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\/ja\/oracle-character-set-migration-9-dblink-ctas-utl_raw\/","title":{"rendered":"Oracle Character Set \u5909\u63db(9): 6. \u30e6\u30fc\u30b6\u30fc\u5b9f\u88c5 Character Set \u5909\u63db\u65b9\u6cd5 (2)"},"content":{"rendered":"<p>\u524d\u306e\u8a18\u4e8b\uff08<a href=\"https:\/\/prodskill.com\/ja\/oracle-character-set-migration-8-datapump-export-import\/\">Oracle Character Set \u5909\u63db(8): 6. \u30e6\u30fc\u30b6\u30fc\u5b9f\u88c5 Character Set \u5909\u63db\u65b9\u6cd5 (1)<\/a>\uff09\u306b\u7d9a\u3044\u3066\u3001\u30e6\u30fc\u30b6\u30fc\u5b9f\u88c5\u306e\u30ad\u30e3\u30e9\u30af\u30bf\u30bb\u30c3\u30c8\u306e\u5909\u63db\u65b9\u6cd5\u306b\u3064\u3044\u3066\u8aac\u660e\u3057\u307e\u3059\u3002 DB Link\u3001CTAS\u3001UTL_RAW\u30d1\u30c3\u30b1\u30fc\u30b8\u3092\u6d3b\u7528\u3057\u3066KO16MSWIN949\u3001US7ASCII\u304b\u3089AL32UTF8\u306b\u5909\u63db\u3059\u308b\u65b9\u6cd5\u3092\u78ba\u8a8d\u3067\u304d\u307e\u3059\u3002<\/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;\u76ee\u6b21&gt;&gt;<\/p>\n<span class=\"ez-toc-title-toggle\"><a href=\"#\" class=\"ez-toc-pull-right ez-toc-btn ez-toc-btn-xs ez-toc-btn-default ez-toc-toggle\" aria-label=\"Toggle Table of Content\"><span class=\"ez-toc-js-icon-con\"><span class=\"\"><span class=\"eztoc-hide\" style=\"display:none;\">Toggle<\/span><span class=\"ez-toc-icon-toggle-span\"><svg style=\"fill: #999;color:#999\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" class=\"list-377408\" width=\"20px\" height=\"20px\" viewbox=\"0 0 24 24\" fill=\"none\"><path d=\"M6 6H4v2h2V6zm14 0H8v2h12V6zM4 11h2v2H4v-2zm16 0H8v2h12v-2zM4 16h2v2H4v-2zm16 0H8v2h12v-2z\" fill=\"currentColor\"><\/path><\/svg><svg style=\"fill: #999;color:#999\" class=\"arrow-unsorted-368013\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"10px\" height=\"10px\" viewbox=\"0 0 24 24\" version=\"1.2\" baseprofile=\"tiny\"><path d=\"M18.2 9.3l-6.2-6.3-6.2 6.3c-.2.2-.3.4-.3.7s.1.5.3.7c.2.2.4.3.7.3h11c.3 0 .5-.1.7-.3.2-.2.3-.5.3-.7s-.1-.5-.3-.7zM5.8 14.7l6.2 6.3 6.2-6.3c.2-.2.3-.5.3-.7s-.1-.5-.3-.7c-.2-.2-.4-.3-.7-.3h-11c-.3 0-.5.1-.7.3-.2.2-.3.5-.3.7s.1.5.3.7z\"\/><\/svg><\/span><\/span><\/span><\/a><\/span><\/div>\n<nav><ul class='ez-toc-list ez-toc-list-level-1' ><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/prodskill.com\/ja\/oracle-character-set-migration-9-dblink-ctas-utl_raw\/#623_%EB%B0%A9%EB%B2%953_DB_Link_CTAS_UTL_RAW\" >6.2.3\u3002\u65b9\u6cd53\uff09DB\u30ea\u30f3\u30af\uff06CTAS\uff06UTL_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\/ja\/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\" >\u30c6\u30b9\u30c8#1\uff09ORAMSWIN949\u304b\u3089ORAUS7\u30c7\u30fc\u30bf\u3092\u30a4\u30f3\u30dd\u30fc\u30c8\u3059\u308b<\/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\/ja\/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\" >\u30c6\u30b9\u30c8#2\uff09ORAUTF\u304b\u3089ORAMSWIN949\u30c7\u30fc\u30bf\u3092\u30a4\u30f3\u30dd\u30fc\u30c8\u3059\u308b<\/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\/ja\/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\" >\u30c6\u30b9\u30c8#3\uff09ORAUTF\u304b\u3089ORAUS7\u30c7\u30fc\u30bf\u3092\u30a4\u30f3\u30dd\u30fc\u30c8\u3059\u308b<\/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\/ja\/oracle-character-set-migration-9-dblink-ctas-utl_raw\/#%EC%B0%B8%EA%B3%A0\" >\u30e1\u30e2<\/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\/ja\/oracle-character-set-migration-9-dblink-ctas-utl_raw\/#RAW_data_type_%EC%82%B4%ED%8E%B4%EB%B3%B4%EA%B8%B0\" >RAW\u30c7\u30fc\u30bf\u578b\u3092\u898b\u308b<\/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\/ja\/oracle-character-set-migration-9-dblink-ctas-utl_raw\/#Character_set_%EB%B3%80%ED%99%98_%ED%95%A8%EC%88%98_CONVERT\" >Character set \u5909\u63db\u95a2\u6570 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\/ja\/oracle-character-set-migration-9-dblink-ctas-utl_raw\/#%EC%A3%BC%EC%9D%98%EC%82%AC%ED%95%AD\" >\u6ce8\u610f\u4e8b\u9805<\/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\u3002\u65b9\u6cd53\uff09DB\u30ea\u30f3\u30af\uff06CTAS\uff06UTL_RAW<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>DB Link\u3092\u4ecb\u3057\u3066\u30c7\u30fc\u30bf\u3092\u30a4\u30f3\u30dd\u30fc\u30c8\u3057\u306a\u304c\u3089Character set\u3092\u5909\u63db\u3059\u308b\u65b9\u6cd5\u3067\u3059\u3002<\/p>\n\n\n\n<p>1\u3064\u306e\u30b5\u30fc\u30d0\u30fc\u306b3\u3064\u306eDB\u30a4\u30f3\u30b9\u30bf\u30f3\u30b9\u3092\u69cb\u6210\u3057\u30013\u3064\u306e\u30c6\u30b9\u30c8\u3092\u5b9f\u884c\u3057\u307e\u3059\u3002<\/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\u30b5\u30fc\u30d0\u30fc\u3001DB Link\u69cb\u6210\u3001\u30c6\u30b9\u30c8\u30b1\u30fc\u30b9<\/figcaption><\/figure>\n<\/div>\n\n\n<ol class=\"wp-block-list\">\n<li>ORAMSWIN949\u304b\u3089ORAUS7\u30c7\u30fc\u30bf\u3092\u30a4\u30f3\u30dd\u30fc\u30c8\u3059\u308b<\/li>\n\n\n\n<li>ORAUTF\u304b\u3089ORAMSWIN949\u30c7\u30fc\u30bf\u3092\u30a4\u30f3\u30dd\u30fc\u30c8\u3059\u308b<\/li>\n\n\n\n<li>ORAUTF\u304b\u3089ORAUS7\u30c7\u30fc\u30bf\u3092\u30a4\u30f3\u30dd\u30fc\u30c8\u3059\u308b<\/li>\n<\/ol>\n\n\n\n<p>ORAUS7\u306b\u4fdd\u5b58\u3055\u308c\u3066\u3044\u308b\u30cf\u30f3\u30b0\u30eb\u30c7\u30fc\u30bf\u306f\u3001\u6b21\u306e\u3088\u3046\u306b\u78ba\u8a8d\u3067\u304d\u307e\u3059\u3002<\/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\">ORAUS7\u306b\u4fdd\u5b58\u3055\u308c\u3066\u3044\u308b\u30cf\u30f3\u30b0\u30eb\u30c7\u30fc\u30bf\u306e\u78ba\u8a8d<\/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>\u4ee5\u4e0b\u306e\u30c6\u30b9\u30c8\u306b\u306fOracle SQL Developer\u3092\u4f7f\u7528\u3057\u3066\u304f\u3060\u3055\u3044\u3002<\/p>\n\n\n\n<p>SQL Developer\u306fOracle\u304c\u63d0\u4f9b\u3059\u308b\u30c4\u30fc\u30eb\u3067\u3042\u308a\u3001\u7121\u6599\u3067\u3059\u3002\u4ee5\u4e0b\u306eURL\u304b\u3089\u30c0\u30a6\u30f3\u30ed\u30fc\u30c9\u3067\u304d\u307e\u3059\u3002<\/p>\n\n\n\n<p><a href=\"https:\/\/www.oracle.com\/database\/sqldeveloper\/technologies\/download\/\" target=\"_blank\" rel=\"noreferrer noopener\">Oracle SQL Developer Downloads<\/a><\/p>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"\ud14c\uc2a4\ud2b8_#1)_ORAMSWIN949_\uc5d0\uc11c_ORAUS7_\ub370\uc774\ud130_\uac00\uc838\uc624\uae30\"><span class=\"ez-toc-section\" id=\"%ED%85%8C%EC%8A%A4%ED%8A%B8_1_ORAMSWIN949_%EC%97%90%EC%84%9C_ORAUS7_%EB%8D%B0%EC%9D%B4%ED%84%B0_%EA%B0%80%EC%A0%B8%EC%98%A4%EA%B8%B0\"><\/span>\u30c6\u30b9\u30c8#1\uff09ORAMSWIN949\u304b\u3089ORAUS7\u30c7\u30fc\u30bf\u3092\u30a4\u30f3\u30dd\u30fc\u30c8\u3059\u308b<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>DL_US7 DB Link\u3092\u4f5c\u6210\u3057\u3001DB Link \u201cdl_us7\u2033\u3092\u6307\u5b9a\u3057\u3066\u30c7\u30fc\u30bf\u3092\u30a4\u30f3\u30dd\u30fc\u30c8\u3067\u304d\u307e\u3059\u3002 script\u306f\u6b21\u306e\u3088\u3046\u306b\u306a\u308a\u307e\u3059\u3002<\/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>\u5b9f\u884c\u7d50\u679c\u306e\u30cf\u30f3\u30b0\u30eb\u306f\u6b63\u5e38\u306b\u8868\u793a\u3055\u308c\u305a\u3001\uff1f\uff08\u7591\u554f\u7b26\uff09\u6587\u5b57\u3067\u8868\u793a\u3055\u308c\u308b\u3002<\/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\">\u30c6\u30b9\u30c8 #1-1) ORAMSWIN949 \u3067\u306e ORAUS7 \u30c7\u30fc\u30bf\u306e\u30a4\u30f3\u30dd\u30fc\u30c8\u5b9f\u884c\u7d50\u679c<\/figcaption><\/figure>\n<\/div>\n\n\n<p>DB Link\u306b\u30c7\u30fc\u30bf\u3092\u30a4\u30f3\u30dd\u30fc\u30c8\u3059\u308b\u3068\u3001server\uff08\u3053\u306e\u5834\u5408\u306fORAUS7\uff09character set\u306fclient\uff08\u3053\u306e\u5834\u5408\u306fORAMSWIN949\uff09\u306echaracter set\u306b\u5909\u63db\u3055\u308c\u307e\u3059\u3002<\/p>\n\n\n\n<p>US7ASCII\u306b\u4fdd\u5b58\u3055\u308c\u305f\u30cf\u30f3\u30b0\u30eb\u306f\u9593\u9055\u3063\u3066\u4fdd\u5b58\u3055\u308c\u3066\u3044\u308b\u305f\u3081\u3001MSWIN949\u306b\u5909\u63db\u3067\u304d\u305a\u3001\u7591\u554f\u7b26\u3067\u8868\u793a\u3055\u308c\u308b\u306e\u3060\u3002<\/p>\n\n\n\n<p>\u3053\u306e\u72b6\u6cc1\u3067ORAUS7\u306e\u30cf\u30f3\u30b0\u30eb\u30c7\u30fc\u30bf\u3092\u6b63\u5e38\u306b\u8868\u793a\u3059\u308b\u306b\u306f\u3001\u6b21\u306e\u65b9\u6cd5\u3092\u9069\u7528\u3057\u307e\u3059\u3002<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>\u30cf\u30f3\u30b0\u30eb\u3092\u542b\u3080VARCHAR2\u30c7\u30fc\u30bf\u578b\u5217\u304c\u30ad\u30e3\u30e9\u30af\u30bf\u30bb\u30c3\u30c8\u306b\u5909\u63db\u3055\u308c\u306a\u3044\u3088\u3046\u306b\u3001UTL_RAW.CAST_TO_RAW\u95a2\u6570\u3092\u4f7f\u7528\u3057\u3066ORAUS7\u306b\u30d3\u30e5\u30fc\u3092\u4f5c\u6210\u3057\u307e\u3059\u3002\n<ul class=\"wp-block-list\">\n<li>\u30cf\u30f3\u30b0\u30eb\u3092\u542b\u3080\u5217\u306bUTL_RAW.CAST_TO_RAW\u95a2\u6570\u3092\u9069\u7528\u3057\u307e\u3059\u3002<\/li>\n\n\n\n<li>RAW\u30c7\u30fc\u30bf\u578b\u306f\u6587\u5b57\u30bb\u30c3\u30c8\u3092\u5909\u63db\u3057\u307e\u305b\u3093\u3002<\/li>\n<\/ul>\n<\/li>\n\n\n\n<li>ORAMSWIN949\u3067\u306f\u3001\u4e0a\u8a18\u3067\u4f5c\u6210\u3057\u305fView\u3092\u30af\u30a8\u30ea\u3057\u3001RAW\u30c7\u30fc\u30bf\u578b\u3092VARCHAR2\u306b\u5909\u63db\u3057\u3001CONVERT\u95a2\u6570\u306bsource character set\u3068destination character set\u3092\u6307\u5b9a\u3057\u3066\u901a\u5e38\u306e\u30cf\u30f3\u30b0\u30eb\u306b\u5909\u63db\u3057\u307e\u3059\u3002<\/li>\n<\/ul>\n\n\n\n<p>ORAUS7 instance\u3067\u3001VARCHAR2\u30c7\u30fc\u30bf\u578b\u3092RAW\u30c7\u30fc\u30bf\u578b\u306b\u5909\u63db\u3059\u308bView\u3092\u4ee5\u4e0b\u306e\u30b9\u30af\u30ea\u30d7\u30c8\u306b\u751f\u6210\u3057\u307e\u3059\u3002<\/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>\u5b9f\u884c\u7d50\u679c\u306f\u3001\u4ee5\u4e0b\u306e\u3088\u3046\u306b\u30cf\u30f3\u30b0\u30eb\u304c\u6b63\u5e38\u306b\u8868\u793a\u3055\u308c\u308b\u3002<\/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\">\u30c6\u30b9\u30c8 #1-2) ORAMSWIN949 \u304b\u3089 View \u3092\u4ecb\u3057\u305f ORAUS7 \u30c7\u30fc\u30bf\u306e\u30a4\u30f3\u30dd\u30fc\u30c8\u306e\u5b9f\u884c\u7d50\u679c<\/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>\u30c6\u30b9\u30c8#2\uff09ORAUTF\u304b\u3089ORAMSWIN949\u30c7\u30fc\u30bf\u3092\u30a4\u30f3\u30dd\u30fc\u30c8\u3059\u308b<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>DB Link\u4e0a\u3067MSWIN949\u304b\u3089UTF8\u306b\u6b63\u5e38\u306bcharacterset\u304c\u5909\u63db\u3055\u308c\u3001\u30cf\u30f3\u30b0\u30eb\u3092\u3046\u307e\u304f\u30a4\u30f3\u30dd\u30fc\u30c8\u3059\u308b\u3002<\/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>\u5b9f\u884c\u7d50\u679c\u306f\u6b21\u306e\u3068\u304a\u308a\u3067\u3059\u3002<\/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\">\u30c6\u30b9\u30c8 #2) ORAUTF \u304b\u3089\u306e ORAMSWIN949 \u30c7\u30fc\u30bf\u306e\u30a4\u30f3\u30dd\u30fc\u30c8\u5b9f\u884c\u7d50\u679c<\/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>\u30c6\u30b9\u30c8#3\uff09ORAUTF\u304b\u3089ORAUS7\u30c7\u30fc\u30bf\u3092\u30a4\u30f3\u30dd\u30fc\u30c8\u3059\u308b<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>\u300c\u30c6\u30b9\u30c8#1\uff09ORAMSWIN949\u304b\u3089ORAUS7\u30c7\u30fc\u30bf\u3092\u30a4\u30f3\u30dd\u30fc\u30c8\u3059\u308b\u300d\u3068\u540c\u69d8\u306b\u3001\u30cf\u30f3\u30b0\u30eb\u306f\uff1f\uff08\u7591\u554f\u7b26\uff09\u3067\u8868\u793a\u3055\u308c\u307e\u3059\u3002<\/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>\u5b9f\u884c\u7d50\u679c\u306f\u6b21\u306e\u3068\u304a\u308a\u3067\u3059\u3002<\/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\">\u30c6\u30b9\u30c8#3-1\uff09ORAUTF\u304b\u3089\u306eORAUS7\u30c7\u30fc\u30bf\u306e\u30a4\u30f3\u30dd\u30fc\u30c8\u5b9f\u884c\u7d50\u679c<\/figcaption><\/figure>\n<\/div>\n\n\n<p>\u30cf\u30f3\u30b0\u30eb\u3092\u6b63\u5e38\u306b\u8868\u793a\u3059\u308b\u306b\u306f\u3001\u300c\u30c6\u30b9\u30c8#1\uff09ORAMSWIN949\u304b\u3089ORAUS7\u30c7\u30fc\u30bf\u3092\u30a4\u30f3\u30dd\u30fc\u30c8\u3059\u308b\u300d\u30b9\u30c6\u30c3\u30d7\u3067\u4f5c\u6210\u3057\u305fView\u306f\u305d\u306e\u307e\u307e\u4f7f\u7528\u3057\u3001ORAUTF\u3067DB Link\u3092\u4ecb\u3057\u3066\u5b9f\u884c\u3059\u308bSQL\u306eCONVERT\u95a2\u6570\u30d1\u30e9\u30e1\u30fc\u30bf\u3060\u3051\u5c11\u3057\u5909\u66f4\u3059\u308c\u3070\u3088\u3044\u3002<\/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>CONVERT\u95a2\u6570\u306e2\u756a\u76ee\u306e\u30d1\u30e9\u30e1\u30fc\u30bf\u306fdestination character set\u3092\u610f\u5473\u3059\u308b\u306e\u3067\u3001AL32UTF8\u3092\u6307\u5b9a\u3057\u307e\u3057\u305f\u3002<\/p>\n\n\n\n<p>\u5b9f\u884c\u7d50\u679c\u306f\u4ee5\u4e0b\u306e\u901a\u308a\u3067\u3042\u308b\u3002<\/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\">\u30c6\u30b9\u30c8#3-2\uff09ORAUTF\u304b\u3089View\u3092\u4ecb\u3057\u305fORAUS7\u30c7\u30fc\u30bf\u306e\u30a4\u30f3\u30dd\u30fc\u30c8\u306e\u5b9f\u884c\u7d50\u679c<\/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>\u30e1\u30e2<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>RAW\u30c7\u30fc\u30bf\u578b\u3092\u898b\u308b<span class=\"ez-toc-section-end\"><\/span><\/h4>\n\n\n\n<p>RAW\u30c7\u30fc\u30bf\u578b\u306eoracle\u6587\u66f8\u306e\u5185\u5bb9\u306e\u4e00\u90e8\u3092\u4ee5\u4e0b\u306b\u629c\u7c8b\u3057\u3066\u304a\u304d\u307e\u3059\u3002<\/p>\n\n\n\n<p>\u30bd\u30fc\u30b9\uff1a&nbsp;<a href=\"https:\/\/docs.oracle.com\/cd\/E11882_01\/server.112\/e41084\/sql_elements001.htm#SQLRF50993\" target=\"_blank\" rel=\"noreferrer noopener\">https:\/\/docs.oracle.com\/cd\/E11882_01\/server.112\/e41084\/sql_elements001.htm#SQLRF50993<\/a><\/p>\n\n\n\n<blockquote class=\"wp-block-quote is-layout-flow wp-block-quote-is-layout-flow\">\n<p>RAW and LONG RAW Data Types<\/p>\n\n\n\n<p>The RAW and LONG RAW data types store data that is not to be explicitly converted by Oracle Database when moving data between different systems.&nbsp;<span style=\"background-color: #f6e199;\">These data types are intended for binary data or byte strings.<\/span> For example, you can use LONG RAW to store graphics, sound, documents, or arrays of binary data, for which the interpretation is dependent on the use.<\/p>\n\n\n\n<p>\u2026<\/p>\n\n\n\n<p>RAW is a variable-length data type like VARCHAR2, except that Oracle Net (which connects client software to a database or one database to another) and the Oracle import and export utilities&nbsp;<span style=\"background-color: #f6e199;\">do not perform character conversion when transmitting RAW or LONG RAW data<\/span> In contrast, Oracle Net and the Oracle import and export utilities automatically convert CHAR, VARCHAR2, and LONG data between different database character sets, if data is transported between databases, or between the database character set and the client character set, if data is transportd between a database and a client. The client character set is determined by the type of the client interface, such as OCI or JDBC, and the client configuration (for example, the NLS_LANG environment variable).<\/p>\n<\/blockquote>\n\n\n\n<p>\u4e0a\u8a18\u5185\u5bb9\u306e\u3046\u3061\u3001\u8272\u3092\u53cd\u8ee2\u3057\u305f\u6587\u7ae0\u306e\u610f\u5473\u306f\u6b21\u306e\u901a\u308a\u3067\u3042\u308b\u3002<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>These data types are intended for binary data or byte strings<br>- &gt; RAW\u30c7\u30fc\u30bf\u578b\u306f\u3001\u30d0\u30a4\u30ca\u30ea\u30c7\u30fc\u30bf\u3092\u683c\u7d0d\u3059\u308b\u305f\u3081\u306e\u7528\u9014\u3067\u3059\u3002<\/li>\n\n\n\n<li>do not perform character conversion when transmitting RAW or LONG RAW data<br>- &gt; DB Link\uff08Oracle Net\uff09\u3092\u4ecb\u3057\u3066RAW\u30c7\u30fc\u30bf\u578b\u3092\u8ee2\u9001\u3059\u308b\u5834\u5408\u306f\u3001\u6587\u5b57\u30bb\u30c3\u30c8\u3092\u5909\u63db\u3057\u307e\u305b\u3093\u3002<\/li>\n<\/ul>\n\n\n\n<h4 class=\"wp-block-heading\" id=\"Chracter_set_\ubcc0\ud658_\ud568\uc218_CONVERT\"><span class=\"ez-toc-section\" id=\"Character_set_%EB%B3%80%ED%99%98_%ED%95%A8%EC%88%98_CONVERT\"><\/span>Character set \u5909\u63db\u95a2\u6570 CONVERT<span class=\"ez-toc-section-end\"><\/span><\/h4>\n\n\n\n<p>CONVERT \u95a2\u6570\u306e oracle \u30c9\u30ad\u30e5\u30e1\u30f3\u30c8\u306e\u5185\u5bb9\u306e\u4e00\u90e8\u3092\u4ee5\u4e0b\u306b\u629c\u7c8b\u3057\u3066\u304a\u304d\u307e\u3059\u3002<\/p>\n\n\n\n<p>\u30bd\u30fc\u30b9\uff1a&nbsp;<a href=\"https:\/\/docs.oracle.com\/cd\/E11882_01\/server.112\/e41084\/functions034.htm#SQLRF00620\" target=\"_blank\" rel=\"noreferrer noopener\">https:\/\/docs.oracle.com\/cd\/E11882_01\/server.112\/e41084\/functions034.htm#SQLRF00620<\/a><\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><a href=\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-96.png\"><img loading=\"lazy\" decoding=\"async\" width=\"534\" height=\"172\" src=\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-96.png\" alt=\"Character set \ubcc0\ud658 \ud568\uc218 CONVERT Syntax\" class=\"wp-image-11972\" srcset=\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-96.png 534w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-96-300x97.png 300w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-96-18x6.png 18w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-96-24x8.png 24w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-96-36x12.png 36w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-96-48x15.png 48w\" sizes=\"auto, (max-width: 534px) 100vw, 534px\" \/><\/a><figcaption class=\"wp-element-caption\">Character set \u5909\u63db\u95a2\u6570 CONVERT Syntax<\/figcaption><\/figure>\n<\/div>\n\n\n<blockquote class=\"wp-block-quote is-layout-flow wp-block-quote-is-layout-flow\">\n<p>CONVERT converts a character string from one character set to another.<\/p>\n\n\n\n<p>&nbsp; \u2013 The char argument is the value to be converted. It can be any of the data types CHAR, VARCHAR2, NCHAR, NVARCHAR2, CLOB, or NCLOB.<\/p>\n\n\n\n<p>&nbsp; \u2013 The dest_char_set argument is the name of the character set to which char is converted.<\/p>\n\n\n\n<p>&nbsp; \u2013 The source_char_set argument is the name of the character set in which char is stored in the database. The default value is the database character set.<\/p>\n\n\n\n<p>The return value for CHAR and VARCHAR2 is VARCHAR2. For NCHAR and NVARCHAR2, it is NVARCHAR2. For CLOB, it is CLOB, and for NCLOB, it is NCLOB.<\/p>\n<\/blockquote>\n\n\n\n<h4 class=\"wp-block-heading\" id=\"\uc8fc\uc758\uc0ac\ud56d\"><span class=\"ez-toc-section\" id=\"%EC%A3%BC%EC%9D%98%EC%82%AC%ED%95%AD\"><\/span>\u6ce8\u610f\u4e8b\u9805<span class=\"ez-toc-section-end\"><\/span><\/h4>\n\n\n\n<p>RAW\u30c7\u30fc\u30bf\u30bf\u30a4\u30d7\u306f2000\u30d0\u30a4\u30c8\u307e\u3067\u5229\u7528\u53ef\u80fd\u3067\u3059\u3002 Oracle 12c R2\u4ee5\u964d\u306f\u62e1\u5f35\u53ef\u80fd\u3067\u3059\u304c\u3001\u901a\u5e38\u306f2000\u30d0\u30a4\u30c8\u307e\u3067\u3067\u3059\u3002 US7ASCII\u3067\u306f\u3001\u30cf\u30f3\u30b0\u30eb\u306f2\u30d0\u30a4\u30c8\u3067\u4fdd\u5b58\u3055\u308c\u308b\u305f\u3081\u3001\u6700\u5927\u30cf\u30f3\u30b0\u30eb1000\u6587\u5b57\u307e\u3067\u306e\u307f\u3053\u306e\u65b9\u6cd5\u3092\u9069\u7528\u3067\u304d\u307e\u3059\u3002<\/p>\n\n\n\n<p>\uff08\u82f1\u5b57\u306e\u6570\u5b57\u304c\u542b\u307e\u308c\u3066\u3044\u308b\u5834\u5408\u3001\u5909\u63db\u53ef\u80fd\u306a\u6587\u5b57\u6570\u306f\u5897\u3048\u308b\u3053\u3068\u304c\u3067\u304d\u308b\u3002\uff09<\/p>\n\n\n\n<p>2000\u30d0\u30a4\u30c8\u3092\u8d85\u3048\u308b\u30c7\u30fc\u30bf\u3092\u5909\u63db\u3059\u308b\u306b\u306f\u3001View\u304b\u30892\u3064\u4ee5\u4e0a\u306e\u5217\u306b\u5206\u5272\u3057\u3001View\u3092\u8aad\u307f\u53d6\u308b\u30a4\u30f3\u30b9\u30bf\u30f3\u30b9\uff08ORAUTF\u306a\u3069\uff09\u3067\u5909\u63db\u5f8c\u306b\u7d50\u5408\u3059\u308b\u65b9\u6cd5\u304c\u53ef\u80fd\u3067\u3042\u308b\u3068\u306f\u898b\u3048\u307e\u305b\u3093\u3067\u3057\u305f\u3002<\/p>\n\n\n\n<p>\u5909\u63db\u53ef\u80fd\u306a\u6700\u5927\u30d0\u30a4\u30c8\u6570\u306b\u6ce8\u610f\u304c\u5fc5\u8981\u3067\u3059\u3002<\/p>","protected":false},"excerpt":{"rendered":"<p>\u524d\u306e\u8a18\u4e8b\uff08Oracle Character Set\u5909\u63db\uff088\uff09\uff1a6.\u30e6\u30fc\u30b6\u30fc\u5b9f\u88c5Character Set\u5909\u63db\u65b9\u6cd5\uff081\uff09\uff09\u306b\u7d9a\u3044\u3066\u3001\u30e6\u30fc\u30b6\u30fc\u5b9f\u88c5Character Set\u5909\u63db\u65b9\u6cd5\u306b\u3064\u3044\u3066\u8aac\u660e\u3057\u307e\u3059\u3002 DB Link\u3001CTAS\u3001UTL_RAW\u30d1\u30c3\u30b1\u30fc\u30b8\u3092\u6d3b\u7528\u3057\u3066KO16MSWIN949\u3001US7ASCII\u304b\u3089AL32UTF8\u306b\u5909\u63db\u3059\u308b\u65b9\u6cd5\u3092\u78ba\u8a8d\u3067\u304d\u307e\u3059\u3002 6.2.3\u3002\u65b9\u6cd53\uff09DB\u30ea\u30f3\u30af\uff06CTAS\uff06UTL_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":[259,260,261,262,242,248,249,254,255],"class_list":["post-11964","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-oracle","tag-al32utf8","tag-db-link","tag-ctas","tag-utl_raw","tag-oracle","tag-character-set-","tag-character-set-conversion","tag-us7ascii","tag-ko16mswin949"],"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\/ja\/oracle-character-set-migration-9-dblink-ctas-utl_raw\/\" \/>\n<meta property=\"og:locale\" content=\"ja_JP\" \/>\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\/ja\/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=\"\u57f7\u7b46\u8005\" \/>\n\t<meta name=\"twitter:data1\" content=\"Zerom\" \/>\n\t<meta name=\"twitter:label2\" content=\"\u63a8\u5b9a\u8aad\u307f\u53d6\u308a\u6642\u9593\" \/>\n\t<meta name=\"twitter:data2\" content=\"5\u5206\" \/>\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\":[\"AL32UTF8\",\"DB Link\",\"CTAS\",\"UTL_RAW\",\"ORACLE\",\"Character Set \ubcc0\ud658\",\"Character Set Conversion\",\"US7ASCII\",\"KO16MSWIN949\"],\"articleSection\":[\"ORACLE\"],\"inLanguage\":\"ja\",\"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\":\"ja\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/prodskill.com\\\/oracle-character-set-migration-9-dblink-ctas-utl_raw\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"ja\",\"@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\":\"ja\"},{\"@type\":[\"Person\",\"Organization\"],\"@id\":\"https:\\\/\\\/prodskill.com\\\/ko\\\/#\\\/schema\\\/person\\\/bbad0870c78008c82edbe0960fe768bd\",\"name\":\"Zerom\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"ja\",\"@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\\\/ja\\\/author\\\/proda\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Oracle Character Set \u5909\u63db(9): 6. \u30e6\u30fc\u30b6\u30fc\u5b9f\u88c5 Character Set \u5909\u63db\u65b9\u6cd5 (2) - \u751f\u7523\u6027 Skill","description":"\u30e6\u30fc\u30b6\u30fc\u5b9f\u88c5\u306e\u30ad\u30e3\u30e9\u30af\u30bf\u30bb\u30c3\u30c8\u306e\u5909\u63db\u65b9\u6cd5\u3092\u898b\u3066\u304f\u3060\u3055\u3044\u3002 DB Link\u3001CTAS\u3001UTL_RAW\u30d1\u30c3\u30b1\u30fc\u30b8\u3092\u6d3b\u7528\u3057\u3066KO16MSWIN949\u3001US7ASCII\u304b\u3089AL32UTF8\u306b\u5909\u63db\u3059\u308b\u65b9\u6cd5\u3092\u78ba\u8a8d\u3067\u304d\u307e\u3059\u3002","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\/ja\/oracle-character-set-migration-9-dblink-ctas-utl_raw\/","og_locale":"ja_JP","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\/ja\/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":{"\u57f7\u7b46\u8005":"Zerom","\u63a8\u5b9a\u8aad\u307f\u53d6\u308a\u6642\u9593":"5\u5206"},"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":["AL32UTF8","DB Link","CTAS","UTL_RAW","ORACLE","Character Set \ubcc0\ud658","Character Set Conversion","US7ASCII","KO16MSWIN949"],"articleSection":["ORACLE"],"inLanguage":"ja","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 \u5909\u63db(9): 6. \u30e6\u30fc\u30b6\u30fc\u5b9f\u88c5 Character Set \u5909\u63db\u65b9\u6cd5 (2) - \u751f\u7523\u6027 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":"\u30e6\u30fc\u30b6\u30fc\u5b9f\u88c5\u306e\u30ad\u30e3\u30e9\u30af\u30bf\u30bb\u30c3\u30c8\u306e\u5909\u63db\u65b9\u6cd5\u3092\u898b\u3066\u304f\u3060\u3055\u3044\u3002 DB Link\u3001CTAS\u3001UTL_RAW\u30d1\u30c3\u30b1\u30fc\u30b8\u3092\u6d3b\u7528\u3057\u3066KO16MSWIN949\u3001US7ASCII\u304b\u3089AL32UTF8\u306b\u5909\u63db\u3059\u308b\u65b9\u6cd5\u3092\u78ba\u8a8d\u3067\u304d\u307e\u3059\u3002","breadcrumb":{"@id":"https:\/\/prodskill.com\/oracle-character-set-migration-9-dblink-ctas-utl_raw\/#breadcrumb"},"inLanguage":"ja","potentialAction":[{"@type":"ReadAction","target":["https:\/\/prodskill.com\/oracle-character-set-migration-9-dblink-ctas-utl_raw\/"]}]},{"@type":"ImageObject","inLanguage":"ja","@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":"\u751f\u7523\u6027\u30b9\u30ad\u30eb","description":"\u30e1\u30bf\u30b7\u30f3\u30ad\u30f3\u30b0\u3001\u30e1\u30bf\u30ef\u30fc\u30af","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":"ja"},{"@type":["Person","Organization"],"@id":"https:\/\/prodskill.com\/ko\/#\/schema\/person\/bbad0870c78008c82edbe0960fe768bd","name":"Zerom","image":{"@type":"ImageObject","inLanguage":"ja","@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\/ja\/author\/proda\/"}]}},"_links":{"self":[{"href":"https:\/\/prodskill.com\/ja\/wp-json\/wp\/v2\/posts\/11964","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/prodskill.com\/ja\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/prodskill.com\/ja\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/prodskill.com\/ja\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/prodskill.com\/ja\/wp-json\/wp\/v2\/comments?post=11964"}],"version-history":[{"count":1,"href":"https:\/\/prodskill.com\/ja\/wp-json\/wp\/v2\/posts\/11964\/revisions"}],"predecessor-version":[{"id":12418,"href":"https:\/\/prodskill.com\/ja\/wp-json\/wp\/v2\/posts\/11964\/revisions\/12418"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/prodskill.com\/ja\/wp-json\/wp\/v2\/media\/11972"}],"wp:attachment":[{"href":"https:\/\/prodskill.com\/ja\/wp-json\/wp\/v2\/media?parent=11964"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/prodskill.com\/ja\/wp-json\/wp\/v2\/categories?post=11964"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/prodskill.com\/ja\/wp-json\/wp\/v2\/tags?post=11964"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}