sql – Oracle regexp_replace default replace string

sql – Oracle regexp_replace default replace string

Yes, theyre the same. The documentation for REPLACE is more explicit about this behavior:

If replacement_string is omitted or null, then all occurrences of search_string are removed.

But REGEXP_REPLACE behaves the same way. The third argument replace_string replaces whatever matches the pattern; if its omitted or null, all matching parts of the string are removed.

sql – Oracle regexp_replace default replace string

Leave a Reply

Your email address will not be published. Required fields are marked *