Can we use a WHERE clause in TRUNCATE statement?

Oracle Apps Interview QuestionsCategory: SQLCan we use a WHERE clause in TRUNCATE statement?
Questions Master asked 10 years ago

If yes how can we use it? any example?

1 Answers
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/