There is a table in which the column is called DATE and when trying to select this column the oracle does not let. Does anyone have an idea what to do?

Question

SELECT A.DATE FROM TESTE A;

ORA-01747: invalid specification for user.table.column, table.column or column 01747. 00000 - "invalid user.table.column, table.column, or column Specification"

After I tried to run looking at the DUAL table but it also didn’t work.

SELECT DATE FROM DUAL;

ORA-00936: expression not found 00936. 00000 - "Missing Expression"

I would like to see if anyone has an alternative without being to change the field nomenclature, otherwise I will need to talk to the dba.

From now on I thank you all.