SQL & PL/SQL

I am sorry I could not give a better title. I will change it, if I get a suggestion.
Assume a simple query.

select * from emp;

What I want to do is run this query in a Procedure and see the results, as if I were running it in a script or SQL PLus. I want to see all the records on screen.
Of course the queries, I am going to run are not this simple, but the method will be the same.

Any suggestions will be applricated.

Thanks.