About Oracle

Questions

1.  I want to create a stored procedure for
   SELECT * from MYTABLE
   When I use BEGIN & END command, Oracle asked me using INTO.
   I don't want to INTO some table, but only display it on the screen.
   When I don't use BEGIN & END with SQL Plus 8.0, I got the message:
   -------------------------------------
   PLS-00103: Encountered the symbol "SELECT" when expecting one of
   the following:
   begin function package pragma procedure subtype type use ...
   -------------------------------------
   Someone told me I must use a cursor to select only one record each time and
   use INTO.
   I can't believe it, because I can do it very easily with Microsoft SQL Server.
   

   
   I solved above problem. Thanks.