Recently I created a new application in APEX 18.2.
I notice that APEX adds double quotes to the fields in the SQL-query source for a form or report.
In addition, when working in the SQL Workshop/SQL commands, I need to add double quotes myself to selected fields.
So:
SELECT "id" FROM table_X does work
SELECT id FROM table_X will not work
In the latter case it will give me the error message: ORA-00904: "ID": invalid identifier
This is opposite to a previous application where the syntax is without the double quotes, which I consider as normal.
Why this difference and how can I get rid of the required quotes ?