摘要:
WITH RECURSIVE tree ( organization_id, organization_name, parent_id ) AS ( SELECT organization_id, organization_name, parent_id FROM core_organization 阅读全文
摘要:
public class RegexTest { public static void main(String[] args) { // 查找的字符串 String line = "(乙方):xxx科技股份有限公司 (乙方):xxx有限公司 (乙方):xxx技术股份有限公司 "; //正则表达式 S 阅读全文
摘要:
regexp_like(需要判断的字段名,'^+?[1-9][0-9]*$') SELECT ID, PERIODSID, (case when regexp_like(LEADERNUM,'^+?[1-9][0-9]*$') then TO_NUMBER(LEADERNUM) else 0 end 阅读全文