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!

help to understand difference between 'delete table purge' and 'truncate table'

SmithJohn45Oct 6 2023 — edited Oct 6 2023

if i am using

delete table emp purge;

truncate table emp;

1- what is the difference between two and

2- which one is better approach using in procedure/function/package etc. for an Admin level application.

differences and usage of DELETE, TRUNCATE, PURGE, RECYCLEBIN etc., when and where to use and not to use?

please help to understand this.

regards

Added on Oct 6 2023

6 comments

4,598 views

2 mentions