sql - How to check the date format of the cell (oracle)

Question

Please, help)

I need to verify that cells are populated with correct values. I have a few types of column with a few format of value, i.e. '2015-05-20Z' and 'XXX/MOSCOW/XXXMSX/2015-05-20'.

I do not know how to check the date, if it is only part of the value. This query work:

case 
when A like 'XXX/MOSCOW/XXXMSX/%' 
then 'true' 
else 'false' 
end

But it doesn't enough...

This query doesn't work:

case 
when A like 'XXX/MOSCOW/XXXMSX/[0-9][0-9][0-9][0-9]-[0-9][0-9]-[0-9][0-9]' 
then 'true' 
else 'false' 
end

Answer 1

You appear to be trying to use like to match regular expressions. If that is your intent, look into regexp_like instead.