Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

would truncate commit also?

hphanjra-JavaNetMar 20 2007 — edited Mar 20 2007

how to avoid this if yes.

create table t2 ( c1 number);

create table t(c1 number);

insert into t values(1) ;
truncate table t2; -- this will commit row in the table t

select * from t;

rollback ; -- will NOT rollback 1 row

Thanks

Locked Post

New comments cannot be posted to this locked post.

Locked on Apr 17 2007

Added on Mar 20 2007

#general-database-discussions

5 comments

2,384 views