是否有可以将正则表达式存储为值的数据库？

示例查询：WHERE REGEXP_LIKE(first_name,’^ Ste(v | ph)en $’)

您想从列中选择正则表达式,请参阅下面的SQL Fiddle示例以获取示例.

SQL Fiddle

选择Oracle数据库.

在架构窗口中执行以下命令：

CREATE TABLE regexp (name VARCHAR2(20),count NUMBER,regexp VARCHAR2(50));

INSERT INTO regexp VALUES ('Tim',3,'t+');
INSERT INTO regexp VALUES ('Rob',4,'ad+');
INSERT INTO regexp VALUES ('Fil',1,'tt');
INSERT INTO regexp VALUES ('Marc','bb');
COMMIT;

执行SQL语句,例如(正如你在问题中提到的那样)：

SELECT * FROM regexp WHERE REGEXP_LIKE('tt',regexp);

产量：

NAME    COUNT   REGEXP
Tim     3       t+
Fil     1       tt

参考here.

摘抄：

Oracle Database implements regular expression support with a set of
Oracle Database SQL functions and conditions that enable you to search
and manipulate string data. You can use these functions in any
environment that supports Oracle Database SQL. You can use these
functions on a text literal,bind variable,or any column that holds
character data such as CHAR,NCHAR,CLOB,NCLOB,NVARCHAR2,and
VARCHAR2 (but not LONG).

还有一些需要考虑的信息：

A string literal in a REGEXP function or condition conforms to the
rules of SQL text literals. By default,regular expressions must be
enclosed in single quotes. If your regular expression includes the
single quote character,then enter two single quotation marks to
represent one single quotation mark within the expression. This
technique ensures that the entire expression is interpreted by the SQL
function and improves the readability of your code. You can also use
the q-quote syntax to define your own character to terminate a text
literal. For example,you could delimit your regular expression with
the pound sign (#) and then use a single quote within the expression.

Note: If your expression comes from a column or a bind variable,then
the same rules for quoting do not apply.

请注意,没有名为RegEx的列类型,您需要在文本列中按原样保存字符串.

您还可以在约束检查和项目列中使用RegEx.