diff. between sql and pl/sql
478738Feb 27 2006 — edited Mar 2 2006Hi,
I have a doubt between the following scenarios, if we issue delete statement in the following environments. what is the difference in the execution wise and which is the better way and why ?
1) in sql* plus:
delete * from emp;
commit;
2)
begin
delete * from emp;
commit;
end
3) create or replace procedure proc1 is
begin
delete * from emp;
commit;
end;
Thanx in advance.
RP