Skip to Main Content
Forums

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

User_CXJFI

This would be incredibly helpful. Being able to pick a delimiter would solve the problem for me - it's a pain to process the CSV files right now as the data I'm querying seems to always strings with commas. Since I can't get the preview window to display all rows nor the size of the result set by default, I end up exporting every result set but have to do further processing in order to use it due to the comma limitations.

User_WRSVZ

+1 Being able to change the delimiter would be VERY helpful. Also being able to define the text identifier for the CSV would also be helpful.

Thanks all for the feedback about CSV delimiters. This is on our list of future features.

1 person found this helpful

Hi,
We just released version 19.3.4 which adds 2 settings for CSV delimiters and string encapsulation. Could you please try it out and let me know what you think?

Bjego
Answer

Looks good thank you!

Marked as Answer by Bjego · Mar 24 2021
1 - 5
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Feb 26 2013
Added on Jan 8 2013
#integration-b2b, #integration-general, #soa-process-management
2 comments
338 views