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

  • From: Thomas Kellerer <thomas.kellerer@xxxxxxxxxx>
  • To: "oracle-l@xxxxxxxxxxxxx" <oracle-l@xxxxxxxxxxxxx>
  • Date: Mon, 16 Dec 2013 13:46:29 +0100

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
--
//www.freelists.org/webpage/oracle-l


Other related posts: