Regular Expression, Regular Expression

Regular Expression, Regular Expression

Oracle also supports regular expressions, mainly embodied in the following five functions: REGEXP_COUNT, REGEXP_INSTR, REGEXP_REPLACE, REGEXP_SUBSTR, REGEXP_LIKE.

Later, I checked the official Oracle documents and found that it fully complies with the POSIX standard Extended Regular Expression (ERE) syntax. At the same time, I introduced the custom Regular operators in perl, learning Perl some time ago, I learned the power of its regular expression, so I had the idea of organizing it. Now we can see that the Oracle official documentation is so clear and complete that it can be referenced directly.