Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Stored Procedure with NOT PL/SQL
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: