随笔分类 -  oracle

oracle截取某个字符之前得内容
摘要：select substr('123,456,789',1,instr('123,456,789',',',1)-1) 值 from dual;值123 阅读全文
posted @ 2020-08-27 16:38 &宁静&致远& 阅读(905) 评论(0) 推荐(0)