|
No select and Insert are DML statements and wont provide an autocommit, 'select' infact dont have to be comitted as u are just viewing data that has already been written to datafiles, insert may be lost if hav an abnormal shutdown occur.
But for DDL statements that i mentioned before u will hav ur changes auto commited as soon as u perform them and these doesnt require a clean shutdown.
|