oracle 中 用什么 替换 mysql中 regexp 表达式

Question

大神帮忙改下regexp  
select azb080, azb081, aae036
  from sc74
 where BSC010 regexp 'acd916c644b8873e|4906b0cbe03356ce|5f6d94de0ba18c00|bf53d6199d7e761a|de942380bf7cb0ba|11acf6984209beb0|8b3400f9f24798f1|56e1b6c46124eedb|efdc24542b4b902b|c0521084fc2bb868|4d1483476c55d05e|da0e1e442ab39a04|d22d9d4b431cab53|1d0674f0ba71e72f|5cb7cd2534bd2859|99cadf4fb3010b7f|f44f0a4bae9660e4|d69bff43f7b65567|bcec4c8cbb49c0c2|8010d9442eb6a49f|d22d9d4b431cab53|d50b1595a431d810|1d0674f0ba71e72f|4d4d4a8437cc151c|9d6fb466b3c2259f|1650|36d1914d0baf8a28|0aeb69f8c54ea35a|d50b1595a431d810|e91c420c4cea97f5|bafe3dc647edbbe7|0547a0abd37211d3|99cadf4fb3010b7f|da0e1e442ab39a04|56e1b6c46124eedb|1a0ea1f479ee802c|bafe3dc647edbbe7|75157862644aaa84|4d1483476c55d05e|4d4d4a8437cc151c|e91c420c4cea97f5|22464680af823bd0|75157862644aaa84|a35bed1348f29773|1a0ea1f479ee802c|0aeb69f8c54ea35a|acd916c644b8873e|5f6d94de0ba18c00|89e425391e2e2865|bcec4c8cbb49c0c2|0c1472ba1d648604|5cb7cd2534bd2859|8b815abfef970968|11acf6984209beb0|9d6fb466b3c2259f|1650|a68381d1efdf9e20|e30ec26940eeaf6e|aaad1e7d9bb295bd|94ad474d581208a8|de942380bf7cb0ba|94ad474d581208a8|aaad1e7d9bb295bd|89e425391e2e2865|6cd40343b945b7a1|80b81fdf3ad1ed0d|c0521084fc2bb868|80b81fdf3ad1ed0d|bf53d6199d7e761a|8b3400f9f24798f1|efdc24542b4b902b|8b815abfef970968|e30ec26940eeaf6e|d69bff43f7b65567|f44f0a4bae9660e4|4906b0cbe03356ce|9fd5164101bac417|8010d9442eb6a49f|9fd5164101bac417|a68381d1efdf9e20|a35bed1348f29773|22464680af823bd0'
   and bae512 = '1'
   and to_char(SYSDATE, 'yyyy-MM-dd') >= azb086
   and to_char(SYSDATE, 'yyyy-MM-dd') <= azb087
 ORDER BY aae036 DESC    

Answer 1

select azb080, azb081, aae036
  from sc74
 where BSC010 in ('acd916c644b8873e','4906b0cbe03356ce','5f6d94de0ba18c00','bf53d6199d7e761a','de942380bf7cb0ba','11acf6984209beb0','8b3400f9f24798f1','56e1b6c46124eedb','efdc24542b4b902b','c0521084fc2bb868','4d1483476c55d05e','da0e1e442ab39a04','d22d9d4b431cab53','1d0674f0ba71e72f','5cb7cd2534bd2859','99cadf4fb3010b7f','f44f0a4bae9660e4','d69bff43f7b65567','bcec4c8cbb49c0c2','8010d9442eb6a49f','d22d9d4b431cab53','d50b1595a431d810','1d0674f0ba71e72f','4d4d4a8437cc151c','9d6fb466b3c2259f','1650','36d1914d0baf8a28','0aeb69f8c54ea35a','d50b1595a431d810','e91c420c4cea97f5','bafe3dc647edbbe7','0547a0abd37211d3','99cadf4fb3010b7f','da0e1e442ab39a04','56e1b6c46124eedb','1a0ea1f479ee802c','bafe3dc647edbbe7','75157862644aaa84','4d1483476c55d05e','4d4d4a8437cc151c','e91c420c4cea97f5','22464680af823bd0','75157862644aaa84','a35bed1348f29773','1a0ea1f479ee802c','0aeb69f8c54ea35a','acd916c644b8873e','5f6d94de0ba18c00','89e425391e2e2865','bcec4c8cbb49c0c2','0c1472ba1d648604','5cb7cd2534bd2859','8b815abfef970968','11acf6984209beb0','9d6fb466b3c2259f','1650','a68381d1efdf9e20','e30ec26940eeaf6e','aaad1e7d9bb295bd','94ad474d581208a8','de942380bf7cb0ba','94ad474d581208a8','aaad1e7d9bb295bd','89e425391e2e2865','6cd40343b945b7a1','80b81fdf3ad1ed0d','c0521084fc2bb868','80b81fdf3ad1ed0d','bf53d6199d7e761a','8b3400f9f24798f1','efdc24542b4b902b','8b815abfef970968','e30ec26940eeaf6e','d69bff43f7b65567','f44f0a4bae9660e4','4906b0cbe03356ce','9fd5164101bac417','8010d9442eb6a49f','9fd5164101bac417','a68381d1efdf9e20','a35bed1348f29773','22464680af823bd0')
   and bae512 = '1'
   and to_char(SYSDATE, 'yyyy-MM-dd') >= azb086
   and to_char(SYSDATE, 'yyyy-MM-dd') <= azb087
 ORDER BY aae036 DESC
 
--OR  select azb080, azb081, aae036
  from sc74
 where 'acd916c644b8873e|4906b0cbe03356ce|5f6d94de0ba18c00|bf53d6199d7e761a|de942380bf7cb0ba|11acf6984209beb0|8b3400f9f24798f1|56e1b6c46124eedb|efdc24542b4b902b|c0521084fc2bb868|4d1483476c55d05e|da0e1e442ab39a04|d22d9d4b431cab53|1d0674f0ba71e72f|5cb7cd2534bd2859|99cadf4fb3010b7f|f44f0a4bae9660e4|d69bff43f7b65567|bcec4c8cbb49c0c2|8010d9442eb6a49f|d22d9d4b431cab53|d50b1595a431d810|1d0674f0ba71e72f|4d4d4a8437cc151c|9d6fb466b3c2259f|1650|36d1914d0baf8a28|0aeb69f8c54ea35a|d50b1595a431d810|e91c420c4cea97f5|bafe3dc647edbbe7|0547a0abd37211d3|99cadf4fb3010b7f|da0e1e442ab39a04|56e1b6c46124eedb|1a0ea1f479ee802c|bafe3dc647edbbe7|75157862644aaa84|4d1483476c55d05e|4d4d4a8437cc151c|e91c420c4cea97f5|22464680af823bd0|75157862644aaa84|a35bed1348f29773|1a0ea1f479ee802c|0aeb69f8c54ea35a|acd916c644b8873e|5f6d94de0ba18c00|89e425391e2e2865|bcec4c8cbb49c0c2|0c1472ba1d648604|5cb7cd2534bd2859|8b815abfef970968|11acf6984209beb0|9d6fb466b3c2259f|1650|a68381d1efdf9e20|e30ec26940eeaf6e|aaad1e7d9bb295bd|94ad474d581208a8|de942380bf7cb0ba|94ad474d581208a8|aaad1e7d9bb295bd|89e425391e2e2865|6cd40343b945b7a1|80b81fdf3ad1ed0d|c0521084fc2bb868|80b81fdf3ad1ed0d|bf53d6199d7e761a|8b3400f9f24798f1|efdc24542b4b902b|8b815abfef970968|e30ec26940eeaf6e|d69bff43f7b65567|f44f0a4bae9660e4|4906b0cbe03356ce|9fd5164101bac417|8010d9442eb6a49f|9fd5164101bac417|a68381d1efdf9e20|a35bed1348f29773|22464680af823bd0' like '%'||BSC010||'%'
   and bae512 = '1'
   and to_char(SYSDATE, 'yyyy-MM-dd') >= azb086
   and to_char(SYSDATE, 'yyyy-MM-dd') <= azb087
 ORDER BY aae036 DESC

Answer 2

可以用in()
SELECT AZB080, AZB081, AAE036
  FROM SC74
 WHERE BSC010 IN
       'acd916c644b8873e,4906b0cbe03356ce,5f6d94de0ba18c00,bf53d6199d7e761a,de942380bf7cb0ba,11acf6984209beb0,8b3400f9f24798f1,56e1b6c46124eedb,efdc24542b4b902b,c0521084fc2bb868,4d1483476c55d05e,da0e1e442ab39a04,d22d9d4b431cab53,1d0674f0ba71e72f,5cb7cd2534bd2859,99cadf4fb3010b7f,f44f0a4bae9660e4,d69bff43f7b65567,bcec4c8cbb49c0c2,8010d9442eb6a49f,d22d9d4b431cab53,d50b1595a431d810,1d0674f0ba71e72f,4d4d4a8437cc151c,9d6fb466b3c2259f,1650,36d1914d0baf8a28,0aeb69f8c54ea35a,d50b1595a431d810,e91c420c4cea97f5,bafe3dc647edbbe7,0547a0abd37211d3,99cadf4fb3010b7f,da0e1e442ab39a04,56e1b6c46124eedb,1a0ea1f479ee802c,bafe3dc647edbbe7,75157862644aaa84,4d1483476c55d05e,4d4d4a8437cc151c,e91c420c4cea97f5,22464680af823bd0,75157862644aaa84,a35bed1348f29773,1a0ea1f479ee802c,0aeb69f8c54ea35a,acd916c644b8873e,5f6d94de0ba18c00,89e425391e2e2865,bcec4c8cbb49c0c2,0c1472ba1d648604,5cb7cd2534bd2859,8b815abfef970968,11acf6984209beb0,9d6fb466b3c2259f,1650,a68381d1efdf9e20,e30ec26940eeaf6e,aaad1e7d9bb295bd,94ad474d581208a8,de942380bf7cb0ba,94ad474d581208a8,aaad1e7d9bb295bd,89e425391e2e2865,6cd40343b945b7a1,80b81fdf3ad1ed0d,c0521084fc2bb868,80b81fdf3ad1ed0d,bf53d6199d7e761a,8b3400f9f24798f1,efdc24542b4b902b,8b815abfef970968,e30ec26940eeaf6e,d69bff43f7b65567,f44f0a4bae9660e4,4906b0cbe03356ce,9fd5164101bac417,8010d9442eb6a49f,9fd5164101bac417,a68381d1efdf9e20,a35bed1348f29773,22464680af823bd0'
   AND BAE512 = '1'
   AND TO_CHAR(SYSDATE, 'yyyy-MM-dd') >= AZB086
   AND TO_CHAR(SYSDATE, 'yyyy-MM-dd') <= AZB087
 ORDER BY AAE036 DESC;