oracle判断是否包含字符串
一. oracle判断是否包含字符串的方法
1. contains,contains用法如下:select * from students where contains(address, 'beijing')
2. instr,instr的用法如下:select * from students where instr(address, 'beijing') > 0
3. like,使用like:select * from students where address like ‘%beijing%’