title: how to escape characters like '[', ']', '|' in regexp_substr oracle
body: <p>i need to replace somthing like this:</p>
  
  <pre><code>some random characters[[some_randome_characters1|some_randome_characters2]]some random characters
  </code></pre>
  
  <p>to this:</p>
  
  <pre><code>[link=some_randome_characters]some_randome_characters[/link]
  </code></pre>
  
  <p>i manage to write procedure having this:</p>
  
  <pre><code>l_tmp:=regexp_substr(content,'/[{2}(/s|/w|/d)+/|/[{2}(/s|/w|/d)+/]{2}');
  </code></pre>
  
  <p>... here i am doing rest stuff to build my link.
  Problem is that <code>(/s|/w|/d)+</code> dont find all matches -> for exapmle text having '.', or '=', and others. All in all i want to change this:</p>
  
  <pre><code>(/s|/w|/d)+
  </code></pre>
  
  <p>to this:</p>
  
  <pre><code>[^/|/[/]] 
  </code></pre>
  
  <p>But it wont work. Is there any way to escape those 3 characters?</p>