title: How to return rows from a declare/begin/end block in Oracle?
body: <p>I want to return rows from a select statement within a declare/begin/end block.  I can do this in T-SQL but I would like to know how to do it in PL/SQL.</p>
  
  <p>The code looks a bit like the following:</p>
  
  <pre><code>declare
       blah number := 42;
  begin
       select *
       from x
       where x.value = blah;
  end;
  </code></pre>