Oracle – Regular Expressions

http://docs.oracle.com/cd/B12037_01/server.101/b10759/conditions018.htm
http://docs.oracle.com/cd/B19306_01/appdev.102/b14251/adfns_regexp.htm
http://docs.oracle.com/cd/B12037_01/appdev.101/b10795/adfns_re.htm

–Select all URLs who don’t have http as prefix
select unique url_col from table_name
WHERE not REGEXP_LIKE(url_col , ‘^http’,’i’) and url_col is not null

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s