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;