donderdag 25 april 2013

Oracle: Regular Expressions in Like

When you want to use regular expressions in the like part of the query in Oracle, use:

SELECT count(*) FROM TABLE WHERE REGEXP_LIKE(COLUMN, '^[0123456789].*$')
Notice that you cannot use '%' any more.

Geen opmerkingen:

Een reactie posten