Have a look here for more information:

http://sqlinthewild.co.za/index.php/2009/03/19/catch-all-queries/

In particular, look at the way that dynamic SQL is used but it's still parameterised (avoiding the risk of SQL Injection).

Alternatively, I believe that...

I really...

Are the below two objects tables or views?:

[tbl_233421d595dc4719b2429d27bf5a0399_\PreparingFactTable\CommissioniPerformance\FactTab]

[tbl_527741baf48446da94b7e767ed004314_\PreparingFactTable\CommissioniPerformance\FactTab]

Can you post the DDL for these if they're views?

lindbergh_ddv (2/1/2011)

---

So the question is conceptual, for me: is it possible that the same query has different result (and I mean different num rows and different values) depending of that...

Can you post the actual view's and create table scripts?

You may be doing something in the views that relies on an arbitrary order (e.g. TOP or Row_Number() without ordering by...

I don't see anything in the OP's code that doesn't take multi-row DML into account.

The only thing I can think is that triggers do not fire for BULK INSERT...

Ah hah - thanks Gail!

Oracle's query tools (Oracle SQL Developer and SQLPlus) by default require you to explicitly commit regardless of whether you explicitly began a transaction.

So, if you perform an update/delete operation, you...

Why do you need a self join? Assuming the sub query is the same table as the one you're deleting from (as per your example) you just need a straight...

It should be worse the other way round to be honest. When you move into Daylight Saving Time, there is no 01:00 to 01:59, so I would assume that any...

I think Wayne's right. Basically, anything that's scheduled to run between 01:00 and 01:59 will execute at the first occurence of that time. No job schedules at all run between...

Are both CPU time and elapsed time lower on Procedure B? If it's just elapsed time, it could be generating a parallel execution plan for Procedure B, which although completing...

A case expression can only return a single data type. As your first case expression returns an integer, all other results must be integer. As a blank string is implicitly...

ALZDBA (10/15/2010)

---

btw not so long ago, I had a bird strike whilest riding my bike. It hit me on top of my helmet, right above the vizor. It was a...

Well designed virtual infrastructure (by this I mean well set up Virtual Server farms where the resources arent overallocated, running on well configured modern hardware) can be an excellent solution...