title: Oracle Sql: How can I output a table from procedure
body: <p>I have a table A(a1,a2,a3);</p>
  
  <p>I want to write a procedure like this :</p>
  
  <pre><code>CREATE OR REPLACE PROCEDURE B
  AS
  BEGIN
  .........
  ..........
  SELECT * FROM A;
  END
  </code></pre>
  
  <p>so that when I do <code>EXECUTE B;</code></p>
  
  <p>It should output table A</p>
  
  <p>as happens in <code>select * from A;</code></p>
  
  <p>See I tried with the other answers but it was not working for me that is why i posted this question </p>