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 does count (*) mean?

517

---

What is cost in sql execution plan?

482

---

How run sql*plus commands that are stored in a local file?

511

---

How do you update sql?

519

---

How can we debug in PL/SQL?

653

---

---

What is linq to sql?

548

---

Explain the the delete statements in sql?

573

---

What is sql in oracle?

623

---

Explain the rollback statement?

570

---

How to get help at the sql prompt?

638

---

what is bdb (berkeleydb)? : Sql dba

562

---

What is a dynamic query?

568

---

Is oracel sql developer written in java?

644

---

What is assignment operator in pl sql?

559

---

Define concurrency control. : Transact sql

582

---