title: Fetch MULTIPLE ROWS and STORE in 1 VARIABLE - ORACLE STORED PROCEDURE
body: <p>I am working on ORACLE STORED PROCEDURES and I have a doubt.
  I have a query which fetches more than 1 row and I want to store all those 3 row's values in 1 Variable.
  Can anybody please help me with this.</p>
  
  <p>My QUERY goes like this :</p>
  
  <p><code>SELECT STUDENT_NAME
  FROM STUDENT.STUDENT_DETAILS
  WHERE CLASS_ID= 'C';</code></p>
  
  <p>Here this query fetches 3 names</p>
  
  <blockquote>
    <p>Jack,
    Jill,
    Bunny</p>
  </blockquote>
  
  <p>I want all those 3 names to be stored in 1 variable i.e C_NAMES.
  And after that I am using that variable in further steps of my procedure.</p>
  
  <p>Can anyone please help me with this.</p>
  
  <p>I would highly appreciate your time and effort.</p>
  
  <p>Thanks in advance,</p>
  
  <p>Vrinda :)</p>