Ron Johnson wrote:
>>begin;
>>create table xyz...
>>alter table abc...
>>insert into abc select * from iii
>>update iii...;
>>drop table iii;
>>(oops, I messed up something)
>>rollback;
>
>
> But isn't that what it means to be "transactional"? Or am I spoiled
> by my "big, expensive enterprise database"?
Well, according to my colleague here this wasn't possible until now
(partially!) in Oracle 10. Meaning it's not common-place even among
enterprise db's.
--
Alban Hertroys
alban@magproductions.nl
magproductions b.v.
T: ++31(0)534346874
F: ++31(0)534346876
M:
I: www.magproductions.nl
A: Postbus 416
7500 AK Enschede
// Integrate Your World //