Parse domain from a URL

[stecal]

Of course, you'll be wanting to test that before using it.

  1  select substr('http://tahiti.oracle.com', 0,
  2  (instr('http://tahiti.oracle.com' , '/', 1)-1))
  3* from dual
SQL> /

SUBST
-----
http: