14 дек. 2021 г. · I want to extract 2 parts of certain string. For this I want to use regular expressions. For Example the String is: Big_Dog_0044_0080 and my ...

21 сент. 2021 г. · You can use regexp_substr() . For the third string: select regexp_substr(notes, '[^ ]+', 1, 3) from prod.client;. Here is a db<>fiddle.

23 мар. 2018 г. · I have a varchar2(6) column, so it can hold anything. I'm trying to make a regexp to find the value that have numbers and commas. Anywhere.

8 авг. 2021 г. · Я вот тоже не понимаю почему Oracle решил ограничиться поддержкой POSIX RegEx, вместо расширенного, ставшего уже де-факто стандартным... – MaxU ...

27 сент. 2021 г. · You should be able to use the following REGEXP_LIKE to validate your inputs: REGEXP_LIKE(td.text_value, '^[A-Z][0-9]{8}$').

3 нояб. 2022 г. · I am using Regex Substring to filter out values that have 'p' in the start and ends before '-'. p is followed by 6 digits.

4 дек. 2018 г. · I need to allow only set of characters ie, a to z A to Z 0 to 9 . !@#$% *()_=+|[]{}"'';:?/.,- but When I add dash(-) character to below

12 июл. 2021 г. · You do not need regular expressions, you can do it using simple (and faster) string functions ( INSTR and SUBSTR ) in a recursive sub-query ...

1 янв. 2021 г. · Create an Oracle regular expression to check whether the given string contains both number and alphabet and does not contain special character.

30 июн. 2021 г. · I'm testing oracle REGEXP_SUBSTR function and regexp that works in Python or Axtarish testing tools like https://regex101.com/ doesn't work with Oracle.