TYPE reserved word
CometJan 22 2009 — edited Jan 26 2009A former company analyst created a view and named one of the columns TYPE. I noticed in SQL Developer that it is highlighted in boldface when I reference it indicating TYPE is a reserved word. When I reference the column in a query either as a column or as part of the selection criteria I get the error message:
ORA-0094: "AP018"."TYPE": invalid identifier
AP018 is the name of the alias and the reference to the column name in the query is without quotes. I tried with quotes and without quotes but I get the same error message. I want to reuse the query as-is rather than create a new one for my project. I don't want to change the name of the column because I don't have the resources now to check which production reports use this column. Is there a work around?
Thank you, Ned
Edited by: Ned Epstein on Jan 22, 2009 1:00 PM