title: While loops with Strings not Integers
body: <p>I'm having trouble finding any information on oracle plSQL while loops with strings online. All seem to be integer. When doing my research i feel i understand the integer aspect of while loops in plSQL but no sites that i have visited touched on or had examples of While Loops using strings.</p>
  
  <p>For example: I can use a For loop to print individual letters from the word '<em>text</em>' but what would stop me from using a While loop to get the same output? </p>
  
  <pre><code>DECLARE
    c1 Number:= 1;
    c2 Varchar2(4);
  BEGIN
    FOR c1 in 1..4
    LOOP
      SELECT substr('text' , c1 , 1 ) into c2 from dual;
      dbms_output.put_line(c2);
    END LOOP;
  END;
  </code></pre>
  
  <p>If someone could explain how one would print a individual character or even the whole string with a while loop; or possibly point me in the right direction in terms of where to research example while loops with strings online. </p>
  
  <p>Thank you.</p>