17,086
社区成员
发帖
与我相关
我的任务
分享
create or replace view v_test_06 as
select '123' as data from dual union all
select 'abc' from dual union all
select '123abc' from dual union all
select 'abc123' from dual union all
select 'a1b2c3' from dual union all
select 'a1b2c3#' from dual union all
select '3$' from dual union all
select 'a 2' from dual union all
select '0123456789' from dual union all
select 'b3#45' from dual;
select data from v_test_06 where regexp_like(data,'^[0-9a-zA-Z]+$');