title: Multiple select statement in Oracle
body: <p>I want to write a simple stored procedure in Oracle with multiple select statements in that. I can do the same in the SQL server like </p>
  
  <pre><code>Create proc spc_name
  as
  begin
  select * from tab1
  
  Select * from tab2
  ......
  end
  </code></pre>
  
  <p>I want to know how to write the same equivalent stored procedure in Oracle as I have done in SQL Server </p>