Data related to resources on the internet (or on local networks) are often stored in the database. This type of data needs to be handled differently than simple string data.
select utl_url.escape('http://www.oracle.com/url with space.html') from dual;
If you need to store and retrieve URLs (web addresses) you need to consider special encoding in your code. The UTL_URL package is used in this example to replace spaces with required character codes.
The exercise below will give you the opportunity to explore the DMBS_APPLICATION_INFO package. This package is used to provide visibility into long running application processes.