1、創建測試表,
create table test_str(id int, v_str varchar2(20));
2、插入測試數據
insert into test_str values(1,'abc123');
insert into test_str values(2,'ef414219sd');
insert into test_str values(3,'123');
insert into test_str values(4,'dddfg');
commit;
3、查詢表中全量數據,select t.* from test_str t;
4、編寫語句,取字符串中的數字;
select t.*, regexp_replace(v_str,'\D','') v_str2 from test_str t;