Skip to Main Content

DevOps, CI/CD and Automation

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

How i generate this reports ?

Asked to LearnSep 3 2012 — edited Sep 4 2012
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

Comments

Processing
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Oct 2 2012
Added on Sep 3 2012
2 comments
114 views