You are viewing a plain text version of this content. The canonical link for it is here.
Posted to notifications@shardingsphere.apache.org by GitBox <gi...@apache.org> on 2021/06/30 08:29:33 UTC
[GitHub] [shardingsphere] nanzheng opened a new issue #11074: Oracle Insert statement Parse SQL ERROR!Please Help!
nanzheng opened a new issue #11074:
URL: https://github.com/apache/shardingsphere/issues/11074
### My Eventment is
shardingsphere 5.0.0-beta (spring-boot-start)
mybaits
Oracle 19c
Java 1.8
### How it happened
I use the spring-boot-start to encrypt the mysql/oracle table. And I find insert into the mysql work fine, but switch to Oracle get the parse SQL Error issue. I dont know how does it happen. Please help . This issue maybe still exist in the master branch.
### Execption is blow
```
Exception in thread "Thread-28" com.nagisazz.booteasy.base.exception.ServiceException: ä¿åä¿¡æ¯å¤±è´¥
at com.nagisazz.booteasy.service.OracleService.insert(OracleService.java:47)
at com.nagisazz.booteasy.controller.UserController$2.run(UserController.java:188)
at java.lang.Thread.run(Thread.java:748)
Caused by: org.mybatis.spring.MyBatisSystemException: nested exception is org.apache.ibatis.executor.ExecutorException: Error preparing statement. Cause: com.google.common.util.concurrent.UncheckedExecutionException: org.apache.shardingsphere.sql.parser.exception.SQLParsingException: You have an error in your SQL syntax
at org.mybatis.spring.MyBatisExceptionTranslator.translateExceptionIfPossible(MyBatisExceptionTranslator.java:77)
at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:446)
at com.sun.proxy.$Proxy177.insert(Unknown Source)
at org.mybatis.spring.SqlSessionTemplate.insert(SqlSessionTemplate.java:278)
at org.springframework.data.mybatis.repository.support.SqlSessionRepositorySupport.insert(SqlSessionRepositorySupport.java:101)
at org.springframework.data.mybatis.repository.support.SimpleMybatisRepository.insert(SimpleMybatisRepository.java:75)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:498)
at org.springframework.data.repository.core.support.RepositoryFactorySupport$QueryExecutorMethodInterceptor.executeMethodOn(RepositoryFactorySupport.java:504)
at org.springframework.data.repository.core.support.RepositoryFactorySupport$QueryExecutorMethodInterceptor.doInvoke(RepositoryFactorySupport.java:489)
at org.springframework.data.repository.core.support.RepositoryFactorySupport$QueryExecutorMethodInterceptor.invoke(RepositoryFactorySupport.java:461)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
at org.springframework.data.projection.DefaultMethodInvokingMethodInterceptor.invoke(DefaultMethodInvokingMethodInterceptor.java:61)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
at org.springframework.transaction.interceptor.TransactionInterceptor$1.proceedWithInvocation(TransactionInterceptor.java:99)
at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:282)
at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:96)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
at org.springframework.dao.support.PersistenceExceptionTranslationInterceptor.invoke(PersistenceExceptionTranslationInterceptor.java:136)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
at org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:92)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
at org.springframework.data.repository.core.support.SurroundingTransactionDetectorMethodInterceptor.invoke(SurroundingTransactionDetectorMethodInterceptor.java:57)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:213)
at com.sun.proxy.$Proxy190.insert(Unknown Source)
at com.nagisazz.booteasy.service.OracleService.insert(OracleService.java:45)
... 2 more
Caused by: org.apache.ibatis.executor.ExecutorException: Error preparing statement. Cause: com.google.common.util.concurrent.UncheckedExecutionException: org.apache.shardingsphere.sql.parser.exception.SQLParsingException: You have an error in your SQL syntax
at org.apache.ibatis.executor.statement.BaseStatementHandler.prepare(BaseStatementHandler.java:97)
at org.apache.ibatis.executor.statement.RoutingStatementHandler.prepare(RoutingStatementHandler.java:59)
at org.apache.ibatis.executor.SimpleExecutor.prepareStatement(SimpleExecutor.java:85)
at org.apache.ibatis.executor.SimpleExecutor.doUpdate(SimpleExecutor.java:49)
at org.apache.ibatis.executor.BaseExecutor.update(BaseExecutor.java:117)
at org.apache.ibatis.executor.CachingExecutor.update(CachingExecutor.java:76)
at org.apache.ibatis.session.defaults.DefaultSqlSession.update(DefaultSqlSession.java:198)
at org.apache.ibatis.session.defaults.DefaultSqlSession.insert(DefaultSqlSession.java:185)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:498)
at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:433)
... 29 more
Caused by: com.google.common.util.concurrent.UncheckedExecutionException: org.apache.shardingsphere.sql.parser.exception.SQLParsingException: You have an error in your SQL syntax
at com.google.common.cache.LocalCache$Segment.get(LocalCache.java:2214)
at com.google.common.cache.LocalCache.get(LocalCache.java:4053)
at com.google.common.cache.LocalCache.getOrLoad(LocalCache.java:4057)
at com.google.common.cache.LocalCache$LocalLoadingCache.get(LocalCache.java:4986)
at com.google.common.cache.LocalCache$LocalLoadingCache.getUnchecked(LocalCache.java:4992)
at org.apache.shardingsphere.infra.parser.sql.SQLStatementParserEngine.parse(SQLStatementParserEngine.java:48)
at org.apache.shardingsphere.infra.parser.ShardingSphereSQLParserEngine.parse0(ShardingSphereSQLParserEngine.java:67)
at org.apache.shardingsphere.infra.parser.ShardingSphereSQLParserEngine.parse(ShardingSphereSQLParserEngine.java:56)
at org.apache.shardingsphere.driver.jdbc.core.statement.ShardingSpherePreparedStatement.<init>(ShardingSpherePreparedStatement.java:161)
at org.apache.shardingsphere.driver.jdbc.core.statement.ShardingSpherePreparedStatement.<init>(ShardingSpherePreparedStatement.java:133)
at org.apache.shardingsphere.driver.jdbc.core.connection.ShardingSphereConnection.prepareStatement(ShardingSphereConnection.java:183)
at org.apache.ibatis.executor.statement.PreparedStatementHandler.instantiateStatement(PreparedStatementHandler.java:87)
at org.apache.ibatis.executor.statement.BaseStatementHandler.prepare(BaseStatementHandler.java:88)
... 41 more
Caused by: org.apache.shardingsphere.sql.parser.exception.SQLParsingException: You have an error in your SQL syntax
at org.apache.shardingsphere.sql.parser.core.parser.SQLParserExecutor.twoPhaseParse(SQLParserExecutor.java:63)
at org.apache.shardingsphere.sql.parser.core.parser.SQLParserExecutor.parse(SQLParserExecutor.java:45)
at org.apache.shardingsphere.sql.parser.api.SQLParserEngine.parse(SQLParserEngine.java:51)
at org.apache.shardingsphere.infra.parser.sql.SQLStatementParserExecutor.parse(SQLStatementParserExecutor.java:47)
at org.apache.shardingsphere.infra.parser.cache.SQLStatementCacheLoader.load(SQLStatementCacheLoader.java:40)
at org.apache.shardingsphere.infra.parser.cache.SQLStatementCacheLoader.load(SQLStatementCacheLoader.java:29)
at com.google.common.cache.LocalCache$LoadingValueReference.loadFuture(LocalCache.java:3628)
at com.google.common.cache.LocalCache$Segment.loadSync(LocalCache.java:2336)
at com.google.common.cache.LocalCache$Segment.lockedGetOrLoad(LocalCache.java:2295)
at com.google.common.cache.LocalCache$Segment.get(LocalCache.java:2208)
... 53 more
```
### insert SQL is
```
insert into ARCHIVE_INFOR_NZ11(INFOR_ID,ADM_DIVI_DOMICILE,ADM_DIVI_CUR_RES,ADM_DIVI_ENDOW_INSU_PLACE,ADM_DIVI_MED_INSU_PLACE,ARE_VIL_CAD_RET_SOLD,ADM_DIVI_PLACE_ENL,ADM_DIV_UNIT_ADDR,ADM_DIV_ENTER_REG_ADDR,ANN_OPE_INCOME,AMO_FINA_AID,ABILITY_LIVE,ASS_DISA_TIME,ADM_DIVI_SLAVA,ARE_PAT_NAT_DEF_EDU,ARE_WIL_APPLY_MIL_CEM,ASSI_RESU,ANN_INCOME_RET_VIL_CAD,ADV_SPE_RET_VIL_CAD,ANN_INCOME_VIL_COLL_ECON,AREA_RET_VIL_CAD_COM,ADM_DIVI_MED_COM_RET_VIL_CAD,ANN_JOB_SAT_EVA,BIRTH_DATE,BUR_MARTYRS,CON_SER_HEAD_VET_SER_STA,CAT_OFFI_CAD,CIV_CAD_TYPE,CERTI_QUALI,CERTI_TYPE,CAT_PRE_OBJECT,COM_RET_VIL_CAD_DUR_TEN,COM_POPU_RET_VIL_CAD,CHARAC_INDUSTRY,COMMENDATION,DATA_FROM,DOCU_TYPE,DOCU_NUM,DETAIL_ADDR_DOMICILE,DETAIL_ADDR_CURRES,DEGREE_INFOR,DEGREE_INFOR_BEFORE_RET,DEGREE_INFOR_ACQ_TIME_BEFORE_RET,DIR_EMPLOY_VOC_SKI_TRAIN,DISA_CATE,DISA_GRADE,DISA_CER_NUM,DOM_MAR_CEM,DETAIL_ADDR_SLAVA,DIFF_TYPE,DIFF_STATU_EXP,DEP_TIME_VIL_CAD_RET_SER,DES_OTH_ADV_SPE_RET_VIL_CAD,DES_OTH_CHARAC_INDUSTRY,EDU_BACK,ENDOW_IN
SU_ATT_STATU,ENDOW_INSU_DURA,ENDOW_INSU_INTERRUPTED,EMPLOYMENT,EMPLOY_PER_ANN_INCOME,EMPLOY_FAM_ANN_INCOME,EMPLOY_NEW_BUSI,ENGA_INDUSTRY,ENTERPRISE_NAME,ENTER_REG_DETAIL_ADDR,ENTER_REG_TIME,ENJOY_SUPPORT_POL,EDU_BACK_BEFORE_RET,EDU_BACK_ACQ_TIME_BEFORE_RET,ENJOY_PRE_TREAT,ENJOY_POL_GUA,FILING_IN_ANOTHER_PLACE,GENDER,GO_TO_COUNTRY_ENTRE,HEAL_STATU,HOUSE_REGIS_CATE,HOUS_STATU,HAVE_PARTI_ORGAN,HOUSE_REG_ENL,HOLD_SITUA,HAVE_REC_SYM,HONOR_INCENTIVE,INFOR_STATUS,INFOR_SYN_STATUS,INFOR_TIME,INFOR_USER_ID,INFOR_ORGAN_ID,INFOR_AUDIT_TIME,INFOR_AUDIT_USER_ID,INFOR_ATR_ORAGN_ID,INFOR_GRADE_ID,INFOR_GRADE_SYSCALC_ID,INITIAL_FILING_TIME,IS_VETERAN,ID_CARD_NUM,ID_ISS_PLAC,ID_CERT_VALI_BEGI_DATE,ID_CERT_VALI_END_DATE,INTER_PERI_ENDOW_INSU,INTER_PERI_MED_INSU,IS_OUT_ORGAN,IS_VOL_SER,IS_NEW_EMPLOY,INDU_ENTERPRISE,INDU_PUB_WEL_POST,INDU_LIB_PRO,IS_EMPLOY_INTEN,IS_POST_SER_ACA_EDU,IS_STUDENT_AID,IS_SEP_PLAN,IS_VOC_SKILL_TRAIN,ILLNE_DEA_SOLD_RELA,ILLNE_DEA_SOLD_FAM_WHE_PERMIT,ILLNE_DEA_SOLD_CERTI_NUM,I
LLNE_DEA_SOLD_NAME,ILLNE_DEA_SOLD_GENDER,ILLNE_DEA_SOLD_BIRTH_DATE,ILLNE_DEA_SOLD_TIME_ENL,ILLNE_DEA_SOLD_WORK_PLAC_DEATH,ILLNE_DEA_SOLD_TIME_DEATH,ILLNE_DEA_SOLD_REASON,ILLNE_DEA_SOLD_ASS_TIME,IS_PRAISE_ENCOURAGE,INCLU_LOCAL_CHRO,IS_PRA_PUB,IS_EXP_VIL_CAD,INFOR_ALL_SHOULE_ITEM,INFOR_ALL_COMPLETE_ITEM,INFOR_MUST_SHOULE_ITEM,INFOR_MUST_COMPLETE_ITEM,INFOR_KEY_SHOULE_ITEM,INFOR_KEY_COMPLETE_ITEM,JOBLESS_FAMILY,LEN_SER_SPE_AREAS,LEGAL_REPRE,LEGAL_REPRE_TELE_NUM,LIB_PRO_NAME,LIB_PRO_TIME,LABOR_CAPACITY,MAR_STATU,MED_INSU_ATT_STATU,MED_INSU_DURA,MED_INSU_INTERRUPTED,MIL_OFFI_ORI_HIG_RANK,MAN_CIV_CAD_ORI_HIG_RANK,MONTHLY_RETIRE_PAYMENT,MIL_REST_CATE,MIL_REST_RESET_TIME,MIL_REST_ADM_DIVI_RESET_PLACE,MIL_REST_DETAIL_ADDR_RESET_PLACE,MIL_REST_RESET_MANA_UNIT_NAME,MIL_REST_RESET_MANA_UNIT_NATURE,MIL_REST_SER_MANA_ORGAN_NAME,MART_RELA,MART_FAM_WHE_PERMIT,MART_CERTI_NUM,MART_NAME,MART_GENDER,MART_BIRTH_DATE,MART_TIME_ENL,MART_WORK_PLAC_DEATH,MART_SACR_TIME,MARTYR_SACRIFIC_REASON,MART_ASS_TIME,M
ART_ASS_UNIT,MAR_CEM_DET_ADDR,NAME,NATIONALITY,NUM_ORGAN_ACT_IN_ONE_YEAR,NON_MI_STAFF_WORK_TIME,NON_MI_STAFF_RET_TIME,NON_MI_STAFF_ORI_UNIT,NON_MI_STAFF_ORI_RANK,NON_MI_STAFF_RET_CER_NUM,NON_MI_STAFF_ADM_DIVI,NON_MI_STAFF_DETAIL_ADDR,NON_MI_STAFF_RES_PLAN_BAT,NON_MI_STAFF_RET_REC_TIME,NON_MI_STAFF_MAN_UNIT_NAT,NUM_EMPLOY,NUM_VETERANS,NAME_VOC_SKI_CERTI,NUM_MEM_TWO_COM,OFFI_TYPE,ONE_TIME_RETIRE_PAYMENT,ON_DUT_SACRIF_SOLD_RELA,ON_DUT_SACRIF_SOLD_FAM_WHE_PERIMIT,ON_DUT_SACRIF_SOLD_CERTI_NUM,ON_DUT_SACRIF_SOLD_NAME,ON_DUT_SACRIF_SOLD_GENDER,ON_DUT_SACRIF_SOLD_BIRTH_DATE,ON_DUT_SACRIF_SOLD_TIME_ENL,ON_DUT_SACRIF_SOLD_PLAC_DEATH,ON_DUT_SACRIF_SOLD_TIME_DEATH,ON_DUT_SACRIF_SOLD_REASON,ON_DUT_SACRIF_SOLD_ASS_TIME,OTH_HON_INCENTIVES,OTH_NOTES_COMMEN,POLI_AFFI,PAY_HOUS_FUND,PUNISHMENT_TYPE,PUNISHMENT,PARTY_BRANCH,POST_VIL_CAD_RET_SOLD,PER_CATE_ONE_LEV,PER_CATE_TWO_LEV,POSITION_TYPE,POST,PUB_WEL_POST_NAME,PUB_WEL_POST_TIME,PRE_SER_EDU,PRE_SER_EDU_BACK,PART_TRAIN,PSY_OR_NOT,PRE_RET_UNIT,PRE_RET
_UNIT_ADDR,PRE_RET_UNIT_DETAIL_ADDR,RANK,RES_DUTY,RET_CER_TYPE,RET_CERT_NUM,RESET_TYPE,RETIR_RESET_TIME,RETIR_ADM_DIVI_RESET_PLACE,RETIR_DETAIL_ADDR_RESET_PLACE,RETIR_RESET_UNIT_NAME,RETIR_RESET_UNIT_NATURE,RETIR_RESET_POS_RAN,REDUCE_CAUSE,REDUCE_EXPLAIN,REDUCE_TIME,REDUCE_USER_ID,REDUCE_ORGAN_ID,REDUCE_DEATH_TIME,RET_VIL_CAD_CON_SER_TOWN_LEAD,REC_ONE_TIME_RET_GRANT,RET_PAY_COL_TIME,RET_INDU,RET_TIME,RECOG_LEV,STA_TIME_VIL_CAD_RET_SER,SEC_ENLIST,SER_ARMY_WIN_HON_GRADE,SER_ARMY_WIN_HON_GRADE_EXPLAIN,SER_ARMY_WIN_HON_GRADE_TYPE,SER_ARMY_PUNISHMENT,SPECIAL_AREAS,SPE_REG_NAT_ONE,SPE_REG_NAT,SPECIAL_POST_TYPE_CODE,SER_CON_TYPE,SUPPORT_STATU,SUPPORT_UNIT,SOL_OLD_STATU,SLA_APPL_SUSP_DATE,SLA_SUSP_DATE,SLA_WHE_CANCEL,SLA_WHE_UPD,SLA_UPD_DATE,SOC_POS_RET_VIL_CAD,SOLD_CATE_CODE,TELE_NUM,TIME_EDU_BACK_CHANGE,TIME_DEGREE_INFOR_CHANGE,TIME_JOIN_THE_PARTY,TERM_OFF_RET_VIL_CAD,TIME_ENL,TRO_CODE,TECH_OFFI_ORI_HIG_RANK,TECH_CIV_CAD_ORI_HIG_RANK,TIME_LEV_ARM,THE_WAY_TO_BEC_MIL_EMPLOY,TIM_CU_WORK,TYPE
_OF_ENTRE,TOTAL_ASS,TRAINING_TYPE,THE_HANG_OF_GLO_CARD,TEN_VIL_CAD,UPDATE_TIME,UIC,UNIT_ABO_LEV,UNIT_TYPE,UNIT_NAME,UNIT_DETAIL_ADDR,UNI_SOCIAL_CODE,UNEMPLOYMENT,WIN_HON_GRADE,WIN_HON_GRADE_EXPLAIN,WHE_PARTY_MEM_DUES_TIME,WHE_TO_POST_PART_ORGAN,WHE_IS_ENLIST_INFOR,WHE_THERE_IS_RESETT_INFOR,WHE_THERE_MIL_STAFF_OR_NOT,WHE_THE_IS_EMPLOY,WHE_RET_SCH_RET,WHE_TRA_OTH_MAJ_RET,WHE_REC_STUDENT_SEP,WHE_TRA_SPE_MAT_EMPLOY_POS,WHE_THE_IS_PRE_PEN_INFOR,WHE_THE_ORPHAN,WHE_DISA_DUR_MY_SER,WHE_MEE_CON_BUR_CEM,WHE_THERE_IS_HELP_INFOR) values(?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,
?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)
```
### Oracle SQL Developper insert success
I replace ? to '1' from this sql, it can successfully insert to the target table from the Oracle SQL Developer.
### Execpt Result
Parse the Insert Sql successfully and can query the right result from the table.
### How to reviwe this issue
#### Create table SQL
```
CREATE TABLE "ARCHIVE_INFOR_NZ12" (
"INFOR_ID" VARCHAR2(50 BYTE) VISIBLE NOT NULL ,
"INFOR_STATUS" VARCHAR2(50 BYTE) VISIBLE ,
"INFOR_SYN_STATUS" VARCHAR2(50 BYTE) VISIBLE ,
"INFOR_TIME" VARCHAR2(50 BYTE) VISIBLE ,
"INFOR_USER_ID" VARCHAR2(50 BYTE) VISIBLE ,
"INFOR_ORGAN_ID" VARCHAR2(50 BYTE) VISIBLE ,
"INFOR_AUDIT_TIME" VARCHAR2(50 BYTE) VISIBLE ,
"INFOR_AUDIT_USER_ID" VARCHAR2(50 BYTE) VISIBLE ,
"INFOR_ATR_ORAGN_ID" VARCHAR2(50 BYTE) VISIBLE ,
"INFOR_GRADE_ID" VARCHAR2(50 BYTE) VISIBLE ,
"INFOR_GRADE_SYSCALC_ID" VARCHAR2(50 BYTE) VISIBLE ,
"INITIAL_FILING_TIME" VARCHAR2(50 BYTE) VISIBLE ,
"UPDATE_TIME" VARCHAR2(50 BYTE) VISIBLE ,
"DATA_FROM" VARCHAR2(50 BYTE) VISIBLE ,
"FILING_IN_ANOTHER_PLACE" VARCHAR2(50 BYTE) VISIBLE ,
"UIC" VARCHAR2(50 BYTE) VISIBLE ,
"IS_VETERAN" VARCHAR2(50 BYTE) VISIBLE ,
"NAME" VARCHAR2(50 BYTE) VISIBLE ,
"GENDER" VARCHAR2(50 BYTE) VISIBLE ,
"NATIONALITY" VARCHAR2(50 BYTE) VISIBLE ,
"BIRTH_DATE" VARCHAR2(50 BYTE) VISIBLE ,
"POLI_AFFI" VARCHAR2(50 BYTE) VISIBLE ,
"HEAL_STATU" VARCHAR2(50 BYTE) VISIBLE ,
"DOCU_TYPE" VARCHAR2(50 BYTE) VISIBLE ,
"ID_CARD_NUM" VARCHAR2(50 BYTE) VISIBLE ,
"ID_ISS_PLAC" VARCHAR2(100 BYTE) VISIBLE ,
"ID_CERT_VALI_BEGI_DATE" VARCHAR2(50 BYTE) VISIBLE ,
"ID_CERT_VALI_END_DATE" VARCHAR2(20 BYTE) VISIBLE ,
"DOCU_NUM" VARCHAR2(50 BYTE) VISIBLE ,
"HOUSE_REGIS_CATE" VARCHAR2(50 BYTE) VISIBLE ,
"TELE_NUM" VARCHAR2(50 BYTE) VISIBLE ,
"ADM_DIVI_DOMICILE" VARCHAR2(50 BYTE) VISIBLE ,
"DETAIL_ADDR_DOMICILE" VARCHAR2(100 BYTE) VISIBLE ,
"ADM_DIVI_CUR_RES" VARCHAR2(50 BYTE) VISIBLE ,
"DETAIL_ADDR_CURRES" VARCHAR2(100 BYTE) VISIBLE ,
"EDU_BACK" VARCHAR2(50 BYTE) VISIBLE ,
"TIME_EDU_BACK_CHANGE" VARCHAR2(50 BYTE) VISIBLE ,
"DEGREE_INFOR" VARCHAR2(50 BYTE) VISIBLE ,
"TIME_DEGREE_INFOR_CHANGE" VARCHAR2(50 BYTE) VISIBLE ,
"MAR_STATU" VARCHAR2(50 BYTE) VISIBLE ,
"ENDOW_INSU_ATT_STATU" VARCHAR2(20 BYTE) VISIBLE ,
"ADM_DIVI_ENDOW_INSU_PLACE" VARCHAR2(50 BYTE) VISIBLE ,
"ENDOW_INSU_DURA" VARCHAR2(50 BYTE) VISIBLE ,
"ENDOW_INSU_INTERRUPTED" VARCHAR2(50 BYTE) VISIBLE ,
"INTER_PERI_ENDOW_INSU" VARCHAR2(100 BYTE) VISIBLE ,
"MED_INSU_ATT_STATU" VARCHAR2(20 BYTE) VISIBLE ,
"ADM_DIVI_MED_INSU_PLACE" VARCHAR2(50 BYTE) VISIBLE ,
"MED_INSU_DURA" VARCHAR2(50 BYTE) VISIBLE ,
"MED_INSU_INTERRUPTED" VARCHAR2(50 BYTE) VISIBLE ,
"INTER_PERI_MED_INSU" VARCHAR2(100 BYTE) VISIBLE ,
"HOUS_STATU" VARCHAR2(20 BYTE) VISIBLE ,
"PAY_HOUS_FUND" VARCHAR2(50 BYTE) VISIBLE ,
"WIN_HON_GRADE" VARCHAR2(50 BYTE) VISIBLE ,
"WIN_HON_GRADE_EXPLAIN" VARCHAR2(2000 BYTE) VISIBLE ,
"PUNISHMENT_TYPE" VARCHAR2(50 BYTE) VISIBLE ,
"PUNISHMENT" VARCHAR2(2000 BYTE) VISIBLE ,
"HAVE_PARTI_ORGAN" VARCHAR2(50 BYTE) VISIBLE ,
"PARTY_BRANCH" VARCHAR2(200 BYTE) VISIBLE ,
"TIME_JOIN_THE_PARTY" VARCHAR2(50 BYTE) VISIBLE ,
"WHE_PARTY_MEM_DUES_TIME" VARCHAR2(50 BYTE) VISIBLE ,
"WHE_TO_POST_PART _ORGAN" VARCHAR2(50 BYTE) VISIBLE ,
"IS_OUT_ORGAN" VARCHAR2(50 BYTE) VISIBLE ,
"NUM_ORGAN_ACT_IN_ONE_YEAR" VARCHAR2(50 BYTE) VISIBLE ,
"ARE_VIL_CAD_RET_SOLD" VARCHAR2(50 BYTE) VISIBLE ,
"POST_VIL_CAD_RET_SOLD" VARCHAR2(50 BYTE) VISIBLE ,
"STA_TIME_VIL_CAD_RET_SER" VARCHAR2(50 BYTE) VISIBLE ,
"TERM_OFF_RET_VIL_CAD" VARCHAR2(50 BYTE) VISIBLE ,
"CON_SER_HEAD_VET_SER_STA" VARCHAR2(50 BYTE) VISIBLE ,
"IS_VOL_SER" VARCHAR2(50 BYTE) VISIBLE ,
"WHE_IS_ENLIST_INFOR" VARCHAR2(50 BYTE) VISIBLE ,
"SEC_ENLIST" VARCHAR2(50 BYTE) VISIBLE ,
"TIME_ENL" VARCHAR2(50 BYTE) VISIBLE ,
"ADM_DIVI_PLACE_ENL" VARCHAR2(50 BYTE) VISIBLE ,
"HOUSE_REG_ENL" VARCHAR2(50 BYTE) VISIBLE ,
"TRO_CODE" VARCHAR2(50 BYTE) VISIBLE ,
"UNIT_ABO_LEV" VARCHAR2(50 BYTE) VISIBLE ,
"RANK" VARCHAR2(50 BYTE) VISIBLE ,
"CAT_OFFI_CAD" VARCHAR2(50 BYTE) VISIBLE ,
"OFFI_TYPE" VARCHAR2(50 BYTE) VISIBLE ,
"CIV_CAD_TYPE" VARCHAR2(50 BYTE) VISIBLE ,
"MIL_OFFI_ORI_HIG_RANK" VARCHAR2(50 BYTE) VISIBLE ,
"TECH_OFFI_ORI_HIG_RANK" VARCHAR2(50 BYTE) VISIBLE ,
"MAN_CIV_CAD_ORI_HIG_RANK" VARCHAR2(50 BYTE) VISIBLE ,
"TECH_CIV_CAD_ORI_HIG_RANK" VARCHAR2(50 BYTE) VISIBLE ,
"SER_ARMY_WIN_HON_GRADE" VARCHAR2(50 BYTE) VISIBLE ,
"SER_ARMY_WIN_HON_GRADE_EXPLAIN" VARCHAR2(2000 BYTE) VISIBLE ,
"SER_ARMY_WIN_HON_GRADE_TYPE" VARCHAR2(50 BYTE) VISIBLE ,
"SER_ARMY_PUNISHMENT" VARCHAR2(2000 BYTE) VISIBLE ,
"SPECIAL_AREAS" VARCHAR2(50 BYTE) VISIBLE ,
"SPE_REG_NAT_ONE" VARCHAR2(50 BYTE) VISIBLE ,
"SPE_REG_NAT" VARCHAR2(50 BYTE) VISIBLE ,
"LEN_SER_SPE_AREAS" VARCHAR2(50 BYTE) VISIBLE ,
"SPECIAL_POST_TYPE_CODE" VARCHAR2(50 BYTE) VISIBLE ,
"WHE_THERE_IS_RESETT_INFOR" VARCHAR2(50 BYTE) VISIBLE ,
"TIME_LEV_ARM" VARCHAR2(50 BYTE) VISIBLE ,
"RES_DUTY" VARCHAR2(50 BYTE) VISIBLE ,
"RET_CER_TYPE" VARCHAR2(50 BYTE) VISIBLE ,
"RET_CERT_NUM" VARCHAR2(100 BYTE) VISIBLE ,
"PER_CATE_ONE_LEV" VARCHAR2(50 BYTE) VISIBLE ,
"PER_CATE_TWO_LEV" VARCHAR2(50 BYTE) VISIBLE ,
"ONE_TIME_RETIRE_PAYMENT" VARCHAR2(50 BYTE) VISIBLE ,
"MONTHLY_RETIRE_PAYMENT" VARCHAR2(50 BYTE) VISIBLE ,
"RESET_TYPE" VARCHAR2(50 BYTE) VISIBLE ,
"MIL_REST_CATE" VARCHAR2(50 BYTE) VISIBLE ,
"MIL_REST_RESET_TIME" VARCHAR2(50 BYTE) VISIBLE ,
"MIL_REST_ADM_DIVI_RESET_PLACE" VARCHAR2(50 BYTE) VISIBLE ,
"MIL_REST_DETAIL_ADDR_RESET_PLACE" VARCHAR2(100 BYTE) VISIBLE ,
"MIL_REST_RESET_MANA_UNIT_NAME" VARCHAR2(100 BYTE) VISIBLE ,
"MIL_REST_RESET_MANA_UNIT_NATURE" VARCHAR2(50 BYTE) VISIBLE ,
"MIL_REST_SER_MANA_ORGAN_NAME" VARCHAR2(100 BYTE) VISIBLE ,
"RETIR_RESET_TIME" VARCHAR2(50 BYTE) VISIBLE ,
"RETIR_ADM_DIVI_RESET_PLACE" VARCHAR2(50 BYTE) VISIBLE ,
"RETIR_DETAIL_ADDR_RESET_PLACE" VARCHAR2(100 BYTE) VISIBLE ,
"RETIR_RESET_UNIT_NAME" VARCHAR2(100 BYTE) VISIBLE ,
"RETIR_RESET_UNIT_NATURE" VARCHAR2(50 BYTE) VISIBLE ,
"RETIR_RESET_POS_RAN" VARCHAR2(50 BYTE) VISIBLE ,
"WHE_THERE_MIL_STAFF_OR_NOT" VARCHAR2(50 BYTE) VISIBLE ,
"NON_MI_STAFF_WORK_TIME" VARCHAR2(50 BYTE) VISIBLE ,
"NON_MI_STAFF_RET_TIME" VARCHAR2(50 BYTE) VISIBLE ,
"THE_WAY_TO_BEC_MIL_EMPLOY" VARCHAR2(50 BYTE) VISIBLE ,
"NON_MI_STAFF_ORI_UNIT" VARCHAR2(50 BYTE) VISIBLE ,
"NON_MI_STAFF_ORI_RANK" VARCHAR2(50 BYTE) VISIBLE ,
"NON_MI_STAFF_RET_CER_NUM" VARCHAR2(100 BYTE) VISIBLE ,
"NON_MI_STAFF_ADM_DIVI" VARCHAR2(50 BYTE) VISIBLE ,
"NON_MI_STAFF_DETAIL_ADDR" VARCHAR2(100 BYTE) VISIBLE ,
"NON_MI_STAFF_RES_PLAN_BAT" VARCHAR2(50 BYTE) VISIBLE ,
"NON_MI_STAFF_RET_REC_TIME" VARCHAR2(50 BYTE) VISIBLE ,
"NON_MI_STAFF_MAN_UNIT_NAT" VARCHAR2(50 BYTE) VISIBLE ,
"WHE_THE_IS_EMPLOY" VARCHAR2(50 BYTE) VISIBLE ,
"EMPLOYMENT" VARCHAR2(50 BYTE) VISIBLE ,
"EMPLOY_PER_ANN_INCOME" VARCHAR2(50 BYTE) VISIBLE ,
"EMPLOY_FAM_ANN_INCOME" VARCHAR2(50 BYTE) VISIBLE ,
"IS_NEW_EMPLOY" VARCHAR2(50 BYTE) VISIBLE ,
"EMPLOY_NEW_BUSI" VARCHAR2(50 BYTE) VISIBLE ,
"UNIT_TYPE" VARCHAR2(50 BYTE) VISIBLE ,
"POSITION_TYPE" VARCHAR2(50 BYTE) VISIBLE ,
"UNIT_NAME" VARCHAR2(100 BYTE) VISIBLE ,
"ADM_DIV_UNIT_ADDR" VARCHAR2(50 BYTE) VISIBLE ,
"UNIT_DETAIL_ADDR" VARCHAR2(100 BYTE) VISIBLE ,
"TIM_CU_WORK" VARCHAR2(50 BYTE) VISIBLE ,
"ENGA_INDUSTRY" VARCHAR2(50 BYTE) VISIBLE ,
"SER_CON_TYPE" VARCHAR2(50 BYTE) VISIBLE ,
"ENTERPRISE_NAME" VARCHAR2(100 BYTE) VISIBLE ,
"TYPE_OF_ENTRE" VARCHAR2(50 BYTE) VISIBLE ,
"POST" VARCHAR2(50 BYTE) VISIBLE ,
"LEGAL_REPRE" VARCHAR2(50 BYTE) VISIBLE ,
"LEGAL_REPRE_TELE_NUM" VARCHAR2(50 BYTE) VISIBLE ,
"HOLD_SITUA" VARCHAR2(50 BYTE) VISIBLE ,
"UNI_SOCIAL_CODE" VARCHAR2(50 BYTE) VISIBLE ,
"INDU_ENTERPRISE" VARCHAR2(50 BYTE) VISIBLE ,
"ADM_DIV_ENTER_REG_ADDR" VARCHAR2(50 BYTE) VISIBLE ,
"ENTER_REG_DETAIL_ADDR" VARCHAR2(100 BYTE) VISIBLE ,
"ENTER_REG_TIME" VARCHAR2(50 BYTE) VISIBLE ,
"NUM_EMPLOY" VARCHAR2(50 BYTE) VISIBLE ,
"NUM_VETERANS" VARCHAR2(50 BYTE) VISIBLE ,
"TOTAL_ASS" VARCHAR2(50 BYTE) VISIBLE ,
"ANN_OPE_INCOME" VARCHAR2(50 BYTE) VISIBLE ,
"ENJOY_SUPPORT_POL" VARCHAR2(50 BYTE) VISIBLE ,
"GO_TO_COUNTRY_ENTRE" VARCHAR2(50 BYTE) VISIBLE ,
"PUB_WEL_POST_NAME" VARCHAR2(50 BYTE) VISIBLE ,
"PUB_WEL_POST_TIME" VARCHAR2(50 BYTE) VISIBLE ,
"INDU_PUB_WEL_POST" VARCHAR2(50 BYTE) VISIBLE ,
"LIB_PRO_NAME" VARCHAR2(50 BYTE) VISIBLE ,
"LIB_PRO_TIME" VARCHAR2(50 BYTE) VISIBLE ,
"INDU_LIB_PRO" VARCHAR2(50 BYTE) VISIBLE ,
"UNEMPLOYMENT" VARCHAR2(50 BYTE) VISIBLE ,
"JOBLESS_FAMILY" VARCHAR2(50 BYTE) VISIBLE ,
"IS_EMPLOY_INTEN" VARCHAR2(50 BYTE) VISIBLE ,
"IS_POST_SER_ACA_EDU" VARCHAR2(50 BYTE) VISIBLE ,
"WHE_RET_SCH_RET" VARCHAR2(50 BYTE) VISIBLE ,
"WHE_TRA_OTH_MAJ_RET" VARCHAR2(50 BYTE) VISIBLE ,
"IS_STUDENT_AID" VARCHAR2(50 BYTE) VISIBLE ,
"AMO_FINA_AID" VARCHAR2(50 BYTE) VISIBLE ,
"WHE_REC_STUDENT_SEP" VARCHAR2(50 BYTE) VISIBLE ,
"IS_SEP_PLAN" VARCHAR2(50 BYTE) VISIBLE ,
"PRE_SER_EDU" VARCHAR2(50 BYTE) VISIBLE ,
"PRE_SER_EDU_BACK" VARCHAR2(50 BYTE) VISIBLE ,
"EDU_BACK_BEFORE_RET" VARCHAR2(50 BYTE) VISIBLE ,
"EDU_BACK_ACQ_TIME_BEFORE_RET" VARCHAR2(50 BYTE) VISIBLE ,
"DEGREE_INFOR_BEFORE_RET" VARCHAR2(50 BYTE) VISIBLE ,
"DEGREE_INFOR_ACQ_TIME_BEFORE_RET" VARCHAR2(50 BYTE) VISIBLE ,
"IS_VOC_SKILL_TRAIN" VARCHAR2(50 BYTE) VISIBLE ,
"TRAINING_TYPE" VARCHAR2(50 BYTE) VISIBLE ,
"PART_TRAIN" VARCHAR2(50 BYTE) VISIBLE ,
"CERTI_QUALI" VARCHAR2(50 BYTE) VISIBLE ,
"CERTI_TYPE" VARCHAR2(50 BYTE) VISIBLE ,
"NAME_VOC_SKI_CERTI" VARCHAR2(100 BYTE) VISIBLE ,
"DIR_EMPLOY_VOC_SKI_TRAIN" VARCHAR2(50 BYTE) VISIBLE ,
"WHE_TRA_SPE_MAT_EMPLOY_POS" VARCHAR2(50 BYTE) VISIBLE ,
"WHE_THE_IS_PRE_PEN_INFOR" VARCHAR2(50 BYTE) VISIBLE ,
"CAT_PRE_OBJECT" VARCHAR2(50 BYTE) VISIBLE ,
"ENJOY_PRE_TREAT" VARCHAR2(50 BYTE) VISIBLE ,
"SUPPORT_STATU" VARCHAR2(50 BYTE) VISIBLE ,
"SUPPORT_UNIT" VARCHAR2(50 BYTE) VISIBLE ,
"SOL_OLD_STATU" VARCHAR2(50 BYTE) VISIBLE ,
"WHE_THE_ORPHAN" VARCHAR2(50 BYTE) VISIBLE ,
"WHE_DISA_DUR_MY_SER" VARCHAR2(50 BYTE) VISIBLE ,
"LABOR_CAPACITY" VARCHAR2(50 BYTE) VISIBLE ,
"ABILITY_LIVE" VARCHAR2(50 BYTE) VISIBLE ,
"PSY_OR_NOT" VARCHAR2(50 BYTE) VISIBLE ,
"DISA_CATE" VARCHAR2(50 BYTE) VISIBLE ,
"DISA_GRADE" VARCHAR2(50 BYTE) VISIBLE ,
"DISA_CER_NUM" VARCHAR2(100 BYTE) VISIBLE ,
"ASS_DISA_TIME" VARCHAR2(50 BYTE) VISIBLE ,
"MART_RELA" VARCHAR2(50 BYTE) VISIBLE ,
"MART_FAM_WHE_PERMIT" VARCHAR2(50 BYTE) VISIBLE ,
"MART_CERTI_NUM" VARCHAR2(100 BYTE) VISIBLE ,
"MART_NAME" VARCHAR2(50 BYTE) VISIBLE ,
"MART_GENDER" VARCHAR2(50 BYTE) VISIBLE ,
"MART_BIRTH_DATE" VARCHAR2(50 BYTE) VISIBLE ,
"MART_TIME_ENL" VARCHAR2(50 BYTE) VISIBLE ,
"MART_WORK_PLAC_DEATH" VARCHAR2(50 BYTE) VISIBLE ,
"MART_SACR_TIME" VARCHAR2(50 BYTE) VISIBLE ,
"MARTYR_SACRIFIC_REASON" VARCHAR2(1000 BYTE) VISIBLE ,
"MART_ASS_TIME" VARCHAR2(50 BYTE) VISIBLE ,
"MART_ASS_UNIT" VARCHAR2(100 BYTE) VISIBLE ,
"BUR_MARTYRS" VARCHAR2(50 BYTE) VISIBLE ,
"DOM_MAR_CEM" VARCHAR2(50 BYTE) VISIBLE ,
"MAR_CEM_DET_ADDR" VARCHAR2(200 BYTE) VISIBLE ,
"ON_DUT_SACRIF_SOLD_RELA" VARCHAR2(50 BYTE) VISIBLE ,
"ON_DUT_SACRIF_SOLD_FAM_WHE_PERIMIT" VARCHAR2(50 BYTE) VISIBLE ,
"ON_DUT_SACRIF_SOLD_CERTI_NUM" VARCHAR2(100 BYTE) VISIBLE ,
"ON_DUT_SACRIF_SOLD_NAME" VARCHAR2(50 BYTE) VISIBLE ,
"ON_DUT_SACRIF_SOLD_GENDER" VARCHAR2(50 BYTE) VISIBLE ,
"ON_DUT_SACRIF_SOLD_BIRTH_DATE" VARCHAR2(50 BYTE) VISIBLE ,
"ON_DUT_SACRIF_SOLD_TIME_ENL" VARCHAR2(50 BYTE) VISIBLE ,
"ON_DUT_SACRIF_SOLD_PLAC_DEATH" VARCHAR2(50 BYTE) VISIBLE ,
"ON_DUT_SACRIF_SOLD_TIME_DEATH" VARCHAR2(50 BYTE) VISIBLE ,
"ON_DUT_SACRIF_SOLD_REASON" VARCHAR2(1000 BYTE) VISIBLE ,
"ON_DUT_SACRIF_SOLD_ASS_TIME" VARCHAR2(50 BYTE) VISIBLE ,
"ILLNE_DEA_SOLD_RELA" VARCHAR2(50 BYTE) VISIBLE ,
"ILLNE_DEA_SOLD_FAM_WHE_PERMIT" VARCHAR2(50 BYTE) VISIBLE ,
"ILLNE_DEA_SOLD_CERTI_NUM" VARCHAR2(100 BYTE) VISIBLE ,
"ILLNE_DEA_SOLD_NAME" VARCHAR2(50 BYTE) VISIBLE ,
"ILLNE_DEA_SOLD_GENDER" VARCHAR2(50 BYTE) VISIBLE ,
"ILLNE_DEA_SOLD_BIRTH_DATE" VARCHAR2(50 BYTE) VISIBLE ,
"ILLNE_DEA_SOLD_TIME_ENL" VARCHAR2(50 BYTE) VISIBLE ,
"ILLNE_DEA_SOLD_WORK_PLAC_DEATH" VARCHAR2(50 BYTE) VISIBLE ,
"ILLNE_DEA_SOLD_TIME_DEATH" VARCHAR2(50 BYTE) VISIBLE ,
"ILLNE_DEA_SOLD_REASON" VARCHAR2(1000 BYTE) VISIBLE ,
"ILLNE_DEA_SOLD_ASS_TIME" VARCHAR2(50 BYTE) VISIBLE ,
"IS_PRAISE_ENCOURAGE" VARCHAR2(50 BYTE) VISIBLE ,
"THE_HANG_OF_GLO_CARD" VARCHAR2(50 BYTE) VISIBLE ,
"SLA_APPL_SUSP_DATE" VARCHAR2(50 BYTE) VISIBLE ,
"ADM_DIVI_SLAVA" VARCHAR2(50 BYTE) VISIBLE ,
"DETAIL_ADDR_SLAVA" VARCHAR2(100 BYTE) VISIBLE ,
"SLA_SUSP_DATE" VARCHAR2(50 BYTE) VISIBLE ,
"SLA_WHE_CANCEL" VARCHAR2(50 BYTE) VISIBLE ,
"SLA_WHE_UPD" VARCHAR2(50 BYTE) VISIBLE ,
"SLA_UPD_DATE" VARCHAR2(50 BYTE) VISIBLE ,
"HAVE_REC_SYM" VARCHAR2(50 BYTE) VISIBLE ,
"HONOR_INCENTIVE" VARCHAR2(50 BYTE) VISIBLE ,
"OTH_HON_INCENTIVES" VARCHAR2(50 BYTE) VISIBLE ,
"INCLU_LOCAL_CHRO" VARCHAR2(50 BYTE) VISIBLE ,
"ARE_PAT_NAT_DEF_EDU" VARCHAR2(50 BYTE) VISIBLE ,
"IS_PRA_PUB" VARCHAR2(50 BYTE) VISIBLE ,
"WHE_MEE_CON_BUR_CEM" VARCHAR2(50 BYTE) VISIBLE ,
"ARE_WIL_APPLY_MIL_CEM" VARCHAR2(50 BYTE) VISIBLE ,
"WHE_THERE_IS_HELP_INFOR" VARCHAR2(50 BYTE) VISIBLE ,
"ENJOY_POL_GUA" VARCHAR2(50 BYTE) VISIBLE ,
"DIFF_TYPE" VARCHAR2(50 BYTE) VISIBLE ,
"DIFF_STATU_EXP" VARCHAR2(2000 BYTE) VISIBLE ,
"ASSI_RESU" VARCHAR2(50 BYTE) VISIBLE ,
"REDUCE_CAUSE" VARCHAR2(50 BYTE) VISIBLE ,
"REDUCE_EXPLAIN" VARCHAR2(1000 BYTE) VISIBLE ,
"REDUCE_TIME" VARCHAR2(50 BYTE) VISIBLE ,
"REDUCE_USER_ID" VARCHAR2(50 BYTE) VISIBLE ,
"REDUCE_ORGAN_ID" VARCHAR2(50 BYTE) VISIBLE ,
"REDUCE_DEATH_TIME" VARCHAR2(50 BYTE) VISIBLE ,
"SOC_POS_RET_VIL_CAD" VARCHAR2(50 BYTE) VISIBLE ,
"DEP_TIME_VIL_CAD_RET_SER" VARCHAR2(50 BYTE) VISIBLE ,
"RET_VIL_CAD_CON_SER_TOWN_LEAD" VARCHAR2(50 BYTE) VISIBLE ,
"IS_EXP_VIL_CAD" VARCHAR2(50 BYTE) VISIBLE ,
"COM_RET_VIL_CAD_DUR_TEN" VARCHAR2(50 BYTE) VISIBLE ,
"ANN_INCOME_RET_VIL_CAD" VARCHAR2(50 BYTE) VISIBLE ,
"ADV_SPE_RET_VIL_CAD" VARCHAR2(50 BYTE) VISIBLE ,
"COM_POPU_RET_VIL_CAD" VARCHAR2(50 BYTE) VISIBLE ,
"ANN_INCOME_VIL_COLL_ECON" VARCHAR2(50 BYTE) VISIBLE ,
"AREA_RET_VIL_CAD_COM" VARCHAR2(50 BYTE) VISIBLE ,
"NUM_MEM_TWO_COM" VARCHAR2(50 BYTE) VISIBLE ,
"CHARAC_INDUSTRY" VARCHAR2(50 BYTE) VISIBLE ,
"TEN_VIL_CAD" VARCHAR2(50 BYTE) VISIBLE ,
"DES_OTH_ADV_SPE_RET_VIL_CAD" VARCHAR2(200 BYTE) VISIBLE ,
"DES_OTH_CHARAC_INDUSTRY" VARCHAR2(200 BYTE) VISIBLE ,
"SOLD_CATE_CODE" VARCHAR2(50 BYTE) VISIBLE ,
"REC_ONE_TIME_RET_GRANT" VARCHAR2(50 BYTE) VISIBLE ,
"RET_PAY_COL_TIME" VARCHAR2(50 BYTE) VISIBLE ,
"PRE_RET_UNIT" VARCHAR2(50 BYTE) VISIBLE ,
"PRE_RET_UNIT_ADDR" VARCHAR2(50 BYTE) VISIBLE ,
"PRE_RET_UNIT_DETAIL_ADDR" VARCHAR2(100 BYTE) VISIBLE ,
"RET_INDU" VARCHAR2(50 BYTE) VISIBLE ,
"RET_TIME" VARCHAR2(50 BYTE) VISIBLE ,
"ADM_DIVI_MED_COM_RET_VIL_CAD" VARCHAR2(200 BYTE) VISIBLE ,
"RECOG_LEV" VARCHAR2(50 BYTE) VISIBLE ,
"COMMENDATION" VARCHAR2(50 BYTE) VISIBLE ,
"OTH_NOTES_COMMEN" VARCHAR2(200 BYTE) VISIBLE ,
"ANN_JOB_SAT_EVA" VARCHAR2(50 BYTE) VISIBLE ,
"INFOR_ALL_SHOULE_ITEM" VARCHAR2(50 BYTE) VISIBLE ,
"INFOR_ALL_COMPLETE_ITEM" VARCHAR2(50 BYTE) VISIBLE ,
"INFOR_MUST_SHOULE_ITEM" VARCHAR2(50 BYTE) VISIBLE ,
"INFOR_MUST_COMPLETE_ITEM" VARCHAR2(50 BYTE) VISIBLE ,
"INFOR_KEY_SHOULE_ITEM" VARCHAR2(50 BYTE) VISIBLE ,
"INFOR_KEY_COMPLETE_ITEM" VARCHAR2(50 BYTE) VISIBLE )
```
#### Conf file
```
spring.shardingsphere.datasource.names=dsencrypt
spring.shardingsphere.datasource.dsencrypt.type=com.zaxxer.hikari.HikariDataSource
spring.shardingsphere.datasource.dsencrypt.driver-class-name=oracle.jdbc.driver.OracleDriver
spring.shardingsphere.datasource.dsencrypt.jdbc-url=jdbc:oracle:thin:@10.0.109.3:1521/orclpdb
spring.shardingsphere.datasource.dsencrypt.username=JDLK_PROD_USER1
spring.shardingsphere.datasource.dsencrypt.password=Swxa12345
spring.shardingsphere.rules.encrypt.encryptors.name_encryptor.type=AES
spring.shardingsphere.rules.encrypt.encryptors.name_encryptor.props.aes-key-value=123456
spring.shardingsphere.rules.encrypt.tables.ARCHIVE_INFOR_NZ11.columns.NAME.cipher-column=NAME
spring.shardingsphere.rules.encrypt.tables.ARCHIVE_INFOR_NZ11.columns.NAME.encryptor-name=name_encryptor
spring.shardingsphere.rules.encrypt.tables.ARCHIVE_INFOR_NZ11.columns.ID_CARD_NUM.cipher-column=ID_CARD_NUM
spring.shardingsphere.rules.encrypt.tables.ARCHIVE_INFOR_NZ11.columns.ID_CARD_NUM.encryptor-name=name_encryptor
spring.shardingsphere.rules.encrypt.tables.ARCHIVE_INFOR_NZ11.columns.TELE_NUM.cipher-column=TELE_NUM
spring.shardingsphere.rules.encrypt.tables.ARCHIVE_INFOR_NZ11.columns.TELE_NUM.encryptor-name=name_encryptor
spring.shardingsphere.rules.encrypt.tables.ARCHIVE_INFOR_NZ11.columns.ADM_DIVI_DOMICILE.cipher-column=ADM_DIVI_DOMICILE
spring.shardingsphere.rules.encrypt.tables.ARCHIVE_INFOR_NZ11.columns.ADM_DIVI_DOMICILE.encryptor-name=name_encryptor
spring.shardingsphere.rules.encrypt.tables.ARCHIVE_INFOR_NZ11.columns.DETAIL_ADDR_DOMICILE.cipher-column=DETAIL_ADDR_DOMICILE
spring.shardingsphere.rules.encrypt.tables.ARCHIVE_INFOR_NZ11.columns.DETAIL_ADDR_DOMICILE.encryptor-name=name_encryptor
spring.shardingsphere.rules.encrypt.tables.ARCHIVE_INFOR_NZ11.columns.ADM_DIVI_CUR_RES.cipher-column=ADM_DIVI_CUR_RES
spring.shardingsphere.rules.encrypt.tables.ARCHIVE_INFOR_NZ11.columns.ADM_DIVI_CUR_RES.encryptor-name=name_encryptor
spring.shardingsphere.rules.encrypt.tables.ARCHIVE_INFOR_NZ11.columns.DETAIL_ADDR_CURRES.cipher-column=DETAIL_ADDR_CURRES
spring.shardingsphere.rules.encrypt.tables.ARCHIVE_INFOR_NZ11.columns.DETAIL_ADDR_CURRES.encryptor-name=name_encryptor
spring.shardingsphere.rules.encrypt.tables.ARCHIVE_INFOR_NZ11.columns.PARTY_BRANCH.cipher-column=PARTY_BRANCH
spring.shardingsphere.rules.encrypt.tables.ARCHIVE_INFOR_NZ11.columns.PARTY_BRANCH.encryptor-name=name_encryptor
spring.shardingsphere.rules.encrypt.tables.ARCHIVE_INFOR_NZ11.columns.POST_VIL_CAD_RET_SOLD.cipher-column=POST_VIL_CAD_RET_SOLD
spring.shardingsphere.rules.encrypt.tables.ARCHIVE_INFOR_NZ11.columns.POST_VIL_CAD_RET_SOLD.encryptor-name=name_encryptor
spring.shardingsphere.rules.encrypt.tables.ARCHIVE_INFOR_NZ11.columns.TIME_ENL.cipher-column=TIME_ENL
spring.shardingsphere.rules.encrypt.tables.ARCHIVE_INFOR_NZ11.columns.TIME_ENL.encryptor-name=name_encryptor
spring.shardingsphere.rules.encrypt.tables.ARCHIVE_INFOR_NZ11.columns.ADM_DIVI_PLACE_ENL.cipher-column=ADM_DIVI_PLACE_ENL
spring.shardingsphere.rules.encrypt.tables.ARCHIVE_INFOR_NZ11.columns.ADM_DIVI_PLACE_ENL.encryptor-name=name_encryptor
spring.shardingsphere.rules.encrypt.tables.ARCHIVE_INFOR_NZ11.columns.HOUSE_REG_ENL.cipher-column=HOUSE_REG_ENL
spring.shardingsphere.rules.encrypt.tables.ARCHIVE_INFOR_NZ11.columns.HOUSE_REG_ENL.encryptor-name=name_encryptor
spring.shardingsphere.rules.encrypt.tables.ARCHIVE_INFOR_NZ11.columns.TRO_CODE.cipher-column=TRO_CODE
spring.shardingsphere.rules.encrypt.tables.ARCHIVE_INFOR_NZ11.columns.TRO_CODE.encryptor-name=name_encryptor
spring.shardingsphere.rules.encrypt.tables.ARCHIVE_INFOR_NZ11.columns.UNIT_ABO_LEV.cipher-column=UNIT_ABO_LEV
spring.shardingsphere.rules.encrypt.tables.ARCHIVE_INFOR_NZ11.columns.UNIT_ABO_LEV.encryptor-name=name_encryptor
spring.shardingsphere.rules.encrypt.tables.ARCHIVE_INFOR_NZ11.columns.RANK.cipher-column=RANK
spring.shardingsphere.rules.encrypt.tables.ARCHIVE_INFOR_NZ11.columns.RANK.encryptor-name=name_encryptor
spring.shardingsphere.rules.encrypt.tables.ARCHIVE_INFOR_NZ11.columns.CAT_OFFI_CAD.cipher-column=CAT_OFFI_CAD
spring.shardingsphere.rules.encrypt.tables.ARCHIVE_INFOR_NZ11.columns.CAT_OFFI_CAD.encryptor-name=name_encryptor
spring.shardingsphere.rules.encrypt.tables.ARCHIVE_INFOR_NZ11.columns.OFFI_TYPE.cipher-column=OFFI_TYPE
spring.shardingsphere.rules.encrypt.tables.ARCHIVE_INFOR_NZ11.columns.OFFI_TYPE.encryptor-name=name_encryptor
spring.shardingsphere.rules.encrypt.tables.ARCHIVE_INFOR_NZ11.columns.CIV_CAD_TYPE.cipher-column=CIV_CAD_TYPE
spring.shardingsphere.rules.encrypt.tables.ARCHIVE_INFOR_NZ11.columns.CIV_CAD_TYPE.encryptor-name=name_encryptor
spring.shardingsphere.rules.encrypt.tables.ARCHIVE_INFOR_NZ11.columns.MIL_OFFI_ORI_HIG_RANK.cipher-column=MIL_OFFI_ORI_HIG_RANK
spring.shardingsphere.rules.encrypt.tables.ARCHIVE_INFOR_NZ11.columns.MIL_OFFI_ORI_HIG_RANK.encryptor-name=name_encryptor
spring.shardingsphere.rules.encrypt.tables.ARCHIVE_INFOR_NZ11.columns.TECH_OFFI_ORI_HIG_RANK.cipher-column=TECH_OFFI_ORI_HIG_RANK
spring.shardingsphere.rules.encrypt.tables.ARCHIVE_INFOR_NZ11.columns.TECH_OFFI_ORI_HIG_RANK.encryptor-name=name_encryptor
spring.shardingsphere.rules.encrypt.tables.ARCHIVE_INFOR_NZ11.columns.MAN_CIV_CAD_ORI_HIG_RANK.cipher-column=MAN_CIV_CAD_ORI_HIG_RANK
spring.shardingsphere.rules.encrypt.tables.ARCHIVE_INFOR_NZ11.columns.MAN_CIV_CAD_ORI_HIG_RANK.encryptor-name=name_encryptor
spring.shardingsphere.rules.encrypt.tables.ARCHIVE_INFOR_NZ11.columns.TECH_CIV_CAD_ORI_HIG_RANK.cipher-column=TECH_CIV_CAD_ORI_HIG_RANK
spring.shardingsphere.rules.encrypt.tables.ARCHIVE_INFOR_NZ11.columns.TECH_CIV_CAD_ORI_HIG_RANK.encryptor-name=name_encryptor
spring.shardingsphere.rules.encrypt.tables.ARCHIVE_INFOR_NZ11.columns.SER_ARMY_WIN_HON_GRADE.cipher-column=SER_ARMY_WIN_HON_GRADE
spring.shardingsphere.rules.encrypt.tables.ARCHIVE_INFOR_NZ11.columns.SER_ARMY_WIN_HON_GRADE.encryptor-name=name_encryptor
spring.shardingsphere.rules.encrypt.tables.ARCHIVE_INFOR_NZ11.columns.SER_ARMY_WIN_HON_GRADE_EXPLAIN.cipher-column=SER_ARMY_WIN_HON_GRADE_EXPLAIN
spring.shardingsphere.rules.encrypt.tables.ARCHIVE_INFOR_NZ11.columns.SER_ARMY_WIN_HON_GRADE_EXPLAIN.encryptor-name=name_encryptor
spring.shardingsphere.rules.encrypt.tables.ARCHIVE_INFOR_NZ11.columns.SER_ARMY_WIN_HON_GRADE_TYPE.cipher-column=SER_ARMY_WIN_HON_GRADE_TYPE
spring.shardingsphere.rules.encrypt.tables.ARCHIVE_INFOR_NZ11.columns.SER_ARMY_WIN_HON_GRADE_TYPE.encryptor-name=name_encryptor
spring.shardingsphere.rules.encrypt.tables.ARCHIVE_INFOR_NZ11.columns.SER_ARMY_PUNISHMENT.cipher-column=SER_ARMY_PUNISHMENT
spring.shardingsphere.rules.encrypt.tables.ARCHIVE_INFOR_NZ11.columns.SER_ARMY_PUNISHMENT.encryptor-name=name_encryptor
spring.shardingsphere.rules.encrypt.tables.ARCHIVE_INFOR_NZ11.columns.SPECIAL_AREAS.cipher-column=SPECIAL_AREAS
spring.shardingsphere.rules.encrypt.tables.ARCHIVE_INFOR_NZ11.columns.SPECIAL_AREAS.encryptor-name=name_encryptor
spring.shardingsphere.rules.encrypt.tables.ARCHIVE_INFOR_NZ11.columns.SPE_REG_NAT_ONE.cipher-column=SPE_REG_NAT_ONE
spring.shardingsphere.rules.encrypt.tables.ARCHIVE_INFOR_NZ11.columns.SPE_REG_NAT_ONE.encryptor-name=name_encryptor
spring.shardingsphere.rules.encrypt.tables.ARCHIVE_INFOR_NZ11.columns.SPE_REG_NAT.cipher-column=SPE_REG_NAT
spring.shardingsphere.rules.encrypt.tables.ARCHIVE_INFOR_NZ11.columns.SPE_REG_NAT.encryptor-name=name_encryptor
spring.shardingsphere.rules.encrypt.tables.ARCHIVE_INFOR_NZ11.columns.LEN_SER_SPE_AREAS.cipher-column=LEN_SER_SPE_AREAS
spring.shardingsphere.rules.encrypt.tables.ARCHIVE_INFOR_NZ11.columns.LEN_SER_SPE_AREAS.encryptor-name=name_encryptor
spring.shardingsphere.rules.encrypt.tables.ARCHIVE_INFOR_NZ11.columns.SPECIAL_POST_TYPE_CODE.cipher-column=SPECIAL_POST_TYPE_CODE
spring.shardingsphere.rules.encrypt.tables.ARCHIVE_INFOR_NZ11.columns.SPECIAL_POST_TYPE_CODE.encryptor-name=name_encryptor
spring.shardingsphere.rules.encrypt.tables.ARCHIVE_INFOR_NZ11.columns.TIME_LEV_ARM.cipher-column=TIME_LEV_ARM
spring.shardingsphere.rules.encrypt.tables.ARCHIVE_INFOR_NZ11.columns.TIME_LEV_ARM.encryptor-name=name_encryptor
spring.shardingsphere.rules.encrypt.tables.ARCHIVE_INFOR_NZ11.columns.RES_DUTY.cipher-column=RES_DUTY
spring.shardingsphere.rules.encrypt.tables.ARCHIVE_INFOR_NZ11.columns.RES_DUTY.encryptor-name=name_encryptor
spring.shardingsphere.rules.encrypt.tables.ARCHIVE_INFOR_NZ11.columns.RET_CER_TYPE.cipher-column=RET_CER_TYPE
spring.shardingsphere.rules.encrypt.tables.ARCHIVE_INFOR_NZ11.columns.RET_CER_TYPE.encryptor-name=name_encryptor
spring.shardingsphere.rules.encrypt.tables.ARCHIVE_INFOR_NZ11.columns.RET_CERT_NUM.cipher-column=RET_CERT_NUM
spring.shardingsphere.rules.encrypt.tables.ARCHIVE_INFOR_NZ11.columns.RET_CERT_NUM.encryptor-name=name_encryptor
spring.shardingsphere.rules.encrypt.tables.ARCHIVE_INFOR_NZ11.columns.PER_CATE_ONE_LEV.cipher-column=PER_CATE_ONE_LEV
spring.shardingsphere.rules.encrypt.tables.ARCHIVE_INFOR_NZ11.columns.PER_CATE_ONE_LEV.encryptor-name=name_encryptor
spring.shardingsphere.rules.encrypt.tables.ARCHIVE_INFOR_NZ11.columns.PER_CATE_TWO_LEV.cipher-column=PER_CATE_TWO_LEV
spring.shardingsphere.rules.encrypt.tables.ARCHIVE_INFOR_NZ11.columns.PER_CATE_TWO_LEV.encryptor-name=name_encryptor
spring.shardingsphere.rules.encrypt.tables.ARCHIVE_INFOR_NZ11.columns.NON_MI_STAFF_ORI_UNIT.cipher-column=NON_MI_STAFF_ORI_UNIT
spring.shardingsphere.rules.encrypt.tables.ARCHIVE_INFOR_NZ11.columns.NON_MI_STAFF_ORI_UNIT.encryptor-name=name_encryptor
spring.shardingsphere.rules.encrypt.tables.ARCHIVE_INFOR_NZ11.columns.NON_MI_STAFF_ORI_RANK.cipher-column=NON_MI_STAFF_ORI_RANK
spring.shardingsphere.rules.encrypt.tables.ARCHIVE_INFOR_NZ11.columns.NON_MI_STAFF_ORI_RANK.encryptor-name=name_encryptor
spring.shardingsphere.rules.encrypt.tables.ARCHIVE_INFOR_NZ11.columns.NON_MI_STAFF_RET_CER_NUM.cipher-column=NON_MI_STAFF_RET_CER_NUM
spring.shardingsphere.rules.encrypt.tables.ARCHIVE_INFOR_NZ11.columns.NON_MI_STAFF_RET_CER_NUM.encryptor-name=name_encryptor
spring.shardingsphere.rules.encrypt.tables.ARCHIVE_INFOR_NZ11.columns.ON_DUT_SACRIF_SOLD_NAME.cipher-column=ON_DUT_SACRIF_SOLD_NAME
spring.shardingsphere.rules.encrypt.tables.ARCHIVE_INFOR_NZ11.columns.ON_DUT_SACRIF_SOLD_NAME.encryptor-name=name_encryptor
spring.shardingsphere.rules.encrypt.tables.ARCHIVE_INFOR_NZ11.columns.ON_DUT_SACRIF_SOLD_PLAC_DEATH.cipher-column=ON_DUT_SACRIF_SOLD_PLAC_DEATH
spring.shardingsphere.rules.encrypt.tables.ARCHIVE_INFOR_NZ11.columns.ON_DUT_SACRIF_SOLD_PLAC_DEATH.encryptor-name=name_encryptor
spring.shardingsphere.rules.encrypt.tables.ARCHIVE_INFOR_NZ11.columns.ILLNE_DEA_SOLD_NAME.cipher-column=ILLNE_DEA_SOLD_NAME
spring.shardingsphere.rules.encrypt.tables.ARCHIVE_INFOR_NZ11.columns.ILLNE_DEA_SOLD_NAME.encryptor-name=name_encryptor
spring.shardingsphere.rules.encrypt.tables.ARCHIVE_INFOR_NZ11.columns.ILLNE_DEA_SOLD_WORK_PLAC_DEATH.cipher-column=ILLNE_DEA_SOLD_WORK_PLAC_DEATH
spring.shardingsphere.rules.encrypt.tables.ARCHIVE_INFOR_NZ11.columns.ILLNE_DEA_SOLD_WORK_PLAC_DEATH.encryptor-name=name_encryptor
spring.shardingsphere.rules.encrypt.tables.ARCHIVE_INFOR_NZ11.columns.MART_NAME.cipher-column=MART_NAME
spring.shardingsphere.rules.encrypt.tables.ARCHIVE_INFOR_NZ11.columns.MART_NAME.encryptor-name=name_encryptor
spring.shardingsphere.rules.encrypt.tables.ARCHIVE_INFOR_NZ11.columns.MART_WORK_PLAC_DEATH.cipher-column=MART_WORK_PLAC_DEATH
spring.shardingsphere.rules.encrypt.tables.ARCHIVE_INFOR_NZ11.columns.MART_WORK_PLAC_DEATH.encryptor-name=name_encryptor
spring.shardingsphere.rules.encrypt.tables.ARCHIVE_INFOR_NZ11.columns.MIL_REST_CATE.cipher-column=MIL_REST_CATE
spring.shardingsphere.rules.encrypt.tables.ARCHIVE_INFOR_NZ11.columns.MIL_REST_CATE.encryptor-name=name_encryptor
spring.shardingsphere.rules.encrypt.tables.ARCHIVE_INFOR_NZ11.columns.MIL_REST_RESET_TIME.cipher-column=MIL_REST_RESET_TIME
spring.shardingsphere.rules.encrypt.tables.ARCHIVE_INFOR_NZ11.columns.MIL_REST_RESET_TIME.encryptor-name=name_encryptor
spring.shardingsphere.rules.encrypt.tables.ARCHIVE_INFOR_NZ11.columns.MIL_REST_ADM_DIVI_RESET_PLACE.cipher-column=MIL_REST_ADM_DIVI_RESET_PLACE
spring.shardingsphere.rules.encrypt.tables.ARCHIVE_INFOR_NZ11.columns.MIL_REST_ADM_DIVI_RESET_PLACE.encryptor-name=name_encryptor
spring.shardingsphere.rules.encrypt.tables.ARCHIVE_INFOR_NZ11.columns.MIL_REST_DETAIL_ADDR_RESET_PLACE.cipher-column=MIL_REST_DETAIL_ADDR_RESET_PLACE
spring.shardingsphere.rules.encrypt.tables.ARCHIVE_INFOR_NZ11.columns.MIL_REST_DETAIL_ADDR_RESET_PLACE.encryptor-name=name_encryptor
spring.shardingsphere.rules.encrypt.tables.ARCHIVE_INFOR_NZ11.columns.MIL_REST_RESET_MANA_UNIT_NAME.cipher-column=MIL_REST_RESET_MANA_UNIT_NAME
spring.shardingsphere.rules.encrypt.tables.ARCHIVE_INFOR_NZ11.columns.MIL_REST_RESET_MANA_UNIT_NAME.encryptor-name=name_encryptor
spring.shardingsphere.rules.encrypt.tables.ARCHIVE_INFOR_NZ11.columns.MIL_REST_RESET_MANA_UNIT_NATURE.cipher-column=MIL_REST_RESET_MANA_UNIT_NATURE
spring.shardingsphere.rules.encrypt.tables.ARCHIVE_INFOR_NZ11.columns.MIL_REST_RESET_MANA_UNIT_NATURE.encryptor-name=name_encryptor
spring.shardingsphere.rules.encrypt.tables.ARCHIVE_INFOR_NZ11.columns.MIL_REST_SER_MANA_ORGAN_NAME.cipher-column=MIL_REST_SER_MANA_ORGAN_NAME
spring.shardingsphere.rules.encrypt.tables.ARCHIVE_INFOR_NZ11.columns.MIL_REST_SER_MANA_ORGAN_NAME.encryptor-name=name_encryptor
spring.shardingsphere.rules.encrypt.tables.ARCHIVE_INFOR_NZ11.columns.RETIR_RESET_TIME.cipher-column=RETIR_RESET_TIME
spring.shardingsphere.rules.encrypt.tables.ARCHIVE_INFOR_NZ11.columns.RETIR_RESET_TIME.encryptor-name=name_encryptor
spring.shardingsphere.rules.encrypt.tables.ARCHIVE_INFOR_NZ11.columns.RETIR_ADM_DIVI_RESET_PLACES.cipher-column=RETIR_ADM_DIVI_RESET_PLACES
spring.shardingsphere.rules.encrypt.tables.ARCHIVE_INFOR_NZ11.columns.RETIR_ADM_DIVI_RESET_PLACES.encryptor-name=name_encryptor
spring.shardingsphere.rules.encrypt.tables.ARCHIVE_INFOR_NZ11.columns.RETIR_DETAIL_ADDR_RESET_PLACE.cipher-column=RETIR_DETAIL_ADDR_RESET_PLACE
spring.shardingsphere.rules.encrypt.tables.ARCHIVE_INFOR_NZ11.columns.RETIR_DETAIL_ADDR_RESET_PLACE.encryptor-name=name_encryptor
spring.shardingsphere.rules.encrypt.tables.ARCHIVE_INFOR_NZ11.columns.RETIR_RESET_UNIT_NAME.cipher-column=RETIR_RESET_UNIT_NAME
spring.shardingsphere.rules.encrypt.tables.ARCHIVE_INFOR_NZ11.columns.RETIR_RESET_UNIT_NAME.encryptor-name=name_encryptor
spring.shardingsphere.rules.encrypt.tables.ARCHIVE_INFOR_NZ11.columns.RETIR_RESET_UNIT_NATURE.cipher-column=RETIR_RESET_UNIT_NATURE
spring.shardingsphere.rules.encrypt.tables.ARCHIVE_INFOR_NZ11.columns.RETIR_RESET_UNIT_NATURE.encryptor-name=name_encryptor
spring.shardingsphere.rules.encrypt.tables.ARCHIVE_INFOR_NZ11.columns.RETIR_RESET_POS_RAN.cipher-column=RETIR_RESET_POS_RAN
spring.shardingsphere.rules.encrypt.tables.ARCHIVE_INFOR_NZ11.columns.RETIR_RESET_POS_RAN.encryptor-name=name_encryptor
spring.shardingsphere.props.query-with-cipher-column=false
spring.shardingsphere.props.sql-show=true
```
#### Test project for this issue
If test project can help. I can put its link at here.
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: notifications-unsubscribe@shardingsphere.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [shardingsphere] nanzheng commented on issue #11074: Oracle Insert statement Parse SQL ERROR!Please Help!
Posted by GitBox <gi...@apache.org>.
nanzheng commented on issue #11074:
URL: https://github.com/apache/shardingsphere/issues/11074#issuecomment-872085163
> hi, "RANK" is keyword, try to escape.
I try 4.0.1 it can success insert to the target table. So your point is not the right answer.
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: notifications-unsubscribe@shardingsphere.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [shardingsphere] tuichenchuxin commented on issue #11074: Oracle Insert statement Parse SQL ERROR!Please Help!
Posted by GitBox <gi...@apache.org>.
tuichenchuxin commented on issue #11074:
URL: https://github.com/apache/shardingsphere/issues/11074#issuecomment-873743774
I want to fix it, may I?
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: notifications-unsubscribe@shardingsphere.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [shardingsphere] strongduanmu closed issue #11074: Oracle Insert statement Parse SQL ERROR!Please Help!
Posted by GitBox <gi...@apache.org>.
strongduanmu closed issue #11074:
URL: https://github.com/apache/shardingsphere/issues/11074
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: notifications-unsubscribe@shardingsphere.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [shardingsphere] strongduanmu commented on issue #11074: Oracle Insert statement Parse SQL ERROR!Please Help!
Posted by GitBox <gi...@apache.org>.
strongduanmu commented on issue #11074:
URL: https://github.com/apache/shardingsphere/issues/11074#issuecomment-873759602
> I want to fix it, may I?
@tuichenchuxin Welcome to join in SS community.
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: notifications-unsubscribe@shardingsphere.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [shardingsphere] nanzheng commented on issue #11074: Oracle Insert statement Parse SQL ERROR!Please Help!
Posted by GitBox <gi...@apache.org>.
nanzheng commented on issue #11074:
URL: https://github.com/apache/shardingsphere/issues/11074#issuecomment-871278685
Debug step into the code, there is a try catch code block will throw org.antlr.v4.runtime.NoViableAltException.
At getInterpreter().adaptivePredict(_input,0,_ctx) this step. @tristaZero
```
OracleStatementParser.java
public final ExecuteContext execute() throws RecognitionException {
ExecuteContext _localctx = new ExecuteContext(_ctx, getState());
enterRule(_localctx, 0, RULE_execute);
int _la;
try {
enterOuterAlt(_localctx, 1);
{
setState(1443);
_errHandler.sync(this);
switch ( getInterpreter().adaptivePredict(_input,0,_ctx) ) {
case 1:
{
setState(1412);
select();
}
break;
case 2:
```
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: notifications-unsubscribe@shardingsphere.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [shardingsphere] avalon5666 commented on issue #11074: Oracle Insert statement Parse SQL ERROR!Please Help!
Posted by GitBox <gi...@apache.org>.
avalon5666 commented on issue #11074:
URL: https://github.com/apache/shardingsphere/issues/11074#issuecomment-871403201
hi, "RANK" is keyword, try to escape.
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: notifications-unsubscribe@shardingsphere.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [shardingsphere] nanzheng commented on issue #11074: Oracle Insert statement Parse SQL ERROR!Please Help!
Posted by GitBox <gi...@apache.org>.
nanzheng commented on issue #11074:
URL: https://github.com/apache/shardingsphere/issues/11074#issuecomment-872686612
> This is a quick fix.
> We will check again, thx.
We will discuss this issue at the meeting on July 16th.
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: notifications-unsubscribe@shardingsphere.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [shardingsphere] nanzheng commented on issue #11074: Oracle Insert statement Parse SQL ERROR!Please Help!
Posted by GitBox <gi...@apache.org>.
nanzheng commented on issue #11074:
URL: https://github.com/apache/shardingsphere/issues/11074#issuecomment-872686281
> This is a quick fix.
> We will check again, thx.
`project: OSD2021`
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: notifications-unsubscribe@shardingsphere.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [shardingsphere] strongduanmu closed issue #11074: Oracle Insert statement Parse SQL ERROR!Please Help!
Posted by GitBox <gi...@apache.org>.
strongduanmu closed issue #11074:
URL: https://github.com/apache/shardingsphere/issues/11074
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: notifications-unsubscribe@shardingsphere.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [shardingsphere] avalon5666 commented on issue #11074: Oracle Insert statement Parse SQL ERROR!Please Help!
Posted by GitBox <gi...@apache.org>.
avalon5666 commented on issue #11074:
URL: https://github.com/apache/shardingsphere/issues/11074#issuecomment-872089334
This is a quick fix.
We will check again, thx.
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: notifications-unsubscribe@shardingsphere.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org