title: simple way to return 2 or more rows using a SELECT in pl/sql
body: <p>I am trying to figure out the most simple way to return 2 or more rows using a select statement in pl/sql to the sqlplus output.  Here is a basic example.</p>
  
  <pre><code>begin
    select sysdate,'12345' xid from dual
      union all
    select sysdate,'67890' xid from dual;
  end;
  /
  </code></pre>
  
  <p>Error is "an INTO clause is expected in this SELECT statement"  </p>