oracle - add a check constraint for the column -


add check constraint column, insert values didn't have special characters except comma, space, full-stop , number in them?

for example allows like: group co.,ltd

should not allow ¿abc important

you can try below example-

alter table emp add ( constraint cc_name check (trim(translate(upper(ename),' abcdefghijklmnopqrstuvwxyz0123456789_,.',' ')) null)); 

Comments

Popular posts from this blog

php - Vagrant up error - Uncaught Reflection Exception: Class DOMDocument does not exist -

vue.js - Create hooks for automated testing -

Add new key value to json node in java -