Match the rules of mobile phone numbers in mainland China according to the requirements
--1 Table Preparation
CREATE TABLE Test_regexp
(
Object Varchar2 (50)
);
--2 Data Preparation
Insert into Test_regexp (OBJECT)
VALUES (' 18710128107 ');
Insert into Test_regexp (OBJECT)
VALUES (' 1871012810 ');
Insert into Test_regexp (OBJECT)
VALUES (' 1871012819h ');
Insert into Test_regexp (OBJECT)
VALUES (' 187a0128107 ');
Insert into Test_regexp (OBJECT)
VALUES (' 12311111111 ');
Insert into Test_regexp (OBJECT)
VALUES (' 13800000000 ');
Insert into Test_regexp (OBJECT)
VALUES (' 17011111111 ');
Insert into Test_regexp (OBJECT)
VALUES (' 15211111111 ');
Insert into Test_regexp (OBJECT)
VALUES (' 23452124531 ');
--3 SQL
SELECT * from Test_regexp where Regexp_like (object, ' ^1[3578]\d{9}$ ');
--4 return Results
18710128107
13800000000
17011111111
15211111111
Oracle's regular application matches the phone number