Answer / Kaushal Kumar Singh

Truncate command does not create a new transaction, so it doesn't require an explicit commit. However, if you have an ongoing transaction when executing TRUNCATE, the changes will be part of that transaction and will be committed or rolled back accordingly.

What are sql objects?

1 Answers  

---

What is PL/SQL table ?

6 Answers  

---

What is the default value of CHAR type?

3 Answers   Bosch,

---

function can return multiple value?how give give sample coding

2 Answers   3i Infotech, CTS, Excelity Global, UHG,

---

What are sql*plus environment variables?

1 Answers  

---

how do you login to mysql using unix shell? : Sql dba

1 Answers  

---

How to sort the rows in sql.

1 Answers  

---

What is sql and explain its components?

1 Answers  

---

What is sp_helptext?

1 Answers  

---

What is a sql select statement?

1 Answers  

---

what are all different types of collation sensitivity? : Sql dba

1 Answers  

---

What are the attributes of SQL*PLUS ?

2 Answers   Dream Careers, Oracle,

---