Hi All,
I am using Oracle database. I want to use Union All option to see all the rows of 2 queries. But Union All option is not available in the Reporter.
What is the alternative to this?
ManasP (BOB member since 2004-03-09)
Hi All,
I am using Oracle database. I want to use Union All option to see all the rows of 2 queries. But Union All option is not available in the Reporter.
What is the alternative to this?
ManasP (BOB member since 2004-03-09)
If I recall correctly, the difference between UNION and UNION ALL is that UNION eliminates identical rows returned by each SQL statements. So if there’s something you can do to the data providers to ensure they don’t return duplicate rows, won’t UNION work the same as UNION ALL? For example, could you insert some unique text object into each separate data provider? I havent tested this, but it seems as though it might work.
sunspot (BOB member since 2003-03-12)
Thanks a lot,
I got the Logic. And yes, it is working…
ManasP (BOB member since 2004-03-09)
You can change your prm file to union or union all.
SteveBickerton (BOB member since 2002-08-15)