-提取大写字母

--提取大写字母:
SQL> select * from v;

A1
--------------
Stewie Griffin

SQL> select replace(translate(A1,'1abcdefghijklmnopqrstuvwxyz','1'),' ','.') from v;

REP
---
S.G