title: Oracle: remove first 4 characters from a string
body: <p>So I want to remove the first 4 characters from a string in oracle. Those characters can be different every time.
  In my case I need to take away the first 4 characters of an IBAN and put them at the end of the string. I got the part of putting them to the end of the string but I can't get the first 4 characters to be removed. Every solution I find on the internet removes specified characters, not characters from a certain position in the string (1 to 4).
  I used the code below to get the first 4 characters to the end of the string and wanted to try something similar for removing them at the front but without success.</p>
  
  <pre><code>SELECT SUBSTR(iban_nummer, 1, 4) INTO iban_substring FROM dual;
  iban_nummer := iban_nummer || iban_substring;
  </code></pre>