17,082
社区成员
发帖
与我相关
我的任务
分享
with t as
(
select 'ASD3' ID,'000' ITEM from dual
union all
select 'A SD','023' from dual
union all
select 'A#pk','5' from dual
union all
select ' ','5' from dual
)select * from t where regexp_like(id, '^([a-z]|[A-Z]|[0-9])*$');
ID ITEM
---- ----
ASD3 000
with t as
(
select 'ASD3' ID,'000' ITEM from dual
union all
select 'A SD','023' from dual
union all
select 'A#pk','5' from dual
union all
select ' ','5' from dual
)select * from t where regexp_like(id, '^([a-z]|[A-Z]|[0-9])*$'); --只包含大小字母或数字