Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> DBMS_OUTPUT.put_line seems done nothing ?
Hi all:
A friend of mine give me an PL/SQL scripts as followings:
declare
start_time number;
end_time number;
object_count number;
begin
start_time := dbms_utility.get_time;
select count(*) into object_count from tab;
end_time := dbms_utility.get_time;
dbms_output.put_line('The count was completed in
'||(end_time-start_time)/100||' seconds.');
end;
But when I run it, I can only see "PL/SQL procedure successfully
completed." on
the screen. Nothing more. I don't know why?
Thanks in advance.
Jack. Received on Tue Oct 19 1999 - 03:55:19 CDT