Oracle Regular expression function-regexp_like use example

The original in this poke

Regexp_like

3 parameters

The first one is the string entered

The second one is the regular expression

The third is the range of values:

I: case is not sensitive;

C: Case sensitive;

N: Point number. Do not match line break symbols;

M: multi-line mode;

X: Extended mode, ignoring white-space characters in regular expressions.

All test data

Sql> SELECT * from Test_reg_like;

A

----------------------------------------

Abc

A12

12a12

Match Letter A of the

Sql> SELECT

2 *

3 from

4 Test_reg_like

5 WHERE

6 Regexp_like (A, ' a ');

A

----------------------------------------

Abc

A12

Match Letter A of the (not case sensitive)

Sql> SELECT

2 *

3 from

4 Test_reg_like

5 WHERE

6 Regexp_like (A, ' a ', ' I ');

A

----------------------------------------

Abc

A12

12a12

Match Letter A back with 1 . One or more numbers. (not case sensitive)

Sql> SELECT

2 *

3 from

4 Test_reg_like

5 WHERE

6 Regexp_like (A, ' a\d+ ', ' I ');

A

----------------------------------------

A12

12a12

Match Letter A the beginning, the number ending

Sql> SELECT

2 *

3 from

4 Test_reg_like

5 WHERE

6 Regexp_like (A, ' ^a.+\d$ ');

A

----------------------------------------

A12

Oracle Regular expression function-regexp_like use example