DBMS_URL: Working with URLS

Contact Us or call 1-877-932-8228
DBMS_URL: Working with URLS

DBMS_URL: Working with URLS

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.

Code Sample:

select utl_url.escape('http://www.oracle.com/url with space.html')
from dual;

Code Explanation

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.