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

-- 
Regards, Frank van Bortel