存储过程中的正则表达式 [英] Regular expressions in stored procedures
问题描述
可以在存储过程中使用正则表达式吗?如果可以,怎么做?你能举一些例子来说明如何做到这一点吗?
Can a regular expression be used inside a stored procedure? If it can, how? Can you give some examples of how to do it?
推荐答案
一般来说,是的.
MySQL:http://dev.mysql.com/doc/refman/5.1/en/regexp.html
甲骨文:http://www.oracle.com/技术/obe/obe10gdb/develop/regexp/regexp.htm
MS SQL:http://msdn.microsoft.com/en-us/magazine/cc163473.aspx
更多:
PostgreSQL:http://www.postgresql.org/docs/8.3/static/functions-matching.html
PostgreSQL: http://www.postgresql.org/docs/8.3/static/functions-matching.html
DB2:http://www.ibm.com/developerworks/data/library/techarticle/0301stolze/0301stolze.html
Informix:http://www.ibm.com/developerworks/data/zones/informix/library/techarticle/db_regexp.html
SQL Anywhere:http://iablog.sybase.com/paulley/2009/06/using-regular-expressions-with-sql-anywhere/
SQL Anywhere: http://iablog.sybase.com/paulley/2009/06/using-regular-expressions-with-sql-anywhere/
这篇关于存储过程中的正则表达式的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!