Shulou(Shulou.com)06/01 Report--

There are mainly the following four functions that support regular expressions in ORACLE: 1 LIKE like: similar to the function of LIKE: 3 similar to the function of INSTR: 3 similar to the function of SUBSTR: 4 similar to the function of SUBSTR: similar to the function of REPLACE they are the same in usage as Oracle SQL functions LIKE, INSTR, SUBSTR and REPLACE, but they use POSIX regular expressions instead of the old% sign (%) and wildcard (_) characters. The POSIX regular expression consists of a standard metacharacter (metacharacters):'^ 'matches the beginning of the input string and is used in a square bracket expression, which means that the character collection is not accepted.' $'matches the end of the input string. If the Multiline property of the RegExp object is set, $also matches'\ n'or'\ r'.' .s Matches any single character except newline characters.' ,' Matches the previous subexpression zero or once.' + 'matches the previous subexpression one or more times.' * 'match the previous subexpression zero or more times.' | 'indicates a choice between two items. The example'^ ([a Musz] + | [0-9] +) $'represents a string of all lowercase letters or numbers.' () 'Mark the start and end positions of a subexpression.' [] 'Mark a square bracket expression.' {mdirection n}'an exact range of occurrences, m =

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.