gm [select DISTINCT(regexp_substr(url,'([a-z]|[A-Z]|[0-9]).*',6,1)) as uri from is_blacklist_url where valid_date >= to_char(sysdate-90,'yyyy/MM/dd')] uri