oracle sqldeveloper - ALTER TABLE case insensitivity -

oracle sqldeveloper - ALTER TABLE case insensitivity -

i have tried add together constraint table take file name ended (jpg) regardless of case sensitivity. table should take entry contain files ended (jpg),(jpg),(jpg), etc.

here statement below take upper case. help please?

this in oracle sql developer.

alter table p_species add together constraint imagefile check (species_imagefile ('%.jpg'))

what can lower case species_imagefile constraint.

try this:

alter table p_species add together constraint imagefile check (lower(species_imagefile) ('%.jpg'))

oracle-sqldeveloper