Re: Schroedingers Job - a job exists but doesn't at the same time.

From: Thomas Kellerer <thomas.kellerer_at_mgm-tp.com>
Date: Mon, 16 Dec 2013 13:46:29 +0100
Message-ID: <52AEF625.5090603_at_mgm-tp.com>



Tim Gorman, 16.12.2013 13:43:
> I'm struck by your usage of the UPPER function in all your queries. What happens if you re-run those queries without the use of UPPER?

I used that to make sure that I don't miss anything that _might_ have been create in lowercase (or mixed case).

As I'm comparing that value with an all uppercase value, it should return any object regardless whether it was created in lower, upper or mixed-case.

Regards
Thomas

--
http://www.freelists.org/webpage/oracle-l
Received on Mon Dec 16 2013 - 13:46:29 CET

Original text of this message