Dear Exparts,
Report Builder 10.1.2.3.0
ORACLE Server Release 10.1.0.5.0
Oracle Procedure Builder 10.1.2.3.0
Database 10g R2
Demo 1 is the master Data. Under demo1 is it's history. Thats means ID 1,2,3 are the history of Demo1.
Yea, i'm looking for the
history change of Demo 1.
For your clear description Look at the bellow data and the report.
Here is the sample data and reports..
/* data history for Demo 1 */
Demo 1
Id Date Name Col1 Col2 Col3 Col4 Col55 Col56 Col N
1 01-aug-2012 Abc Ab Bc aa bb TT
2 05-aug-2012 abc A A aa bb TT
3 20-aug-2012 bcd AA AA BB bb C D TT
/*reports looks */
Demo 1
Revision Date Revision Field Previous Value Revised Value
05-aug-2012 Col1 Ab A
Col2 Bc A
20-aug-2012 Name Abc Bcd
Col1 A AA
Col2 A AA
Col3 Aa BB
Col55 C
Col56 D
Note: I have more then 50 of columns and i need only data changes column and it's data.
Thanks in advance