Clever Geek Handbook

Oracle Deals

Is it possible to have only DDL transactions with transaction? and if so, is it possible to revert it to its original state if any of the DDL statements fail?

Thank you and best regards, priya.R

+2


source to share


1 answer


in Oracle, the DDL statement implicitly comments before and after the statement. Each expression is an independent transaction and you cannot undo a successful expression.



However, a DDL statement is always atomic: it either succeeds entirely or fails completely.

+6


source






More articles:


All Articles