摘要: select * from table a where 字段1 like '%'||字段2||'%' 阅读全文
posted @ 2023-10-16 14:25 bellin124 阅读(453) 评论(0) 推荐(0) 编辑
摘要: SELECT A.*,regexp_substr(A.MATERIAL_ID,'[^,]+',1,lvl,'c') MATERIAL_NO ,regexp_count(A.MATERIAL_ID,',')+1 CNT FROM DWT_INPUT_LOT A ,(select level lvl f 阅读全文
posted @ 2023-10-16 14:25 bellin124 阅读(20) 评论(0) 推荐(0) 编辑