ALTER Row

We are UPDATING a field in SQL and ALTER the row also. After giving the COMMIT command the system is crashed. What will happen to the commands given, whether it will UPDATE and ALTER the table or not?

sweetysmarty
Profile Answers by sweetysmarty Questions by sweetysmarty
Apr 19th, 2010
18
8843

Questions by sweetysmarty answers by sweetysmarty

SQL

Answer

Showing Answers 1 - 18 of 18 Answers

prashant.shirol
Profile Answers by prashant.shirol

Apr 20th, 2010

It will not save the data

manimehra905
Profile Answers by manimehra905

May 18th, 2010

The changes made before crash will get lost.

sujit.sahoo
Profile Answers by sujit.sahoo

May 21st, 2010

Whenever a DML statement is fired and then we are firing a DDL statement then all the transaction will get committed. Because in all the DDL statements auto commit is on. so when you do an ALTER after UPDATE, all the records will get committed.

ashishmisra78
Profile Answers by ashishmisra78 Questions by ashishmisra78

May 25th, 2010

It will commit the data that has been updated, as Oracle implicitly commits before or after a DDL statement

Raj_P
Profile Answers by Raj_P Questions by Raj_P

Sep 1st, 2010

It depends on the sequence of the transactions.
1) DML -----> DDL -----> Crash = You will get the data.
2) DDL -----> DML -----> Crash = You will lost the data.

neha.awasthi1
Profile Answers by neha.awasthi1 Questions by neha.awasthi1

May 30th, 2011

since alter command is DDL and DDl are self commit command so the changes will appear.