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

Is sql a backend language?

1091

---

Explain the the update statement in sql?

1036

---

What is number function in sql?

965

---

How many types of normalization are there?

957

---

What will you get by the cursor attribute sql%rowcount?

1034

---

How can you know that statistics should be updated?

1077

---

How do I remove sql plus from windows 10?

1096

---

What programs use sql?

1002

---

Explian rowid, rownum?

1009

---

Can we rollback delete command?

980

---

What is embedded sql what are its advantages?

1034

---

What is trigger in flip flop?

1007

---

Explain what is sql*plus?

1138

---

What is mutating table error?

1175

---

what are the differences among rownum, rank and dense_rank? : Sql dba

1038

---