difference between replace and regexp_replace and the difference between like and InStr

Repalce (STR_SOURCE,STR1,STR2) replaces the STR1 string in Str_source with the STR2 string,
When str2 is null or ' ', the next function is the same

Replace (STR_SOURCE,STR1) removes the str1 string from the Str_source

Regexp_replace (STR_SOURCE,PATTERN_STR) rejects the pattern_str string in Str_source

The difference between like and InStr in Oracle is that it is more efficient to InStr without creating an index, but not as much as it is.
After creating an index like is much more efficient than InStr

Translate (' Target string ', ' source string ', ' destination string ') when the target string appears with the same character as the source string,
will be replaced with the destination string

This article from "Essays" blog, Declined reprint!

difference between replace and regexp_replace and the difference between like and InStr