Skip to Main Content

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 IP Address using REGEXP

jeneeshJul 30 2007 — edited Jul 31 2007

Hi All,
Sub:Validate IP Address.
My requirement is as this query.

....
....
where regexp_like(col1,'^([1-126]|[128-254]).[0-255].[0-255].[1-254]$')
....
....

I searched for a solution using REGEXP, but no luck..
Thanks in advance.
Jeneesh
(Between, this is not a buisiness requirement.But a challenge from our collegue)

Message was edited by:
jeneesh

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Aug 28 2007
Added on Jul 30 2007
6 comments
2,687 views