oracle like 替換

1. like 'A%'

=> instr(欄位,'A')=1




2. like '%A'

=> instr(欄位,'110101')=length(欄位)-length('A')+1







3. like '%A%'

=> instr(欄位,'2')>0