Oracle10g正则表达式

最新推荐文章于 2025-08-06 16:23:50 发布

weixin_33978044

最新推荐文章于 2025-08-06 16:23:50 发布

阅读量92

点赞数

文章标签：数据库

本文介绍了Oracle 10g中引入的正则表达式功能，包括常用的正则表达式操作符如regexp_like、regexp_instr等，并详细解释了各种符号的意义及用法，例如匹配任意字符、指定位置字符等。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

With 10g, regular expressions are finally available in SQL. That is, they were already supported through the owa_pattern package.

The new operators and functions are regexp_like, regexp_instr, regexp_substr and regexp_replace

symbol	Matches
.	Any character except newline
^	Start of a line
$	End of a line
*	0, 1, or more of the preceding element. The preceding element can be grouped with ()
{n}	Exactly n repetitions of the preceding element. The preceding element can be grouped with ()
{n,}	Matches n or more repetitions of the preceding element. The preceding element can be grouped with ()
{m,n}	Matches between m and n repetitions of the preceding element. The preceding element can be grouped with ()
[abc]	Character list, matches a, b OR c.
[g-l]	g, h, i, j, k, OR l
\|	groups alternatives