title: Select Statement inside a procedure in Oracle
body: <p>sorry for asking this question but it's because none of the answers given before are enough for me to understand. I want to write a stored procedure that returns all the columns in a table.As an ad hod query I just write </p>
  
  <pre><code>SELECT * FROM EMPLOYEES
  </code></pre>
  
  <p>but here, I get an error which prompts me to provide <code>INTO</code> clause which I don't understand why and how.Could someone explain how would I do that both in the above case and when I want to return just one column values(multiple rows).</p>