I need to write a function which will checK FOR SPECIAL CHARACTERS(LIKE !@#$%^) A COLUMN BEFORE MOVING IT TO THE MAIN TABLES. It should accept numeric and alpha
Now the column it has to check is a varchar2 column and I can't pass it directly to to_char function(which I found will not accept special characters).
Is there any other way to check for special characters.
Thanx in advance,