title: Removing all the vowels from a string - PL/SQL
body: <p>I have this homework assignment :</p>
  
  <pre><code> Write an anonymous PL/SQL block that accepts a string as input and removes all of the vowels (a.e.i.o.u) from the string, then outputs the results.
  
   The output should look like this:
  
   Run the Program
  
   SQL&gt;@rm_vowels
  
   Enter the String: A penny for your thoughts
  
   SQL&gt;****************************
  
   SQL&gt;The new string is: pnny fr yr thghts
  </code></pre>
  
  <p>And this does look like something really easy to do but I'm really lacking some PL/SQL experience to get this done.</p>
  
  <p>From my searches so far I've realized I need to use something similar to this :</p>
  
  <pre><code>REGEXP_REPLACE(name,'[a,e,i,o,u,A,E,I,O,U]','')
  </code></pre>
  
  <p>Right ?</p>