Monday, April 29, 2013

Oracle column search to see existance of character from A-Z

One of the dev came to me and told that app is storing date in a character column.. So now they need to use some function to show it as date.

Obviously to_date () was the function I need to use, but when I executed to_date, I found that column is not only storing dates but some character as well.

So I have to extract those characters. This introduced me oracle "regexp_like".

Sql:
select column from table where  regexp_like(column,'[A-Z]','i');

and it's done :)

For details you can refer to the following url:
http://docs.oracle.com/cd/B12037_01/appdev.101/b10795/adfns_re.htm

No comments:

Post a Comment