Hugo Kornelis (2/6/2012)

---

And 34% of them are for "you can never rollback a truncate table statement"

vk-kirov (2/6/2012)

---

Maybe they are Oracle refugees? http://www.sqlservercentral.com/articles/Raw+Materials/71108/

Stewart "Arturius" Campbell (2/6/2012)

---

A TRUNCATE can be rolled back in Oracle as well....

Hugo Kornelis (2/6/2012)

---

I've never used Oracle, so I can't speak from experience - but the official Oracle documentation disagrees with you:
http://docs.oracle.com/cd/B28359_01/server.111/b28286/statements_10007.htm

"Caution:
You cannot roll back a TRUNCATE TABLE statement, nor can you use a FLASHBACK TABLE statement to retrieve the contents of a table that has been truncated."

Hugo Kornelis (2/6/2012)

---

I've never used Oracle, so I can't speak from experience - but the official Oracle documentation disagrees with you:
http://docs.oracle.com/cd/B28359_01/server.111/b28286/statements_10007.htm

"Caution:
You cannot roll back a TRUNCATE TABLE statement, nor can you use a FLASHBACK TABLE statement to retrieve the contents of a table that has been truncated."

Data Definition Language (DDL) Statements

Oracle Database implicitly commits the current transaction before and after every DDL statement.
The DDL statements are:
ALTER
...
TRUNCATE

Hugo Kornelis (2/6/2012)

---

I wanted to comment that this question is superfluous, that everyone knows this. But.....

At the time of writing:
"Incorrect answers: 56% (52)"
And 34% of them are for "you can never rollback a truncate table statement"

.
.
.
.
.
.

Picks up jaw from floor.