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