直接使用sys_guid()返回乱码问题

oracle sys_uuid 乱码

SELECT DISTINCT FAB, PRODUCT_ID, PARAMETER_NAME, PARAMETER_MAPPING, LIMIT_FILE, TEST_PROGRAM, TRIM(REGEXP_SUBSTR(STAGE, '[^锛汸]+', 1, LEVEL)) AS STAGE_true FROM DRB_PARAMETER_MAPPING CONNECT BY LEVEL <= REGEXP_COUNT(STAGE, '锛汸') + 1 AND PRIOR SYS_GUID() IS NOT NULL

SELECT DISTINCT FAB, PRODUCT_ID, PARAMETER_NAME, PARAMETER_MAPPING, LIMIT_FILE, TEST_PROGRAM, TRIM(REGEXP_SUBSTR(STAGE, '[^锛汸]+', 1, LEVEL)) AS STAGE_true FROM DRB_PARAMETER_MAPPING CONNECT BY LEVEL <= REGEXP_COUNT(STAGE, '锛汸') + 1 AND PRIOR PRODUCT_ID = PRODUCT_ID AND PRIOR SYS_GUID() IS NOT NULL 优化这段sql

SELECT DISTINCT PRODUCT_ID, REGEXP_SUBSTR(STAGE, ‘锛汸+’, 1, LEVEL) AS STAGE FROM DRB_PARAMETER_MAPPING CONNECT BY LEVEL <= REGEXP_COUNT(STAGE, ‘锛汸’) + 1 AND PRIOR PRODUCT_ID = PRODUCT_ID AND PRIOR SYS_GUID() IS NOT NULL AND PRIOR DBMS_RANDOM.VALUE IS NOT NULL 执行结果为0668A WF_START 0668A ADSIN_DEP 0668A ADOX_OX length（stage）=28 SELECT DISTINCT PRODUCT_ID,STAGE FROM DRB_INFO_CONFIG dic WHERE STATUS = ‘0’ 执行结果为0668A WF_START length（stage）=8 为什么SELECT * FROM ( SELECT DISTINCT PRODUCT_ID, REGEXP_SUBSTR(STAGE, ‘锛汸+’, 1, LEVEL) AS STAGE FROM DRB_PARAMETER_MAPPING CONNECT BY LEVEL <= REGEXP_COUNT(STAGE, ‘锛汸’) + 1 AND PRIOR PRODUCT_ID = PRODUCT_ID AND PRIOR SYS_GUID() IS NOT NULL AND PRIOR DBMS_RANDOM.VALUE IS NOT NULL ) WHERE (PRODUCT_ID, STAGE) IN (SELECT DISTINCT PRODUCT_ID,STAGE FROM DRB_INFO_CONFIG dic WHERE STATUS = ‘0’) ;如何修改

SELECT * FROM ( SELECT DISTINCT FAB, PRODUCT_ID, PARAMETER_NAME, PARAMETER_MAPPING, LIMIT_FILE, TEST_PROGRAM, TRIM(REGEXP_SUBSTR(STAGE, '[^锛汸]+', 1, LEVEL)) AS STAGE_true FROM DRB_PARAMETER_MAPPING CONNECT BY LEVEL <= REGEXP_COUNT(STAGE, '锛汸') + 1 AND PRIOR PRODUCT_ID = PRODUCT_ID AND PRIOR SYS_GUID() IS NOT NULL AND PRIOR DBMS_RANDOM.VALUE IS NOT NULL ) join (SELECT DISTINCT PRODUCT_ID,trim(STAGE) FROM DRB_INFO_CONFIG dic WHERE STATUS = '0') ;