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: [email protected]
For queries about this service, please contact Infrastructure at:
[email protected]
