Matching URLs for Oracle regular expressions

Facilitates regular expression matching out URLs

--1 Table Preparation
CREATE TABLE Test_regexp
(
Object Varchar2 (50)
);

--2 Data Preparation

Insert into Test_regexp (OBJECT)
VALUES (' http://www.baidu.com ');

Insert into Test_regexp (OBJECT)
VALUES (' http://360.cn ');

Insert into Test_regexp (OBJECT)
VALUES (' https://help.alipay.com ');

Insert into Test_regexp (OBJECT)
VALUES (' cctv.cn ');

Insert into Test_regexp (OBJECT)
VALUES (' www.cntv.com ');

Insert into Test_regexp (OBJECT)
VALUES (' 23212.sasdas.2222 ');

Commit

--3

SELECT * from Test_regexp where Regexp_like (object, ' ^ (https?:/ /)? (\w+\.) +[a-za-z]+$ ');

--4 return Results

Http://www.baidu.com
http://360.cn
Https://help.alipay.com
cctv.cn
Www.cntv.com
23212.sasdas.2222

Matching URLs for Oracle regular expressions