Answer / Abhineet Sehgal

No, the TRUNCATE TABLE command does not support a rollback because it does not create undo records. To recover data after TRUNCATE, you need to use database backups or restore from a previous state.

How does postgresql compare to mysql?

1 Answers  

---

Write a sql select query that only returns each name only once from a table?

1 Answers  

---

What is a scalar value in sql?

1 Answers  

---

What is a sql*loader control file?

1 Answers  

---

how do you control the max size of a heap table? : Sql dba

1 Answers  

---

What is varray in pl sql?

1 Answers  

---

i hv 30 rows with date.ex:1month hav 4 weeks i want 1st day of the every week.write the qry for that.example jan has 4 weeks i need 1st dd for evry wk

1 Answers   Aspire,

---

What is the difference between CHAR and VARCHAR2? If VARCHAR2 serves the uses of CHAR why CHAR is still used and not been discarded yet?

9 Answers   Oracle,

---

Which one of the following join types will always create a Cartesian Product? 1. CROSS JOIN 2. LEFT OUTER JOIN 3. RIGHT OUTER JOIN 4. FULL OUTER JOIN 5. INNER JOIN

2 Answers  

---

what is sql profiler? : Sql dba

1 Answers  

---

What are % type and % rowtype?

1 Answers  

---

Is there any problem if we use commit repeatedly after each dml statement in a plsq procedure ? (eg. there are 10 update stmt and using 10 commit stmt after each update stmt)

1 Answers  

---