{"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\/zh\/oracle-character-set-migration-9-dblink-ctas-utl_raw\/","title":{"rendered":"Oracle\u5b57\u7b26\u96c6\u8f6c\u6362\uff08\u4e5d\uff09\uff1a6.\u5982\u4f55\u8f6c\u6362\u7528\u6237\u5b9e\u73b0\u7684\u5b57\u7b26\u96c6\uff08\u4e8c\uff09"},"content":{"rendered":"<p>\u4e0a\u4e00\u7bc7\u6587\u7ae0 (<a href=\"https:\/\/prodskill.com\/zh\/oracle-character-set-migration-8-datapump-export-import\/\">Oracle\u5b57\u7b26\u96c6\u8f6c\u6362\uff08\u516b\uff09\uff1a\u516d\u3001\u5982\u4f55\u8f6c\u6362\u7528\u6237\u5b9e\u73b0\u7684\u5b57\u7b26\u96c6\uff08\u4e00\uff09<\/a>\uff09\uff0c\u6211\u4eec\u6765\u770b\u770b\u7528\u6237\u5b9e\u73b0\u7684\u5b57\u7b26\u96c6\u8f6c\u6362\u65b9\u6cd5\u3002\u60a8\u53ef\u4ee5\u67e5\u770b\u5982\u4f55\u4f7f\u7528 DB Link\u3001CTAS \u548c UTL_RAW \u5305\u5c06 KO16MSWIN949\u3001US7ASCII \u8f6c\u6362\u4e3a AL32UTF8\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\u5f55&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=\"\u5207\u6362\u76ee\u5f55\"><span class=\"ez-toc-js-icon-con\"><span class=\"\"><span class=\"eztoc-hide\" style=\"display:none;\">\u5207\u6362<\/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\/zh\/oracle-character-set-migration-9-dblink-ctas-utl_raw\/#623_%EB%B0%A9%EB%B2%953_DB_Link_CTAS_UTL_RAW\" >6.2.3.\u65b9\u6cd5 3) \u6570\u636e\u5e93\u94fe\u63a5 &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\/zh\/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\" >\u6d4b\u8bd5#1) \u4eceORAMSWIN949\u83b7\u53d6ORAUS7\u6570\u636e<\/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\/zh\/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\" >\u6d4b\u8bd5 #2) \u4ece ORAUTF \u83b7\u53d6 ORAMSWIN949 \u6570\u636e<\/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\/zh\/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\" >\u6d4b\u8bd5 #3) \u4ece ORAUTF \u83b7\u53d6 ORAUS7 \u6570\u636e<\/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\/zh\/oracle-character-set-migration-9-dblink-ctas-utl_raw\/#%EC%B0%B8%EA%B3%A0\" >\u53c2\u8003<\/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\/zh\/oracle-character-set-migration-9-dblink-ctas-utl_raw\/#RAW_data_type_%EC%82%B4%ED%8E%B4%EB%B3%B4%EA%B8%B0\" >\u63a2\u7d22 RAW \u6570\u636e\u7c7b\u578b<\/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\/zh\/oracle-character-set-migration-9-dblink-ctas-utl_raw\/#Character_set_%EB%B3%80%ED%99%98_%ED%95%A8%EC%88%98_CONVERT\" >\u5b57\u7b26\u96c6\u8f6c\u6362\u51fd\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\/zh\/oracle-character-set-migration-9-dblink-ctas-utl_raw\/#%EC%A3%BC%EC%9D%98%EC%82%AC%ED%95%AD\" >\u9884\u9632\u63aa\u65bd<\/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.\u65b9\u6cd5 3) \u6570\u636e\u5e93\u94fe\u63a5 &amp; CTAS &amp; UTL_RAW<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>\u8fd9\u662f\u901a\u8fc7DB Link\u5bfc\u5165\u6570\u636e\u65f6\u8f6c\u6362\u5b57\u7b26\u96c6\u7684\u65b9\u6cd5\u3002<\/p>\n\n\n\n<p>\u5728\u4e00\u53f0\u670d\u52a1\u5668\u4e0a\u914d\u7f6e\u4e09\u4e2a\u6570\u636e\u5e93\u5b9e\u4f8b\u5e76\u8fd0\u884c\u4e09\u4e2a\u6d4b\u8bd5\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\u670d\u52a1\u5668\u3001DB Link\u914d\u7f6e\u3001\u6d4b\u8bd5\u7528\u4f8b<\/figcaption><\/figure>\n<\/div>\n\n\n<ol class=\"wp-block-list\">\n<li>\u4ece ORAMSWIN949 \u5bfc\u5165 ORAUS7 \u6570\u636e<\/li>\n\n\n\n<li>\u4ece ORAUTF \u5bfc\u5165 ORAMSWIN949 \u6570\u636e<\/li>\n\n\n\n<li>\u4ece ORAUTF \u5bfc\u5165 ORAUS7 \u6570\u636e<\/li>\n<\/ol>\n\n\n\n<p>\u53ef\u4ee5\u6309\u5982\u4e0b\u65b9\u5f0f\u68c0\u67e5 ORAUS7 \u4e2d\u4fdd\u5b58\u7684\u97e9\u6587\u6570\u636e\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\">\u68c0\u67e5ORAUS7\u4e2d\u4fdd\u5b58\u7684\u97e9\u6587\u6570\u636e<\/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>Oracle SQL Developer \u7528\u4e8e\u4ee5\u4e0b\u6d4b\u8bd5\u3002<\/p>\n\n\n\n<p>SQL Developer\u662fOracle\u63d0\u4f9b\u7684\u4e00\u4e2a\u5de5\u5177\uff0c\u5e76\u4e14\u662f\u514d\u8d39\u7684\u3002\u60a8\u53ef\u4ee5\u4ece\u4e0b\u9762\u7684 URL \u4e0b\u8f7d\u5b83\u3002<\/p>\n\n\n\n<p><a href=\"https:\/\/www.oracle.com\/database\/sqldeveloper\/technologies\/download\/\" target=\"_blank\" rel=\"noreferrer noopener\">Oracle SQL \u5f00\u53d1\u4eba\u5458\u4e0b\u8f7d<\/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>\u6d4b\u8bd5#1) \u4eceORAMSWIN949\u83b7\u53d6ORAUS7\u6570\u636e<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>\u60a8\u53ef\u4ee5\u901a\u8fc7\u521b\u5efaDL_US7 DB Link\u5e76\u6307\u5b9aDB Link\u201cdl_us7\u201d\u6765\u68c0\u7d22\u6570\u636e\u3002\u811a\u672c\u5982\u4e0b\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>\u6267\u884c\u7ed3\u679c\u4e2d\u7684\u97e9\u6587\u6587\u672c\u65e0\u6cd5\u6b63\u5e38\u663e\u793a\uff0c\u800c\u662f\u663e\u793a\u4e3a\uff1f\uff08\u95ee\u53f7\uff09\u5b57\u7b26\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\">\u6d4b\u8bd5#1-1)\u4eceORAMSWIN949\u5bfc\u5165ORAUS7\u6570\u636e\u7684\u7ed3\u679c<\/figcaption><\/figure>\n<\/div>\n\n\n<p>\u901a\u8fc7 DB Link \u5bfc\u5165\u6570\u636e\u65f6\uff0c\u670d\u52a1\u5668\uff08\u672c\u4f8b\u4e2d\u4e3a ORAUS7\uff09\u5b57\u7b26\u96c6\u5c06\u8f6c\u6362\u4e3a\u5ba2\u6237\u7aef\uff08\u672c\u4f8b\u4e2d\u4e3a ORAUS7\uff09\u5b57\u7b26\u96c6\u3002<\/p>\n\n\n\n<p>\u7531\u4e8e\u4ee5US7ASCII\u5b58\u50a8\u7684\u97e9\u6587\u6587\u672c\u5b58\u50a8\u4e0d\u6b63\u786e\uff0c\u56e0\u6b64\u65e0\u6cd5\u8f6c\u6362\u4e3aMSWIN949\u5e76\u663e\u793a\u4e3a\u95ee\u53f7\u3002<\/p>\n\n\n\n<p>\u6b64\u65f6\u82e5\u8981\u6b63\u5e38\u663e\u793aORAUS7\u97e9\u6587\u6570\u636e\uff0c\u8bf7\u91c7\u7528\u4ee5\u4e0b\u65b9\u6cd5\u3002<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>\u4f7f\u7528 UTL_RAW.CAST_TO_RAW \u51fd\u6570\u5728 ORAUS7 \u4e2d\u521b\u5efa\u89c6\u56fe\uff0c\u4ee5\u9632\u6b62\u5305\u542b\u97e9\u6587\u5b57\u7b26\u7684 VARCHAR2 \u6570\u636e\u7c7b\u578b\u5217\u8fdb\u884c\u5b57\u7b26\u96c6\u8f6c\u6362\u3002\n<ul class=\"wp-block-list\">\n<li>\u5c06 UTL_RAW.CAST_TO_RAW \u51fd\u6570\u5e94\u7528\u4e8e\u5305\u542b\u97e9\u8bed\u5b57\u7b26\u7684\u5217\u3002<\/li>\n\n\n\n<li>RAW\u6570\u636e\u7c7b\u578b\u4e0d\u8f6c\u6362\u5b57\u7b26\u96c6\u3002<\/li>\n<\/ul>\n<\/li>\n\n\n\n<li>ORAMSWIN949 \u67e5\u8be2\u4e0a\u9762\u521b\u5efa\u7684\u89c6\u56fe\uff0c\u5c06 RAW \u6570\u636e\u7c7b\u578b\u8f6c\u6362\u56de VARCHAR2\uff0c\u5e76\u901a\u8fc7\u4f7f\u7528 CONVERT \u51fd\u6570\u6307\u5b9a\u6e90\u5b57\u7b26\u96c6\u548c\u76ee\u6807\u5b57\u7b26\u96c6\u5c06\u5176\u8f6c\u6362\u4e3a\u666e\u901a\u97e9\u8bed\u3002<\/li>\n<\/ul>\n\n\n\n<p>\u5728ORAUS7\u5b9e\u4f8b\u4e2d\uff0c\u4f7f\u7528\u4e0b\u9762\u7684\u811a\u672c\u521b\u5efa\u4e00\u4e2a\u5c06VARCHAR2\u6570\u636e\u7c7b\u578b\u8f6c\u6362\u4e3aRAW\u6570\u636e\u7c7b\u578b\u7684\u89c6\u56fe\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>\u6267\u884c\u7ed3\u679c\u4ee5\u97e9\u6587\u6b63\u5e38\u663e\u793a\u5982\u4e0b\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\">\u6d4b\u8bd5#1-2)\u901a\u8fc7ORAMSWIN949\u4e2d\u7684View\u6267\u884cORAUS7\u6570\u636e\u5bfc\u5165\u7684\u7ed3\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>\u6d4b\u8bd5 #2) \u4ece ORAUTF \u83b7\u53d6 ORAMSWIN949 \u6570\u636e<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>\u5728DB Link\u4e0a\uff0c\u5b57\u7b26\u96c6\u4eceMSWIN949\u6b63\u5e38\u8f6c\u6362\u4e3aUTF8\uff0c\u97e9\u6587\u5b57\u7b26\u5bfc\u5165\u826f\u597d\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>\u6267\u884c\u7ed3\u679c\u5982\u4e0b\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\">\u6d4b\u8bd5#2)\u4eceORAUTF\u5bfc\u5165ORAMSWIN949\u6570\u636e\u7684\u7ed3\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>\u6d4b\u8bd5 #3) \u4ece ORAUTF \u83b7\u53d6 ORAUS7 \u6570\u636e<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>\u5982\u201c\u6d4b\u8bd5 #1) \u4ece ORAMSWIN949 \u5bfc\u5165 ORAUS7 \u6570\u636e\u201d\u4e2d\uff0c\u97e9\u6587\u5b57\u7b26\u663e\u793a\u4e3a ?\uff08\u95ee\u53f7\uff09\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>\u6267\u884c\u7ed3\u679c\u5982\u4e0b\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\">\u6d4b\u8bd5#3-1)\u4eceORAUTF\u5bfc\u5165ORAUS7\u6570\u636e\u6267\u884c\u7ed3\u679c<\/figcaption><\/figure>\n<\/div>\n\n\n<p>\u8981\u6b63\u5e38\u663e\u793a\u97e9\u6587\uff0c\u8bf7\u4f7f\u7528\u201c\u6d4b\u8bd5#1\uff09\u4eceORAMSWIN949\u5bfc\u5165ORAUS7\u6570\u636e\u201d\u6b65\u9aa4\u4e2d\u521b\u5efa\u7684\u89c6\u56fe\uff0c\u5e76\u7a0d\u5fae\u66f4\u6539ORAUTF\u4e2d\u901a\u8fc7DB Link\u6267\u884c\u7684SQL\u7684CONVERT\u51fd\u6570\u53c2\u6570\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>\u7531\u4e8e CONVERT \u51fd\u6570\u7684\u7b2c\u4e8c\u4e2a\u53c2\u6570\u6307\u7684\u662f\u76ee\u6807\u5b57\u7b26\u96c6\uff0c\u56e0\u6b64\u6307\u5b9a\u4e86 AL32UTF8\u3002<\/p>\n\n\n\n<p>\u6267\u884c\u7ed3\u679c\u5982\u4e0b\uff1a<\/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\">\u6d4b\u8bd5#3-2)\u901a\u8fc7View\u4eceORAUTF\u5bfc\u5165ORAUS7\u6570\u636e\u6267\u884c\u7ed3\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>\u53c2\u8003<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>\u63a2\u7d22 RAW \u6570\u636e\u7c7b\u578b<span class=\"ez-toc-section-end\"><\/span><\/h4>\n\n\n\n<p>\u4e0b\u9762\u6458\u5f55\u4e86Oracle\u6587\u6863\u4e2d\u6709\u5173RAW\u6570\u636e\u7c7b\u578b\u7684\u4e00\u4e9b\u5185\u5bb9\u3002<\/p>\n\n\n\n<p>\u8d44\u6e90\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 \u548c LONG RAW \u6570\u636e\u7c7b\u578b<\/p>\n\n\n\n<p>\u5728\u4e0d\u540c\u7cfb\u7edf\u4e4b\u95f4\u79fb\u52a8\u6570\u636e\u65f6\uff0cRAW \u548c LONG RAW \u6570\u636e\u7c7b\u578b\u5b58\u50a8 Oracle \u6570\u636e\u5e93\u4e0d\u4f1a\u663e\u5f0f\u8f6c\u6362\u7684\u6570\u636e\u3002&nbsp;<span style=\"background-color: #f6e199;\">\u8fd9\u4e9b\u6570\u636e\u7c7b\u578b\u9002\u7528\u4e8e\u4e8c\u8fdb\u5236\u6570\u636e\u6216\u5b57\u8282\u5b57\u7b26\u4e32\u3002<\/span> \u4f8b\u5982\uff0c\u60a8\u53ef\u4ee5\u4f7f\u7528 LONG RAW \u6765\u5b58\u50a8\u56fe\u5f62\u3001\u58f0\u97f3\u3001\u6587\u6863\u6216\u4e8c\u8fdb\u5236\u6570\u636e\u6570\u7ec4\uff0c\u5176\u89e3\u91ca\u53d6\u51b3\u4e8e\u7528\u9014\u3002<\/p>\n\n\n\n<p>\u2026<\/p>\n\n\n\n<p>RAW \u662f\u4e00\u79cd\u7c7b\u4f3c\u4e8e VARCHAR2 \u7684\u53ef\u53d8\u957f\u5ea6\u6570\u636e\u7c7b\u578b\uff0c\u4e0d\u540c\u4e4b\u5904\u5728\u4e8e Oracle Net\uff08\u5c06\u5ba2\u6237\u7aef\u8f6f\u4ef6\u8fde\u63a5\u5230\u6570\u636e\u5e93\u6216\u4e00\u4e2a\u6570\u636e\u5e93\u8fde\u63a5\u5230\u53e6\u4e00\u4e2a\u6570\u636e\u5e93\uff09\u4ee5\u53ca Oracle \u5bfc\u5165\u548c\u5bfc\u51fa\u5b9e\u7528\u7a0b\u5e8f&nbsp;<span style=\"background-color: #f6e199;\">\u4f20\u8f93 RAW \u6216 LONG RAW \u6570\u636e\u65f6\u4e0d\u6267\u884c\u5b57\u7b26\u8f6c\u6362<\/span> \u76f8\u6bd4\u4e4b\u4e0b\uff0c\u5982\u679c\u6570\u636e\u5728\u6570\u636e\u5e93\u4e4b\u95f4\u4f20\u8f93\uff0cOracle Net \u548c Oracle \u5bfc\u5165\u548c\u5bfc\u51fa\u5b9e\u7528\u7a0b\u5e8f\u4f1a\u81ea\u52a8\u5728\u4e0d\u540c\u6570\u636e\u5e93\u5b57\u7b26\u96c6\u4e4b\u95f4\u8f6c\u6362 CHAR\u3001VARCHAR2 \u548c LONG \u6570\u636e\uff0c\u6216\u8005\u5728\u6570\u636e\u5e93\u5b57\u7b26\u96c6\u548c\u5ba2\u6237\u7aef\u5b57\u7b26\u96c6\u4e4b\u95f4\u4f20\u8f93\u6570\u636e\uff08\u5982\u679c\u4f20\u8f93\u6570\u636e\uff09\u6570\u636e\u5e93\u548c\u5ba2\u6237\u7aef\u4e4b\u95f4\u3002\u5ba2\u6237\u7aef\u5b57\u7b26\u96c6\u7531\u5ba2\u6237\u7aef\u63a5\u53e3\u7684\u7c7b\u578b\uff08\u4f8b\u5982 OCI \u6216 JDBC\uff09\u548c\u5ba2\u6237\u7aef\u914d\u7f6e\uff08\u4f8b\u5982 NLS_LANG \u73af\u5883\u53d8\u91cf\uff09\u51b3\u5b9a\u3002<\/p>\n<\/blockquote>\n\n\n\n<p>\u4e0a\u9762\u989c\u8272\u98a0\u5012\u7684\u53e5\u5b50\u7684\u542b\u4e49\u5982\u4e0b\u3002<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>\u8fd9\u4e9b\u6570\u636e\u7c7b\u578b\u9002\u7528\u4e8e\u4e8c\u8fdb\u5236\u6570\u636e\u6216\u5b57\u8282\u5b57\u7b26\u4e32<br>\u2013&gt; RAW\u6570\u636e\u7c7b\u578b\u7528\u4e8e\u5b58\u50a8\u4e8c\u8fdb\u5236\u6570\u636e\u3002<\/li>\n\n\n\n<li>\u4f20\u8f93 RAW \u6216 LONG RAW \u6570\u636e\u65f6\u4e0d\u6267\u884c\u5b57\u7b26\u8f6c\u6362<br>\u2013&gt; \u901a\u8fc7DB Link\uff08Oracle Net\uff09\u4f20\u8f93RAW\u6570\u636e\u7c7b\u578b\u65f6\uff0c\u5b57\u7b26\u96c6\u4e0d\u8fdb\u884c\u8f6c\u6362\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>\u5b57\u7b26\u96c6\u8f6c\u6362\u51fd\u6570 CONVERT<span class=\"ez-toc-section-end\"><\/span><\/h4>\n\n\n\n<p>\u4ee5\u4e0b\u662f Oracle \u6587\u6863\u4e2d\u6709\u5173 CONVERT \u51fd\u6570\u7684\u6458\u5f55\u3002<\/p>\n\n\n\n<p>\u8d44\u6e90\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\">\u5b57\u7b26\u96c6\u8f6c\u6362\u51fd\u6570 CONVERT \u8bed\u6cd5<\/figcaption><\/figure>\n<\/div>\n\n\n<blockquote class=\"wp-block-quote is-layout-flow wp-block-quote-is-layout-flow\">\n<p>CONVERT \u5c06\u5b57\u7b26\u4e32\u4ece\u4e00\u79cd\u5b57\u7b26\u96c6\u8f6c\u6362\u4e3a\u53e6\u4e00\u79cd\u5b57\u7b26\u96c6\u3002<\/p>\n\n\n\n<p>&nbsp; \u2013 char \u53c2\u6570\u662f\u8981\u8f6c\u6362\u7684\u503c\u3002\u5b83\u53ef\u4ee5\u662f\u4efb\u4f55\u6570\u636e\u7c7b\u578b CHAR\u3001VARCHAR2\u3001NCHAR\u3001NVARCHAR2\u3001CLOB \u6216 NCLOB\u3002<\/p>\n\n\n\n<p>&nbsp; \u2013 dest_char_set \u53c2\u6570\u662f char \u8f6c\u6362\u5230\u7684\u5b57\u7b26\u96c6\u7684\u540d\u79f0\u3002<\/p>\n\n\n\n<p>&nbsp; \u2013 source_char_set \u53c2\u6570\u662f\u6570\u636e\u5e93\u4e2d\u5b58\u50a8 char \u7684\u5b57\u7b26\u96c6\u7684\u540d\u79f0\u3002\u9ed8\u8ba4\u503c\u662f\u6570\u636e\u5e93\u5b57\u7b26\u96c6\u3002<\/p>\n\n\n\n<p>CHAR \u548c VARCHAR2 \u7684\u8fd4\u56de\u503c\u4e3a VARCHAR2\u3002\u5bf9\u4e8e NCHAR \u548c NVARCHAR2\uff0c\u5b83\u662f NVARCHAR2\u3002\u5bf9\u4e8e CLOB\uff0c\u5b83\u662f CLOB\uff0c\u5bf9\u4e8e NCLOB\uff0c\u5b83\u662f NCLOB\u3002<\/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>\u9884\u9632\u63aa\u65bd<span class=\"ez-toc-section-end\"><\/span><\/h4>\n\n\n\n<p>RAW\u6570\u636e\u7c7b\u578b\u6700\u591a\u53ef\u4f7f\u75282000\u5b57\u8282\u3002 Oracle 12c R2\u4e4b\u540e\u53ef\u4ee5\u6269\u5c55\uff0c\u4f46\u4e00\u822c\u6700\u591a2000\u5b57\u8282\u3002\u5728US7ASCII\u4e2d\uff0c\u97e9\u6587\u5b58\u50a8\u4e3a2\u4e2a\u5b57\u8282\uff0c\u56e0\u6b64\u8be5\u65b9\u6cd5\u53ea\u80fd\u5e94\u7528\u4e8e\u6700\u591a1000\u4e2a\u97e9\u6587\u5b57\u7b26\u3002<\/p>\n\n\n\n<p>\uff08\u5982\u679c\u5305\u542b\u82f1\u6587\u5b57\u6bcd\u548c\u6570\u5b57\uff0c\u53ef\u8f6c\u6362\u7684\u5b57\u7b26\u6570\u53ef\u80fd\u4f1a\u589e\u52a0\u3002\uff09<\/p>\n\n\n\n<p>\u8981\u8f6c\u6362\u8d85\u8fc7 2000 \u5b57\u8282\u7684\u6570\u636e\uff0c\u4f3c\u4e4e\u53ef\u4ee5\u5728 View \u4e2d\u5c06\u5176\u5206\u6210\u4e24\u5217\u6216\u66f4\u591a\u5217\uff0c\u7136\u540e\u5728\u8bfb\u53d6 View \u7684\u5b9e\u4f8b\uff08\u4f8b\u5982 ORAUTF\uff09\u4e2d\u8fdb\u884c\u8f6c\u6362\u548c\u7ec4\u5408\uff0c\u4f46\u8fd9\u5c1a\u672a\u7ecf\u8fc7\u6d4b\u8bd5\u3002<\/p>\n\n\n\n<p>\u5fc5\u987b\u6ce8\u610f\u53ef\u4ee5\u8f6c\u6362\u7684\u6700\u5927\u5b57\u8282\u6570\u3002<\/p>","protected":false},"excerpt":{"rendered":"<p>\u63a5\u4e0a\u4e00\u7bc7\uff08Oracle\u5b57\u7b26\u96c6\u8f6c\u6362\uff08\u516b\uff09\uff1a6.\u5982\u4f55\u8f6c\u6362\u7528\u6237\u81ea\u5b9a\u4e49\u5b57\u7b26\u96c6\uff08\u4e00\uff09\uff09\uff0c\u6211\u4eec\u6765\u770b\u4e00\u4e0b\u5982\u4f55\u8f6c\u6362\u7528\u6237\u81ea\u5b9a\u4e49\u5b57\u7b26\u96c6\u3002\u60a8\u53ef\u4ee5\u68c0\u67e5\u5982\u4f55\u4f7f\u7528 DB Link\u3001CTAS \u548c UTL_RAW \u5305\u4ece KO16MSWIN949\u3001US7ASCII \u8f6c\u6362\u4e3a AL32UTF8\u3002 6.2.3.\u65b9\u6cd5 3) \u6570\u636e\u5e93\u94fe\u63a5 &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.3 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Oracle Character Set \ubcc0\ud658(9): 6. \uc0ac\uc6a9\uc790 \uad6c\ud604 Character Set \ubcc0\ud658 \ubc29\ubc95 (2) - \uc0dd\uc0b0\uc131 Skill<\/title>\n<meta name=\"description\" content=\"\uc0ac\uc6a9\uc790 \uad6c\ud604 Character Set \ubcc0\ud658 \ubc29\ubc95 \uc5d0 \ub300\ud574 \uc0b4\ud3b4\ubcf8\ub2e4. DB Link, CTAS, UTL_RAW package\ub97c \ud65c\uc6a9\ud558\uc5ec KO16MSWIN949, US7ASCII\uc5d0\uc11c AL32UTF8\ub85c \ubcc0\ud658\ud558\ub294 \ubc29\ubc95\uc744 \ud655\uc778\ud560 \uc218 \uc788\ub2e4.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/prodskill.com\/zh\/oracle-character-set-migration-9-dblink-ctas-utl_raw\/\" \/>\n<meta property=\"og:locale\" content=\"zh_CN\" \/>\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\/zh\/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=\"\u4f5c\u8005\" \/>\n\t<meta name=\"twitter:data1\" content=\"Zerom\" \/>\n\t<meta name=\"twitter:label2\" content=\"\u9884\u8ba1\u9605\u8bfb\u65f6\u95f4\" \/>\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\":[\"ORACLE\",\"Character Set \ubcc0\ud658\",\"Character Set Conversion\",\"US7ASCII\",\"KO16MSWIN949\",\"AL32UTF8\",\"DB Link\",\"CTAS\",\"UTL_RAW\"],\"articleSection\":[\"ORACLE\"],\"inLanguage\":\"zh-Hans\",\"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\":\"zh-Hans\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/prodskill.com\\\/oracle-character-set-migration-9-dblink-ctas-utl_raw\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"zh-Hans\",\"@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\":\"zh-Hans\"},{\"@type\":[\"Person\",\"Organization\"],\"@id\":\"https:\\\/\\\/prodskill.com\\\/ko\\\/#\\\/schema\\\/person\\\/bbad0870c78008c82edbe0960fe768bd\",\"name\":\"Zerom\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"zh-Hans\",\"@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\\\/zh\\\/author\\\/proda\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Oracle\u5b57\u7b26\u96c6\u8f6c\u6362\uff089\uff09\uff1a6.\u7528\u6237\u5b9e\u73b0\u7684\u5b57\u7b26\u96c6\u8f6c\u6362\u65b9\u6cd5\uff082\uff09 - \u751f\u4ea7\u529b\u6280\u5de7","description":"\u8ba9\u6211\u4eec\u770b\u770b\u5982\u4f55\u8f6c\u6362\u7528\u6237\u81ea\u5b9a\u4e49\u7684\u5b57\u7b26\u96c6\u3002\u60a8\u53ef\u4ee5\u4e86\u89e3\u5982\u4f55\u4f7f\u7528 DB Link\u3001CTAS \u548c UTL_RAW \u5305\u5c06 KO16MSWIN949\u3001US7ASCII \u8f6c\u6362\u4e3a AL32UTF8\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\/zh\/oracle-character-set-migration-9-dblink-ctas-utl_raw\/","og_locale":"zh_CN","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\/zh\/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":{"\u4f5c\u8005":"Zerom","\u9884\u8ba1\u9605\u8bfb\u65f6\u95f4":"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":["ORACLE","Character Set \ubcc0\ud658","Character Set Conversion","US7ASCII","KO16MSWIN949","AL32UTF8","DB Link","CTAS","UTL_RAW"],"articleSection":["ORACLE"],"inLanguage":"zh-Hans","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\u5b57\u7b26\u96c6\u8f6c\u6362\uff089\uff09\uff1a6.\u7528\u6237\u5b9e\u73b0\u7684\u5b57\u7b26\u96c6\u8f6c\u6362\u65b9\u6cd5\uff082\uff09 - \u751f\u4ea7\u529b\u6280\u5de7","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":"\u8ba9\u6211\u4eec\u770b\u770b\u5982\u4f55\u8f6c\u6362\u7528\u6237\u81ea\u5b9a\u4e49\u7684\u5b57\u7b26\u96c6\u3002\u60a8\u53ef\u4ee5\u4e86\u89e3\u5982\u4f55\u4f7f\u7528 DB Link\u3001CTAS \u548c UTL_RAW \u5305\u5c06 KO16MSWIN949\u3001US7ASCII \u8f6c\u6362\u4e3a AL32UTF8\u3002","breadcrumb":{"@id":"https:\/\/prodskill.com\/oracle-character-set-migration-9-dblink-ctas-utl_raw\/#breadcrumb"},"inLanguage":"zh-Hans","potentialAction":[{"@type":"ReadAction","target":["https:\/\/prodskill.com\/oracle-character-set-migration-9-dblink-ctas-utl_raw\/"]}]},{"@type":"ImageObject","inLanguage":"zh-Hans","@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\u4ea7\u529b\u6280\u80fd","description":"\u5143\u601d\u7ef4\uff0c\u5143\u5de5\u4f5c","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":"zh-Hans"},{"@type":["Person","Organization"],"@id":"https:\/\/prodskill.com\/ko\/#\/schema\/person\/bbad0870c78008c82edbe0960fe768bd","name":"\u6cfd\u7f57\u59c6","image":{"@type":"ImageObject","inLanguage":"zh-Hans","@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\/zh\/author\/proda\/"}]}},"_links":{"self":[{"href":"https:\/\/prodskill.com\/zh\/wp-json\/wp\/v2\/posts\/11964","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/prodskill.com\/zh\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/prodskill.com\/zh\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/prodskill.com\/zh\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/prodskill.com\/zh\/wp-json\/wp\/v2\/comments?post=11964"}],"version-history":[{"count":1,"href":"https:\/\/prodskill.com\/zh\/wp-json\/wp\/v2\/posts\/11964\/revisions"}],"predecessor-version":[{"id":12418,"href":"https:\/\/prodskill.com\/zh\/wp-json\/wp\/v2\/posts\/11964\/revisions\/12418"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/prodskill.com\/zh\/wp-json\/wp\/v2\/media\/11972"}],"wp:attachment":[{"href":"https:\/\/prodskill.com\/zh\/wp-json\/wp\/v2\/media?parent=11964"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/prodskill.com\/zh\/wp-json\/wp\/v2\/categories?post=11964"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/prodskill.com\/zh\/wp-json\/wp\/v2\/tags?post=11964"}],"curies":[{"name":"\u53ef\u6e7f\u6027\u7c89\u5242","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}