Sunday, February 3, 2008

%TruncateTable

%TruncateTable

While we know that oracle implicitly commits after the execution of a Truncate statement, one might wonder the impact of using this in an AE program and causing issues.

Per peoplebooks, AE is smart enough to recognize that and converted a %TruncateTable to a delete!

Wondering whether it will add a where clause ( where process_instance = %processinstance ) ?
Anyone who has worked on it can comment ?

No comments: