Re: Truncate Table in PL/SQL

Dear Boon,

Although you can truncate a table in a PL/SQL block, but since Truncate causes an implicit commit, all the transactions will be made permanent, and you cannot rollbacked the database, if there is any need.

Try using Delete instead of Truncate.

Regards

AAmir Siddiqi

Chua Boon Yiang <chuaby_at_hotmail.com> wrote in message news:80d6qh$820$1_at_newton.pacific.net.sg...
> Hi
>
> can i do a "truncate table T1" in a PL/SQL block ?
> as i need to manipulate a temp table very often, w/o the ability to do a
> truncate table will have abit efficiency problem.
>
> Thanks
> Boon Yiang
>
>
Received on Thu Nov 11 1999 - 11:22:03 CST