By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
WITH yourTable AS (
SELECT 'http://example.com/blah_blah/' AS url FROM dual UNION ALL
SELECT 'http://test.com' FROM dual
)
SELECT *
FROM yourTable
WHERE REGEXP_LIKE(url, '^(https?|ftp)://[^[:space:]/$.?#]+\.[^[:space:]]*$', 'i');
| URL |
|---|
| http://example.com/blah_blah/ |
| http://test.com |