Oracle创建临时表，快速构建测试数据

create table t_stat(a int,b int);
insert into t_stat select mod(level,5),mod(level,3)+2 from dual connect by level<=200;

直接创建出200条记录出来

 

快速构建一个临时表出来

with chenxu as

(

select '老头子大帅哥！handsome！イケメン！' as a from dual

)

select a,regexp_replace(a,'[^' || unistr('\4E00') || '-' || unistr('\9FA5') || ']','')

from chenxu