OraFAQ Forum: Reports & Discoverer » Excluding SQL query data when linked with XML query

Home » Developer & Programmer » Reports & Discoverer » Excluding SQL query data when linked with XML query (Report Builder, 10g, win7)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Excluding SQL query data when linked with XML query [message #583186]

Fri, 26 April 2013 09:39

whoswho
Messages: 2
Registered: April 2013

Junior Member

Hello everybody,

I have data in a table and another in XML file,
I used SQL query to retrive the data placed on the table, and link this query with XML query that retrieves the data stored in the xml file.
The data stored in the table and xml file sharing a key field, but the xml contents are less than what in the table.
I want to show only the data shared between the two queries, how can I do that?

e.g.:
Table emp:

e_id | e_name | e_sal
023 | John | 6000
143 | Tom | 9000
876 | Chi | 4000
987 | Alen | 7800

XML File

<e_id>
143
876

So, I want the output to be:

e_id | e_name | e_sal | e_fee
143 | Tom | 9000 | 300
876 | Chi | 4000 | 100

Can you help me??

Thank you

Report message to a moderator

Re: Excluding SQL query data when linked with XML query [message #583188 is a reply to message #583186]

Fri, 26 April 2013 09:49

Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Use a join?

And where do come 300 and 100?

Regards
Michel

[Updated on: Fri, 26 April 2013 09:49]

Report message to a moderator

Re: Excluding SQL query data when linked with XML query [message #583192 is a reply to message #583188]

Fri, 26 April 2013 12:38

whoswho
Messages: 2
Registered: April 2013

Junior Member

I want to use right outer join, but how to do that???
I built the report as in oracle documentation:
Oracle Reports Building Reports
Subject: Building a Report with an XML Pluggable Data Source

and the link between XML & SQL queries seems to be left outer join, but I want it to be right outer join.

forget the data 300 and 100. They are examples for calculating fees.

Regards

Report message to a moderator

Previous Topic:	Rupee Image extension in salary
Next Topic:	print images on report based on data

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Nov 26 23:39:10 CST 2024