Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Re: PL/SQL how-to procedure
CG <christian.gregory_at_citicorp.com> wrote in article
<333C8093.19A5_at_citicorp.com>...
> ...Can anyone tell me if it is possible to create a procedure
> this select statement will not have an into clause.
You can't do anything but an into clause but the following will do basically the same thing.
declare
You must however use the dbms_output.put_line and get_line if you want to see what was put out.
use the following with sqlplus to see the output.
set serverout on size 1000000 -- the 1000000 can be any number between 2k and 1M
-- Bob Fazio Oracle DBA Danet, Inc. fazio_at_danet.comReceived on Wed Apr 02 1997 - 00:00:00 CST
![]() |
![]() |