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 is trigger point?

525

---

What is rowid in sql?

496

---

Why truncate is used in sql?

519

---

Which table is left in join?

509

---

What is delete command in sql?

542

---

---

what is the difference difference between procedure and packages

9189

---

How to use sql*plus built-in timers?

566

---

What are the different dcl commands in sql?

549

---

Explain the rollback statement?

566

---

What is varchar sql?

598

---

column A column b | output 10 7 | 10 5 8 | 8 7 -9 | 7 3 5 | 5 0 6 | 6 Write a sql query to print such output.

6043

---

What is sql constant?

496

---

Difference between global and parameter variables?

1438

---

What is trigger in sql? Explain

525

---

What are local and global variables and their differences?

573

---