plsql中怎么截取逗号前面的字符串

2025-03-23 14:38:58
推荐回答(1个)
回答1:

Substr(SUBSTR(M.MODEL, 1),1,(Instr(SUBSTR(M.MODEL, 7), ',', 1) - 1))
和Substr(SUBSTR(M.MODEL, 7),1,(Instr(SUBSTR(M.MODEL, 7), ',', 1) - 1))