Question

Oracle SQL 正则表达式求助

Answer 1

SELECT city_code FROM A

WHERE REGEXP_LIKE(city_code, 'd+')

AND

city_code '5Y44' AND city_code '0HJ7'

UNION

SELECT city_code FROM A

WHERE city_code = 'PLT'