Oracle PLSQL Tutorial Transaction 17 codes

1 ACID Transaction Properties, Transaction Locking and Transaction Isolation Levels

2 Commit in a function

3 Committing and Rolling Back a Transaction

4 DBMS_FLASHBACK ENABLE_AT_SYSTEM_CHANGE_NUMBER() procedure enables you to perform a flashback to an SCN

5 Granting the Privilege for Using Flashbacks

6 Query Flashbacks

7 Savepoints

8 Set the transaction isolation level using the SET TRANSACTION statement

9 SET TRANSACTION READ WRITE

10 Set transaction isolation level read committed

11 Set transaction isolation level to serializable in PLSQL

12 Starting and Ending a Transaction

13 System Change Number Query Flashbacks

14 Time Query Flashbacks

15 To disable a flashback, you execute DBMS_FLASHBACK DISABLE()

16 Transactions and Savepoints

17 Use Rollback to discard changes