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 the command used to fetch first 5 characters of the string? : Sql dba

1681

---

who introduced sql?

1072

---

Mention what does plvtab enables you to do when you showthe contents of pl/sql tables?

1208

---

What are the different types of functions in sql?

1097

---

What is sqlerrd?

1015

---

Is it possible to remove child records without removing master table records...the two having pk,fk relationship?

1300

---

Explain how you can copy a file to file content and file to pl/sql table in advance pl/sql?

1053

---

What is data control language (dcl)?

1204

---

explain advantages of myisam over innodb? : Sql dba

1111

---

How do I view tables in mysql?

1027

---

How do I pipe the output of one isql to another?

1056

---

What is a schema sql?

1224

---

is it possible to pass an object or table to a procedure as an argument?

1176

---

What are the popular database management systems in the it industry?

1036

---

what is the different between now() and current_date()? : Sql dba

1072

---