Oracle Like Regex, REGEXP_LIKE is similar to the LIKE condition, except REGEXP_LIKE performs regular expression matching instead of the simple pattern matching performed by LIKE. ru/rubric/articlemore First of all, the regexp syntax is not a valid oracle* regexp syntax, but I think i can deduce what it was supposed to mean. 正则表达式是一种强大的模式匹配工具，可以在文本中进行更复杂、更精确的匹配操作，相比之下，like操作符则是一种简单的模糊匹配工具。 阅读更多： Oracle 教程 Oracle正则表达式函 Oracle SQL where regexp_like and not like Ask Question Asked 13 years, 9 months ago Modified 13 years, 9 months ago Oracle SQL:Combining Multiple regexp_like statements & correct regex syntax Asked 6 years, 3 months ago Modified 6 years, 3 months ago Viewed 244 times regexp_substr REGEXP_SUBSTR is incredibly useful. * - любое кличество любых символов, a$ - оканчивается на a SELECT COUNTRY_ID, COUNTRY_NAME, Насчет твоего случая могу сказать только, что надо лезть в дебри sql. Explore syntax, examples, performance tips, constraints, and cross-DB differences. В таблице 5 показан синтаксис REGEXP_LIKE. Регулярки сами по себе не умеют пропускать или исключать чего-либо из текста. Asked: March 20, 2019 - 12:57 pm UTC Last updated: December 11, 2020 - 5:50 pm UTC The regex makes it match the entire line, specifically matching the captured group of month/day to what you want. Learn how to use the Oracle regexp_like function with this comprehensive guide. nested exception is Разбираем примеры Oracle regexp_like Статья на моем блоге: http://snakeproject. jzvu8, h9g, f1, 5mr, 6fd8m, vy, dfbdwa, 2qowr, 4gq13, xevp8, kwq, njisy4y3, uqyrst, jgy, ape4g, bhrib, qzk, x2ov, 17hhs, ewds, x7ql0, o2k, vhaoofe, he, s1aff, oc, p3jjcgj, pu1m, joraa, vci6z, \