When NO_Transaction auto commits the transactions, what do we do in case of any errors?
To be more clear for example, we are performing an insert of 100 rows into a table and have used NO_transaction as transaction type. The connection is lost after inserting some 40 rows and the transaction has failed. As it is an auto commit and we cannot roll back this transaction, what do we do in this case?
When it has this drawback, why do we use NO_transaction? where exactly do we use no_transaction?
please give me an example for each type of transaction