Hi All, Hope you guys doing well!!! I have a question on database transaction. First, issued a DML statement as INSERT INTO XYZ (number, name) VALUES (12,’TEST’); Then I issued the following DDL statement as CREATE TABE ABC AS SELECT * FROM DUAL; The above statement gives an error due to the syntax error. As per my knowledge, Oracle server issues an implicit commit before and after any DDL statement. So, even if your DDL statement does not execute successfully, you cannot roll back the previous statement because the server issued a commit. So, the above insert will be committed successfully. But here is the problem: I tried to disconnect the session after issuing the DDL statement, but why again it’s asking for commit or rollback the cahnges?? Please tell me why it’s asking for commit or rollback the changes when the server issues an implicit commit for any DDL statements (even though the DDL fails)?