SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Validate Domain Name

Sudhir_MeruJul 6 2012 — edited Jul 6 2012

Hi,

I am doing a validation on the domain name people enter. if user enters a invalid domain name it must not allow

Eg: In the below query i am using wwww 4 time which is a invalid domain , Please suggest me how to modify the below code

WITH T AS
(SELECT LOWER(TRIM('wwwww.sudhir.com')) DOMAIN_NAME FROM DUAL
)
SELECT
CASE
WHEN REGEXP_LIKE(DOMAIN_NAME,'[^www].+[^a-z].+[a-zTHEN

>> 1 ELSE 0 END DM

FROM T

Thanks
Sudhir

Locked Post

New comments cannot be posted to this locked post.

Locked on Aug 3 2012

Added on Jul 6 2012

5 comments

349 views