![pl sql prompt pl sql prompt](https://www.oracletutorial.com/wp-content/uploads/2017/11/plsql-anonymous-block-sql-developer-step-3.png)
Whenever you type Exit and terminate the SQL Prompt, a commit is automatically executed. However, a commit statement is not necessary in case you issue create table statement as it automatically performs a commit statement after completion. The transaction probably ends if a rollback or a commit statement is entered into the database. It also starts when you type any PL/SQL statement. It usually begins when you hit the very first SQL statement may be to log in to the system. Unless a commit command is not followed by a transaction, it can be rolled back and all changes made by the statement(s) can be undone.Ī PL/SQL transaction has a beginning and an ending. Each of it is unaware of other active transaction until a particular transaction terminates.Ĥ. Durability: This property ensures that if a transaction is made and a commit command is executed, then everything gets saved in the database even if the database closes down abnormally.Ī successfully accomplished PL/SQL statement and a transaction which is issued a commit command are not the same. Consistency: This property ensures that if the database was in a consistent format before the transaction then it will be in a consistent after the next Transaction as well.ģ. Isolation: This property implies that the action taken or performed by one transaction is hidden from outside transaction or other transactions. These are listed down:ġ. Atomicity: This property ensures that either all the changes occur or nothing is changed at the end of the transaction.Ģ. There are few properties which every stable database should consist of. In a multi-user environment, every user is working with his own transaction independence, keeping the database in an inconsistent format.
![pl sql prompt pl sql prompt](https://static.packt-cdn.com/products/9781785281273/graphics/B04512_02_16.jpg)
A transaction can access and manipulate various data items. A PL/SQL transaction is a collection of operations or instructions which is executed as a whole atomic unit.