Re: Problem dropping a view

From: Hans Forbrich <forbrich_at_telusplanet.net>
Date: Wed, 30 Apr 2003 14:27:27 GMT
Message-ID: <3EAFDC32.F8CC23BD@telusplanet.net>

"Michael L. Hostbaek" wrote:

> Aleksey Kochetov tried to tell us something, and all I got was:
> > drop view "nego_offer";
> >
>
> *argh* how could it be so simple !?!
> Why is it, that all the other views I had worked when specified
> unquoted?

(Apologies Aleksey for jumping in)

Oracle (as many other DBMSs) uppercases object name and a lot of other stuff, other than quoted data strings, automatically. Doublequote means do not do this.

General suggestion is to not use " when creating your objects. All references to those objects in the future will need the same doublequotes. Received on Wed Apr 30 2003 - 09:27:27 CDT