Skip to Main Content

Integration

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!

Report on multiple data objects

Suneel JakkaJan 8 2013 — edited Feb 10 2020
I am not sure, I did this or not.. Is there a way to create a report on multiple data objects? My requirement is as follows

Data_object_A

Field1 Field2 Field3
1 ABC 123
2 DEF 456
3 GHI 789

Data_object_B

Field1 Field2 Field3
1 444 XYZ
2 555 STU

Over here I have a primary key and reference key as first column in the both data objects and I have to create a report by using equi-join..

that means I have to create a report with data from these above two data objects as below

select a.field1,a.field2,a.field3,b.field2,b.field3
from Data_object_A a, Data_object_B b
where a.field1=b.field2(+)

Regards,
Suneel Jakka
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Feb 26 2013
Added on Jan 8 2013
2 comments
339 views