Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Difference between DELETE <table name> and DELETE FROM <table name>

AshishRoyNov 19 2007 — edited Nov 20 2007
Hi All,
inside a PL/SQL block ,
begin
delete <table_name>;
commit;
end;
begin
delete from <table_name>;
commitl
end;

what is the difference and what is preffered?
both work fine , is it in view of performance or compatibility
Kindly advice ,
Regards,
Ashish Roy
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Dec 18 2007
Added on Nov 19 2007
4 comments
4,359 views