Re: help: what is the difference between "xx" and xx

From: Richard Kuhler <noone_at_nowhere.com>
Date: Wed, 17 Apr 2002 01:03:55 GMT
Message-ID: <%R3v8.50681$zN.23138234@twister.socal.rr.com>

The database is case sensitive even though Oracle converts most things to uppercase. However, when you put an identifier in quotes it is taken in the case given (lowercase in your example). Presumably, the constraint was created in lowercase (it should appear that way in dba_constraints as well).

Richard

Joe Sath wrote:
>
> I have a constraint, when I search against the dba_constraints, it shows up
> as cons_fk_a,
> but when I use alter table bla drop constraint cons_fk_a, I got an error
> that nonexistent,
> I have to use
>
> alter table bla drop constraint "cons_fk_a".
>
> While some other constraints do not have the problem.
>
> why?
>
> Thanks for your help.
Received on Tue Apr 16 2002 - 20:03:55 CDT