在Oracle中需要[ICC]之后的空间

Question

Column_name
[ICCS]C54CNWHPEGNPY2V
[ICCS]C6D4007RP26DM3K

行数据

row 1 data - [ICCS]C54CNWHPEGNPY2V
row 2 data -[ICCS]C6D4007RP26DM3K

Answer 1

这将有所帮助：

select REPLACE('[ICCS]C54CNWHPEGNPY2V','[ICCS]','[ICCS] ') from dual;
select REPLACE(column_name,'[ICCS]','[ICCS] ') from table_name;

建议更新：

UPDATE dbo.KRM_CYCLE_DAY_ONE_DIFFERENCE KRM
   SET KRM.transaction_no =
          (REPLACE (KRM.TRANSACTION_NO, '[ICCS]', '[ICCS] '))
 WHERE EXISTS
          (SELECT 1
             FROM dbo.TEMP_CARD_NO T
            WHERE     KRM.transaction_no = '[ICCS]' || T.TRANSACTION_NO_NEW
                  AND SUBSTR (KRM.transaction_no, 1, 6) = '[ICCS]')