From: fbortel@nescape.net   
      
   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   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)