I have a problem.
When I read from a file I must respect the folowing rules:
The only characters admited are :
Number: from 0 till 9
Blank and A....Z (capital letters).
(The not capital letters and the letters with accent are deleted.)
The special letters: ! ‘’ % $ & ’ ( ) * +, - . / : ; < = > ?
All the others characters will be replaced by blanks.
How could I realise,easily this thing.
I don't know if it's available in versions prior to 10g, but you could do something like:
create table t (f varchar2(5))
insert into t values ('1aA!>')
1 row created.
select regexp_replace(regexp_replace(f, '[a-z]', ''), '[^[:alnum:]]', ' ') as f1
1 row selected.
The inner regexp_replace() replaces all lowercase letters with a zero-length text string, and the outer replaces all non-alphanumeric characters with a space.