oracle迁移到达梦8,Oracle的SC_ENTITY_SC_RE_UUID_Seq.nextval换到达梦是什么
insert into DW_EVENTCENTER.SC_ENTITY_SC_RE(UUID,ENTY_TYPE, ENTITY_ID, SCENE_ID, SCENE_NAME, ENTY_NAME )
select SC_ENTITY_SC_RE_UUID_Seq.nextval,‘2’,ENTITY_ID,‘01’,‘餐饮’,JYZMC from QZGX_QX_2018.QZ_APPR_LICENCE_ET@TOQZGX_QX_2018 APPR where APPR.ZSZL =‘00103’ AND LENgth(ENTITY_ID)=12
and ZTYT in(‘2’,‘3’) and XKZZT=‘1’ and yxx = ‘1’;