keyword override

[Jeff Lambert]

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 = ...

[Chris Leonard]

Re: keyword override

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@hypershe ll.comwrote in message
news:f17e7766.0 312010758.769b7 379@posting.goo gle.com...

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 = ...

[Frank]

Re: keyword override

Jeff Lambert wrote:

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 = ...

alias the tables:
select emp.x, dpt.x from employees emp, departments dpt
where ...
You may even use the 'as' keyword to distinguish the column headers:
select emp.x as employee_name
, dpt.x as department_name
from employees emp
, departments dpt
where ...

--
Regards, Frank van Bortel