How to write this query..?

[TomazZ]

Yes, Oracle does not know about regular expressions.
Yes, this will work.
Yes, there is another way:

select count(*) from t1
 where translate(substr(f1,2,3),'0123456789','9999999999')='999'