In oracle, The _ instr function is similar to indexof.

Similar to indexof in oracle, The _ instr function [SQL] does not have the indexof () function in oracle, but an instr () method is provided. Specific usage: select instr ('baoding nanchengqu ', 'city',)-1 from dual; Explanation: 1. 'baoding city South' => it can be an expression or a specific data. 'city' => is the separator. Here is the word "city" in the two groups of data. the first 1 is from the left, and if it is-1, it starts from the right. 4. The second one is the number of times the city appears. Www.2cto.com is encoded in GBK format. A Chinese Character occupies two bytes: select instr ('baoding city South', 'city', 1, 1) from dual; the value is 5 select instr ('baoding city South', 'city', 1, 2) from dual; the value is 9 select instr ('baoding city South', 'city ', -) from dual; the value is 9 select instr ('South city of Baoding City ', 'city',-) from dual; the value is 5 author qyongkang