Hi everyone,

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
characters.

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,

Kavita