I'm trying to build an query that will tell me if i have accents in some columns from my oracle table.
Ex: If for example in the column NAME i have the value: TEST * 1
and that the accents that i want to filter is *
then it will flag it.
all the accents that i want to find are:
`,<,>,^,|,[,],*,é,É,Ç,ç,À,à,~,@, %, #,À,Á,Â,Ã,Ä,Å,Ç,È,É,Ê,Ë,Ì,Í,Î,Ï,Ð,Ñ,Ò,Ó,Ô,Õ,Ö,Ù,Ú,Û,Ü,Ý,à,á,â,ã,ä,å,ç,è,é,ê,ë,ì,í,î,ï,ð,ñ,ò,ó,ô,õ,ö,ù,ú,û,ü,ý,ÿ,/,!,@,#,$,%,?,*,(,),+
The column that i want to find these accents are in column:
If there is an accents, it would say NAME_TO_FIX in a column NAME_VALIDATION.
Is that possible?
How can i do that?
Thanks again for your help
This is the SQL i have for now:
WHEN NAME = (all accents) THEN 'NAME_TO_FIX'