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