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 parameter substitution in sql?

976

---

Does mysql_real_escape_string prevent sql injection?

907

---

What is sql profiling in oracle?

995

---

Explain the significance of the & and && operators in pl sql.

950

---

Is sql free?

886

---

Which table is left in join?

913

---

write an sql query to get third maximum salary of an employee from a table named employee_table. : Sql dba

916

---

Define the select into statement.

992

---

What is clause?

1063

---

How much does sql certification cost?

1014

---

Is foreign key mandatory?

938

---

what is query cache in mysql? : Sql dba

991

---

What are all the different normalizations?

970

---

What pl/sql package consists of?

1030

---

What does subquery mean in sql?

988

---