问题描述
大家好,
我在插入Oracle表时遇到处理希腊字符的问题。
控制文件:
负载数据
CHARACTERSET UTF8
APPEND
INTO TABLE Repository_Owner.PFORCE_TEMP_EMP
WHEN COUNTRY_CD ='GR'
字段终止于|
追踪NULLCOLS
(
COUNTRY_CD CHAR NULLIF(COUNTRY_CD = BLANKS),
SOURCE FILLER,
SRC_SYS_ID CHAR NULLIF(SRC_SYS_ID = BLANKS),
LOGIN_ID CHAR NULLIF(LOGIN_ID = BLANKS),
FRST_NM CHAR NULLIF(FRST_NM = BLANKS),
LAST_NM CHAR NULLIF(LAST_NM = BLANKS),
EMAIL CHAR NULLIF(EMAIL = BLANKS),
LAST_UPD_TS日期YYYY-MM-DD HH24:MI:SS NULLIF(LAST_UPD_TS = BLANKS),
ACTIVE CHARDECODE(:ACTIVE,'TRUE','Y','FALSE','F',NULL)
)
当通过sql loader向导插入平面文件数据时,我看到了????而不是table中的数据。请给出一个处理希腊字符的解决方案。
TIA;)
Hi all,
I'm facing a problem handling Greek characters while inserting into a Oracle table.
control file :
LOAD DATA
CHARACTERSET UTF8
APPEND
INTO TABLE Repository_Owner.PFORCE_TEMP_EMP
WHEN COUNTRY_CD='GR'
FIELDS TERMINATED BY "|"
TRAILING NULLCOLS
(
COUNTRY_CD CHAR NULLIF(COUNTRY_CD = BLANKS),
SOURCE FILLER,
SRC_SYS_ID CHAR NULLIF(SRC_SYS_ID = BLANKS),
LOGIN_ID CHAR NULLIF(LOGIN_ID = BLANKS),
FRST_NM CHAR NULLIF(FRST_NM = BLANKS),
LAST_NM CHAR NULLIF(LAST_NM = BLANKS),
EMAIL CHAR NULLIF(EMAIL = BLANKS),
LAST_UPD_TS DATE "YYYY-MM-DD HH24:MI:SS" NULLIF(LAST_UPD_TS = BLANKS),
ACTIVE CHAR "DECODE(:ACTIVE,'TRUE','Y','FALSE','F',NULL)"
)
When inserting flat file data through sql loader wizard , I'm seeing ???? instead of data in table.Please give a solution to handle Greek characters.
TIA ;)
推荐答案
这篇关于如何通过Oracle sql loader向导处理希腊字符的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持!