delin的专栏

匹配15和18位select * from sfzmhm_table where sfzmhm regexp '^[1-9][[:digit:]]{7}((0[[:digit:]])|(1[0-2]))(([0|1|2][[:digit:]])|3[0-1])[[:digit:]]{3}$|^[1-9][[:digit:]]{5}[1-9][[:digit:]]{3}((0[[:digit:]])|

show variables like ‘%version_%’;

SELECTL4.plan_id,MAX(SUBSTR(L4.分组内容,2)) display_themeFROM( SELECT L3.plan_id ,SYS_CONNECT_BY_PATH(L3.theme_name,'；') AS 分组内容 FROM( SELECT