Answer Posted / suneel

truncate:
---------
truncate is a ddl command.
ddl commands having auto commit.

delete:
-------
delete is a dml command.
dml commands not having auto commit.

What is orm in sql?

531

---

How to place comments in pl/sql?

599

---

What is fmtonly in sql?

525

---

how can we transpose a table using sql (changing rows to column or vice-versa) ? : Sql dba

497

---

What found sql?

516

---

---

What is the purpose of using pl/sql?

655

---

what are the advantages a stored procedure? : Sql dba

538

---

Can triggers stop a dml statement from executing on a table?

608

---

how many sql ddl commands are supported by 'mysql'? : Sql dba

518

---

What are some predefined exceptions in pl/sql?

546

---

What is the use of function "module procedure" in pl/sql?

662

---

what is the maximum length of a table name, database name, and fieldname in mysql? : Sql dba

615

---

How do you declare a variable in pl sql?

528

---

How to rename a column in the output of sql query?

528

---

what is the use of double ampersand (&&) in sql queries?

619

---