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 do you understand by case manipulation functions?

1034

---

How to run pl sql program in mysql?

1021

---

what are the system privileges that are required by a schema owner (user) to create a trigger on a table?

1069

---

Why cross join is used?

1077

---

What is cursor in pl sql?

1118

---

What is a unique key and primary key and foreign key?

969

---

What is trigger and how to use it in sql?

1021

---

what is a stored procedure? : Sql dba

1133

---

How is sql used in oracle?

1006

---

Define SQL and state the differences between SQL and other conventional programming Languages?

1217

---

Differences between Oracle 9i and 10g (Probably in terms of SQL and PL/SQL)?

3570

---

Can a foreign key be a duplicate?

911

---

What types of commands can be executed in sql*plus?

1109

---

What is a parameter query?

1084

---

What is the purpose of using pl/sql?

1146

---