Re: keyword override
From: Chris Leonard <s_p_a_m_chris_at_hotmail.com>
Date: Mon, 1 Dec 2003 10:51:23 -0600
Message-ID: <kkKyb.750$eD2.15909_at_news.uswest.net>
Date: Mon, 1 Dec 2003 10:51:23 -0600
Message-ID: <kkKyb.750$eD2.15909_at_news.uswest.net>
Use double-quotes. Double-quoted object names are case-sensitive, by the way, so that
select "NEW" from transit ...
is not the same as
select "new" from transit ...
In other words, when you use double-quotes to delimit object names, the object names you specify must match the declared case in Oracle's catalog. This is because Oracle does *not* convert delimited text to upper-case before running your query.
-- Cheers, Chris ___________________________________ Chris Leonard, The Database Guy http://www.databaseguy.com Brainbench MVP for Oracle Admin http://www.brainbench.com MCSE, MCDBA, OCP, CIW ___________________________________ "Jeff Lambert" <jeffl_at_hypershell.com> wrote in message news:f17e7766.0312010758.769b7379_at_posting.google.com...Received on Mon Dec 01 2003 - 17:51:23 CET
> porting from SQL server to Oracle, how do I override keywords when
> accessing likewise-named columns, for instance [NEW]. I tried entering
> [NEW] in Oracle Procedure editor but NEW was still in blue.
>
> SELECT [NEW] FROM TRANSIT WHERE DOS_NAME = ...