Oracle Instr

最新推荐文章于 2022-04-07 22:49:03 发布

原创最新推荐文章于 2022-04-07 22:49:03 发布 · 118 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#Oracle #SQL

Oracle周边专栏收录该内容

38 篇文章

订阅专栏

[size=large][color=blue]四组例子，应该已经完全地说明用法了。[/color]

[color=black]INSTR(源字符串, 目标字符串, 起始位置, 匹配序号)[/color][/size]


SQL> SELECT INSTR('12_34_56_78', '_', 1, 1) As INSTR FROM DUAL;

     INSTR
----------
         3

SQL> SELECT INSTR('12_34_56_78', '_', -1, 1) As INSTR FROM DUAL;

     INSTR
----------
         9


SQL> SELECT INSTR('12_34_56_78', '_', 1, 2) As INSTR FROM DUAL;

     INSTR
----------
         6

SQL> SELECT INSTR('12_34_56_78', '_', -1, 2) As INSTR FROM DUAL;

     INSTR
----------
         6


SQL> SELECT INSTR('12_34_56_78', '_', 1, 3) As INSTR FROM DUAL;

     INSTR
----------
         9

SQL> SELECT INSTR('12_34_56_78', '_', -1, 3) As INSTR FROM DUAL;

     INSTR
----------
         3


SQL> SELECT INSTR('12_34_56_78', '_', 4, 1) As INSTR FROM DUAL;

     INSTR
----------
         6

SQL> SELECT INSTR('12_34_56_78', '_', -4, 1) As INSTR FROM DUAL;

     INSTR
----------
         6