SAPHANA学习(15):SQL Function(O)
/*
106. OCCURRENCES_REGEXPR
OCCURRENCES_REGEXPR( <pattern> [ FLAG <flag> ] IN <regex_subject_string> [ FROM <start_position> ] )
返回正则匹配次数
<pattern> ::= !!Perl Compatible Regular Expression
<flag> ::= { 'i' | 'm' | 's' | 'x' }
i:不区分大小写
m:多行模式
s:启用<.>作为通配符,匹配任意字符
x:允许空格注释
*/
SELECT OCCURRENCES_REGEXPR('([[:digit:]])' IN 'a1b2') FROM DUMMY;
本文来自博客园,作者:渔歌晚唱,转载请注明原文链接:https://www.cnblogs.com/tangToms/p/13892823.html