What is Flashback Transaction Qurey in oracle 11g r2

In this tutorial i'll show you how Oracle Flashback Technology works and as well as inside how to use flashback version query.

In Oracle there are Seven Technology as given below.
   In the Flashback Technology, It include database related group of features that manage a state of your data in the database.

   This Technology works on the undo data so you can get all those transaction, query as well as data from undo segments thus, your can recovery your data which had been lost or damage as well as you can see the query which had been perform on a specific time or SCN. 

1. Flashback Query.
2. Flashback Transaction.
3. Flashback Transaction Query. 
4. Flashback Version Query.
5. Flashback Table.
6. Flashback Database.
7. Flashback Data Archive [ Total Recall ]. 

 Some few advantages given below,

• See the query had been perform.
• See the transaction information.
• See the past state data.
• You can perform rollback entire table without performing database recovery.
• If you delete or drop the table by mistake and you perform DDL or commit without knowing the previous transaction.  and so on...

Here i'll be show you 3^rd  Flashback Transaction Query as below,

   Using this tool you can view changes to made to the database at transnational level.
The main banifit is that you do not need to audit of your database transaction because of directly you can get the what transaction is perform in this database.
 
   You can get all the view by using FLASHBACK_TRANSACTION_QUERY [ no prefix like V$, GV$ , .. ]  is a dynamic performance view.  


   Using this view you can get all the information like specific query, during specific time duration, etc.

  Some situation as given below,

1. You can get dropped table from database
2. If any user executed transaction drop, those information you can also get.
3. DDL command display the changes mad to the data-dictionary.

    For example

1. Connect with normal user  [ here i am connect with hr user ].
2. After create new table [ here i am create a 'tushar' table ].
3. After enter some values in this table.

Create Table and Entered Value

      4. After Connect with user who have sysdba privileges.
      5. After execute FLASHBACK_TRANSACTION_QUERY and according your requirement
         [ here i'll see you tushar table's fired query ].

Flashback Transaction Query

      6. After you can see the output according to your query.

That was the Flashback Transaction Query in oracle 11g.