Answer Posted / satya_k21

Hi,

By using truncate command we can delete all the records
in a table , but we cant delete a single record in a table.

by using delete command we can delete a entire records
or a specified record in a table..
Delete is a DML Operation but truncate is DDL Operation
let me know if it is wrong.

Regards,
Satya.k

What are data types in pl sql?

1136

---

How to run sql functions in pl/sql?

1050

---

when MSQL8.0 is in market

2072

---

Can we use distinct and group by together?

1048

---

What is a null value?

1133

---

What are the types of records?

988

---

What is a record in a database?

1058

---

What are the disadvantages of file system?

1255

---

What is oracle sql developer?

1039

---

what is the difference between where clause and having clause? : Sql dba

994

---

Why we use cross join?

949

---

how to write date and time literals? : Sql dba

957

---

What is sql basics?

1037

---

How can we implement rollback or commit statement in a trigger?

1029

---

How to use boolean type in select statement?

1069

---