Skip to main content

URL datatype

The related URL data type is a subdomain over character strings and represent valid Uniform Resource Locators.

Usage example:

   CREATE TABLE URL_example (c1 URL, c2 URL(512) NOT NULL);


You can use cast() or convert() functions to convert a valid url string to a url type.

   select cast('' as url);
   select convert('', url);

You can also use the url prefix:

   select url '';


A collection of URL specific functions are provided to create, validate and extract portions.