Home
Recent Q&A
Java
Cloud
JavaScript
Python
SQL
PHP
HTML
C++
Data Science
DBMS
Devops
Hadoop
Machine Learning
Azure
Blockchain
Devops
Ask a Question
What is the difference between TRUNCATE & DELETE command in Oracle?
Home
Oracle
What is the difference between TRUNCATE & DELETE command in Oracle?
+1
vote
asked
Jul 29, 2020
in
Oracle
by
Hodge
Q. What is the difference between TRUNCATE & DELETE command in Oracle?
#oracle
#truncate
#delete
Please
log in
or
register
to answer this question.
1
Answer
0
votes
answered
Jul 29, 2020
by
Hodge
Both the commands are used to remove data from the database.
The difference between the two include:
TRUNCATE is a DDL operation while DELETE is a DML operation.
TRUNCATE drops the structure of a database and hence cannot be rolled back while the DELETE command can be rolled back.
The TRUNCATE command will free the object storage space while the DELETE command does not.
Related questions
0
votes
Q: What is the difference between DELETE and TRUNCATE statements?
asked
Dec 15, 2020
in
Sql
by
SakshiSharma
#delete
#truncate
#truncate-sql
0
votes
Q: What are the TRUNCATE, DELETE and DROP statements?
asked
Dec 14, 2020
in
Sql
by
SakshiSharma
#truncate
#delete
#drop-statemement
0
votes
Q: What is the difference between DROP and TRUNCATE statements?
asked
Dec 15, 2020
in
Sql
by
SakshiSharma
#drop
#truncate
#drop-sql
0
votes
Q: How will you differentiate between VARCHAR & VARCHAR2 data tyoes in Oracle?
asked
Jul 29, 2020
in
Oracle
by
Hodge
#oracle
#varchar
#varchar2
+1
vote
Q: Which one of the following statements correctly refers to the Delete and Delete[] in C++ programming language?
asked
Jan 21, 2021
in
C Plus Plus
by
SakshiSharma
#delete-function
#delete
+1
vote
Q: What is the data type of DUAL table in oracle?
asked
Jul 29, 2020
in
Oracle
by
Hodge
#dualtable
#oracle
+1
vote
Q: How do we create privileges in Oracle?
asked
Jul 29, 2020
in
Oracle
by
Hodge
#oracle
+1
vote
Q: What is a database trigger in Oracle? How to create it?
asked
Jul 29, 2020
in
Oracle
by
Hodge
#oracle
0
votes
Q: What is BLOB in Oracle?
asked
Jul 29, 2020
in
Oracle
by
Hodge
#blob
#oracle
0
votes
Q: What are savepoints in oracle?
asked
Jul 29, 2020
in
Oracle
by
Hodge
#save
point
#oracle
...