Sample Header Ad - 728x90

System-level way to enforce that reserved words may not be used for Oracle column names?

0 votes
1 answer
265 views
Is there a way in Oracle 12c to enforce that reserved words / keywords may not be used as column names? I am aware that it is not good practice to use keywords in this way. However from what we have observed, tables are able to be created with a column name of the reserved word "password" in our local Oracle, but the customer found that the table was was not being created on their Oracle environment. A complication here is that the tables are being created by a Java application which uses Hibernate to create the tables and these are not simply DDL statements. I have seen the related question: https://dba.stackexchange.com/questions/148350/oracle-add-reserved-word-as-column-name and I realise that the use of reserved words is permitted inside quotes, but I was wondering is there an system level "strict" mode that prevents the creation of tables with reserved words?
Asked by Phil (101 rep)
Oct 30, 2018, 02:30 PM
Last activity: Oct 31, 2018, 09:54 AM