Difference between drop, truncate and delete statement in Oracle SQL

Deepti R.
Jan 12, 2021

--

Drop:
Structure + Data is gone
Can flashback
Cant rollback
DDL statement

Truncate:
Only data is gone. Structure remains.
Cant rollback
Cant flashback
Faster command
Memory is released
DDL statement

Delete:
Only data is gone. Structure remains.
Can rollback
Cant flashback
Memory is not released
Slower command
Can use where clause
DML statement

Sign up to discover human stories that deepen your understanding of the world.

Free

Distraction-free reading. No ads.

Organize your knowledge with lists and highlights.

Tell your story. Find your audience.

Membership

Read member-only stories

Support writers you read most

Earn money for your writing

Listen to audio narrations

Read offline with the Medium app

--

--

Deepti R.
Deepti R.

Written by Deepti R.

Budding blogger | Software Engineer

No responses yet

Write a response