Can we use a WHERE clause in TRUNCATE statement?

Oracle Apps Interview Questions › Category: SQL › Can we use a WHERE clause in TRUNCATE statement?
0 Vote Up Vote Down
Questions Master asked 10 years ago

If yes how can we use it? any example?

1 Answers
0 Vote Up Vote Down
Shailender Thallam Staff answered 10 years ago

No! You can’t use WHERE clause in TRUNCATE but we can use in DELETE statement.
 
More about TRUNCATE @ http://oracleappsdna.com/question/what-is-the-difference-between-truncate-and-delete-commands/