Oracle function similar to the LIKE condition, but REGEXP_LIKE performs regular expression pattern matching. See also REGEXP_INSTR, REGEXP_REPLACE, REGEXP_SUBSTR and REGEXP_COUNT for other functions extended to use regular expressions.
Questions tagged [regexp-like]
199 questions
0
votes
2 answers
Regex pattern doesn't work with MySQL regexp
I do have the below regex that works fine with Regex tester (thanks to horcrux). However, it returns no matches when I use it with MySQL regexp
select query from search s where s.query regexp…
zoro74
- 171
- 15
0
votes
1 answer
Oracle REGEXP_LIKE function - what is this matching?
I'm looking at someone else's code which I do not have the option of running and can't figure out what the following REGEXP_LIKE is trying to match. Any help would be appreciated.
REGEXP_LIKE('field_name', '^(ABC:)?Z[DEF]')
What I think is…
Amy
- 591
- 3
- 10
- 23
0
votes
1 answer
REGEXP Pattern matching
I want to do the regexpr pattern matching and I couldn't. Please help.
I want to evaluate the value that is going to be inserted in DB. I want to perform a check as below.
Only four special characters and alphabeticals are allowed. other special…
CHANDRU S
- 147
- 2
- 13
0
votes
2 answers
Returning rows with comma-separated values by pattern (Oracle SQL)
I have some field with comma-separated values:
1,2,AA,4,Z
1,ZZ,44,A,1
1,44,33,AA,Z
4,2,Z,A,F
1.2,4,E,1,1
F,1,3.4,3,A
Is it possible to select rows with rule: number,number,chars, anything_values?
Result can be:…
Ivan Ivanov
- 515
- 1
- 5
- 20
0
votes
2 answers
Oracle SQL regexp_like by unicode types
Let's say I have a pattern in unicode types (or Unicode Categories, according to https://www.regular-expressions.info/unicode.html)
LLLLZLLLZLLLL
NNNN
I'm trying to write a sql query, selecting entries in the column which corresponds exactly to the…
Max
- 5
- 6
0
votes
1 answer
Oracle regexp_like failing on FLOAT from view
I'm trying to use regexp_like to find and remove overly-precise floating point numbers.
select c from t order by c asc;
returns many results like this: 0.0000000012345678
Using regexp_like I can get results for two decimal places (0.25):
select *…
mrcrag
- 310
- 3
- 16
0
votes
3 answers
Special character Oracle REGEXP
I need to allow only set of characters i.e.,
a to z A to Z 0 to 9 . !@#$% *()_=+|[]{}"'';:?/.,-
but When I add dash(-) character to below query it is not working please help me at earliest.
SELECT :p_string FROM dual
WHERE NOT REGEXP_LIKE…
Arun GoWdA
- 23
- 6
0
votes
3 answers
Using REGEXP_LIKE in Oracle
In the MyTable table, I have the following data in the MyField column whose size is 80 characters:
MyField
-------
WA
W
W51534
W
W
I am trying to exclude lines starting with WA through regexp_like. But the following query returns the W51534 line…
Tony92
- 91
- 7
0
votes
1 answer
REGEXP_LIKE QUERY IN ORACLE DB
I need to currently match 00000012345 and 12345 in my DB search query.
I am currently using following query:
SELECT *
FROM BPP.CHECK_REGISTER
WHERE CHECK_NO like CONCAT('%',:checkNum)
for searching but here % can mean any character other than 0…
0
votes
1 answer
Need Regular expression to match exact table name in source code in Oracle 12cR1
I am using Oracle 12cR1. I need a REGEX pattern to exactly match a given table name from Oracle source code (i.e) the match must not be preceded or succeeded by a number or an alphabet or an underscore symbol.
I have created a dummy source code and…
ArtBajji
- 949
- 6
- 14
0
votes
1 answer
How to handle oracle regexp_like in ssis expressions
I am using ssis for fetching data from oracle.(oracle source component)
in my query i use regexp_like(clmn,'^-?\d+.\d+)?$'). but ssis cannot evaluate this query(expression). when i remove a part of query that uses this regexp_like, ssis can evaluate…
user2352554
- 521
- 4
- 17
0
votes
0 answers
SQL Query Fails for some records
I'm running a query where I'm selecting records that contain a word in a VarChar2(4000) field. The query works but only for some dates and not others.
I've tried REGEXP_LIKE and INSTR. I've tried it in SQL Developer and ACCESS and I get the same…
LifHkr
- 35
- 5
0
votes
1 answer
SQL Constraint for Canada Postal Code + US Zip Code?
I've created a constraint for Canadian postal code and it works fine, however when I input a US zip code like 1234567, the record still gets added in. I'm looking for a way to change my constraint so it only accepts 5 numbers ?
Postal_Code…
Hector Morson
- 23
- 4
0
votes
1 answer
Regexp Meta Description
When i use this regex on https://regex101.com (]*description[^>]([^<]+)>) its run.
Match 1
Full match 265-314 ``
Group 1. 265-314 ``
Group…
B. Mert
- 19
- 5
0
votes
1 answer
jpa native Query regexp like with querydsl
I have i query statement like this:
select t.*
from T_ex_table t
where regexp_like(t.note,
'^(.*[^[:digit:]]+)?([condition])([^[:digit:]]+.*)?$',
'n')
And if I use it in jpa with querydsl(com.querydsl)…
xmcx
- 283
- 3
- 18