Oracle reports: Need help

[Shreya Menon]

Hi all,

We have a requirement where we need to extract data from two "schemas" and display them in an html page. The report is existing and we show data from one schema right now. But we have to show the data in 2nd schema also.

Right now we create reports using sql files and use Oracle views for selecting the data we want.

Can anyone please give me an example of how to acheive this ?

Thanks,
Maya

Edited: Maya
[ January 27, 2005: Message edited by: Shreya Menon ]