Top "Regexp-like" questions

Oracle function similar to the LIKE condition, but REGEXP_LIKE performs regular expression pattern matching.

Query the list of CITY names starting with vowels (i.e., a, e, i, o, or u) from STATION

Query the list of CITY names starting with vowels (i.e., a, e, i, o, or u) from STATION. My …

Read More
sql regex oracle regexp-like
Oracle Regular Expression to match US Phone Number Format

Oracle Regular Expression To match US Phone Number in the following formats only. (NNN) NNN-NNNN or NNN-NNN-NNNN or NNNNNNNNNN I …

Read More
regex oracle regexp-like
Oracle: to_number() combined with substr() and regexp_like() in WHERE clause

I have a table with a column "description" which has the following values: OPTestMachine OPManualTesting OP1010 So the select statement, …

Read More
sql oracle substr regexp-like