摘要:
探查模式:declare names varchar2(60):='zhangxuegang,zhangsan,lisi,wangwu,zhaoliu'; names_adjusted varchar2(61); comma_delimited boolean; begin --查询是否包括某种模式 comma_delimited:=regexp_like(names,'^([a-z A-Z]*,)+([a-z A-Z]*){1}$'); --显示查找结果 dbms_output.put_line( case comma_delimited when true 阅读全文