Answer Posted / swapnareddy

Main Differences between Truncate and Delete:
Truncate:
1:Truncate removes all records but using this we cannot
remove a particular record.
2:Truncate is ddl command(data definiton language command)
3:Rollback cannot be done when we use this command.
4:Truncate cannot fire a trigger.
Delete:
1:delete can remove all records or a particular record.
2:delete is a dml command(data manipulation language command)
3:rollback is possible when we use this command.
4:delete can fire a trigger

What is the difference between delete and truncate statement in sql?

1009

---

What are the different types of dbmss?

963

---

What is difference between stored procedures and application procedures?

956

---

What do you understand by pl/sql packages?

1018

---

Which column in the user.triggers data dictionary view shows that the trigger is a pl/sql trigger?

984

---

how to drop an existing table in mysql? : Sql dba

982

---

What is java sql driver?

1038

---

What are the types of views in sql?

1039

---

what does the t-sql command ident_current does? : Transact sql

928

---

What is a join?

1020

---

How does one use sql*loader to load images, sound clips and documents? : aql loader

1117

---

What are sql functions? Describe the different types of sql functions?

1057

---

What is a primary key example?

901

---

Why left join is used in sql?

916

---

What is the difference between local variables and global variables?

1068

---