Question:

We have a scenario where I need to capture change in every column of every table in my database. The process of retrieving the old and new data as and when required as per the transactions are concerned.  I have heard about Change data Capture, and versioning.

Answer:

You need to look at Oracle auditing, which will record all changes to the specified tables.  The downside is that it takes lots of disk space and may slow-down your database.  Arup Nanda and I have details in our Oracle fine-grained auditing book:

http://www.rampant-books.com/book_2003_2_audit.htm

And here are free whitepapers:

http://dba-oracle.com/oracle_news/2005_3_31_free_white_paper_database_auditing.htm

You can also use Oracle Logminer for this task:

http://www.praetoriate.com/oracle_tips_logminer.htm