title: stored procedure for selecting all rows from table in Oracle
body: <p><strong>Please Note:</strong> There are several post regarding this, but I am not getting those due to some key words and why used?
  How to create a simple stored procedure in <code>Oracle</code> which select all rows from table. I exactly want to create same as below script written in <code>SQL</code>. Also How to execute the procedure in Oracle and place in <code>ASP.NET</code> <code>OracleCommand</code> object.</p>
  
  <p>How to re-write this SQL Stored Procedure in Oracle</p>
  
  <pre><code>CREATE PROCEDURE spGetData
  AS
  Begin
  SELECT * from My_Table;
  End
  </code></pre>
  
  <p>Execute is sql</p>
  
  <pre><code>execute spGetData
  </code></pre>