declare
  p_value varchar2(200) := 'Alexander.Kochnev@yandex.com, Alexander.Kochnev http://privet.ru/ mail.ru gov.cont.ru';

  p_mail varchar2(100) := '[A-Z0-9._%-]+@[A-Z0-9._%-]+\.[A-Z]{2,6}';
  p_url  varchar2(100) := '((https?|ftp)://)?(www\.)?([a-z0-9_-]+\.)+[a-z]{2,6}(/[a-z0-9_-]+)*';
begin
  for cur in (select regexp_substr(n'' || p_value, '(' || p_mail || '|' || p_url || ')+', 1, level, 'i') web_value
                from dual
               where regexp_substr(n'' || p_value, '(' || p_mail || '|' || p_url || ')+', 1, level, 'i') is not null
              connect by regexp_substr(n'' || p_value, '(' || p_mail || '|' || p_url || ')+', 1, level, 'i') is not null)
  loop
    dbms_output.put_line(cur.web_value);
  end loop;
end;

'((https?|ftp):\/\/)?(www\.)?([a-z0-9-]+\.)+\b[a-z]{2,4}\b(\/[a-z0-9-]*)*'

declare
  p_value varchar2(200) := 'jdoe@company.co.uk Alexander.Kochnev@yandex.com Alexander.Kochnev http://privet.ru.ru/test/uiop, mail.ru,www.gov.cont.ru|facebook.com/atito мойсайт.рф';

  p_mail varchar2(100) := '[A-Z0-9._%-]+@[A-Z0-9._%-]+\.[A-Z]{2,6}';
  p_url  varchar2(200) := '((https?|ftp)://)?(www\.)?([а-яa-z0-9-]+\.)+[а-яa-z]{2,6}((/[а-яa-z0-9-]*)+|[[:blank:]]|$|[[:punct:]])';

begin
  for cur in (select regexp_replace(regexp_substr(n'' || p_value, p_mail || '|' || p_url, 1, level, 'i'), '([[:punct:]]|[[:space:]])+$') web_value
                from dual
               where regexp_substr(n'' || p_value, p_mail || '|' || p_url, 1, level, 'i') is not null
              connect by regexp_substr(n'' || p_value, p_mail || '|' || p_url, 1, level, 'i') is not null)
  loop
    dbms_output.put_line(cur.web_value);
  end loop;
end;