Does ECHO work in SQLPLUS? If not what works?

[areya]

This is a SQLPLUS question. How do I display what is being executed. In other words, in the listing below what command do I need to use to see if commit will be executed. As an example, can I say:

ECHO "commit begins";

is this the right syntax for SQLPLUS?

declare
recs number     := 0;
looper number := 0;
i number;
begin
select count(*) into recs from TTRACK where call_dt <  '1940/01/01';
if recs > 0 and recs > 4 then looper := recs/5;
elsif recs between 0 and 4 then looper := 1;
elsif recs = 0 then
return;
end if;
 
for i in 1..looper loop
DELETE FROM TTRACK WHERE rownum < 5 AND CALL_DT < '1940/01/01';
 
commit;
 
end loop;
 
end;

/

[amitpatel66]

This is a SQLPLUS question. How do I display what is being executed. In other words, in the listing below what command do I need to use to see if commit will be executed. As an example, can I say:

ECHO "commit begins";

is this the right syntax for SQLPLUS?

*************** *************** *************
declare
recs number := 0;
looper number := 0;
i number;
begin
select count(*) into recs from TTRACK where call_dt < '1940/01/01';
if recs > 0 and recs > 4 then looper := recs/5;
elsif recs between 0 and 4 then looper := 1;
elsif recs = 0 then
return;
end if;

for i in 1..looper loop
DELETE FROM TTRACK WHERE rownum < 5 AND CALL_DT < '1940/01/01';

commit;

end loop;

end;
/
*************** *************** *********end*** *************** ******

Make use of DBMS_OUTPUT.PUT _LINE in order to display any user defined message on the screen.

Before useing DBMS_OUTPUT package, you need to execute the below command:

SQL> SET SERVEROUTPUT ON
 

Then you include the line DBMS_OUTPUT.PUT _LINE('Commit Begins') in your anonymous block