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.