6.5 gives us this feature which allows us to use inline sql. This got me thinking about the oracle exists/not exists. Why is this not available through BO - is it an oracle only feature?
When we moved from 8i to 9i we had a handful of queries which contained subqueries which ceased to run. The solution was to recreate the query using Exists…I wonder if there is something obvious I’m not seeing here.
Nick Daniels 
(BOB member since 2002-08-15)
Please, can you be more specific? We upgraded from Oracle 8i to 9i and did not face such a problem.
The Oracle SQL statement EXISTS works just fine for me - and yes, I believe this is a DBMS specific SQL command in Oracle.
Andreas 
(BOB member since 2002-06-20)
What I am saying is that in the 8i to 9i we had a problem with just one or two reports built with subqueries. They went from running in say 5 minutes to still doing nothing after an hour. Re-writing the sql to use the exists clause fixed it - but to implement that in BO involves frigging the sql - or creating a rather specific object.
But that was just background colour, if you like. If exists/not exists is oracle specific then maybe thats the reason you can’t generate it on the fly in BO…
Nick Daniels 
(BOB member since 2002-08-15)
I don’t know if it’s ANSI SQL or not – but EXISTS / NOT EXISTS is not only in Oracle – it’s in Sybase SQL as well.
Anita Craig 
(BOB member since 2002-06-17)
Okay…so why isn’t it directly support by the query panel - anyone?
Nick Daniels (BOB member since 2002-08-15)
Because they decided not to. 
Seriously, I don’t know of a reason. They could have done a “wizard” like they did for the correlated sub-query option if they felt it was too difficult. But it certainly would be nice to see.
Dave Rathbun 
(BOB member since 2002-06-06)
This article seems to imply that EXISTS is part of ANSI SQL.
Nick, you could always put in an enhancement request with Business Objects 
Sounds like a query optimizer problem, did you try running those queries using Oracle Hints?
Andreas (BOB member since 2002-06-20)