Oracle regex: \Q\E doesn't work

Question

Hi. I found that \Q\E doesn't work in oracle. What is the equivalent expression of \Q\E for oracle regex ?

TIA

Answer 1

In Perl, \Q starts the automatic escaping of special characters and \E stops this behaviour. So within a \Q \E block, a dot would be treated as a literal dot rather than any character.

If Oracle doesn't support this, then just escape any special characters that would have been in the block.