Re: Is this a bug?

Anurag Varma a écrit :

> The bug (or inconsistency as you might want to call it) is that oracle
> should not allow a column name and datatype to be of the same name IF
> the column name is not enclosed in double quotes.

> And oracle's advice?? Do you know who does not follow oracle's advice:
> ORACLE itself.

Indeed.

As I recall, TIMESTAMP has been introduced in Oracle 9. Disallowing it as a column name would have broken backward compatibility for *a lot* of customers.

This is a recurring problem whenever a language evolves. IMO, Oracle chose the lesser evil here...

Best regards, Anurag

• Raoul