请问oracle 中定位字符串位置的方法是什么呀， 如pos等 谢谢

Question

INSTR(C1,C2,I,J)
在一个字符串中搜索指定的字符,返回发现指定的字符的位置;
C1    被搜索的字符串
C2    希望搜索的字符串
I     搜索的开始位置,默认为1
J     出现的位置,默认为1
SQL> select instr('oracle traning','ra',1,2) instring from dual; INSTRING
---------
        9

Answer 1

INSRT就可以了SELECT * FROM BAO_TEMPBASE_ID                        LOT      SPEC_VALUE
------------------------------ --- ---------------
1596180A                       01                5
1596180A                       03                5
1596182A                       01                5
1596182A                       03                5
1598176A                       02                4
1598176A                       03                4
159A175B                       01              4.7
159A175B                       03              4.7
1738151A                       01                5
1738151A                       03                5
1884133D                       01                5BASE_ID                        LOT SUM(SPEC_VALUE)
------------------------------ --- ---------------
1884133D                       03                5
HDI2009T                       01                4
HDI2009T                       03                4
HDI2028T                       01              3.5
HDI2028T                       03              3.5
HDI6028T                       01              3.5
HDI6028T                       03              3.5選取了 18 列SQL> SELECT INSTR(BASE_ID,'4') FROM BAO_TEMP;INSTR(BASE_ID,'4')
------------------
                 0
                 4
                 0
                 0
                 0
                 0
                 0
                 0
                 0
                 0
                 4INSTR(BASE_ID,'4')
------------------
                 0
                 0
                 0
                 0
                 0
                 0
                 0選取了 18 列SQL> SELECT SUBSTR(BASE_ID,1,INSTR(BASE_ID,'4')) FROM BAO_TEMP;SUBSTR(BASE_ID,1,INSTR(BASE_ID,'4'))
------------------------------------------------------------1884
1884SUBSTR(BASE_ID,1,INSTR(BASE_ID,'4'))
------------------------------------------------------------
選取了 18 列