Claus Pedersen
Member³
On an 11g database, I have a table with the column test. I edit the table and add the extra text 'ing' to column name test, so the resulting name is TESTing before I press Apply. After refresh, the column name is now a mix of upper and lower case letters TESTing, as opposed to the rest of the columns that are all uppercase.
When I write SQL using the new column testing from the table, I get an error, as the column name has become "TESTing" and not testing.
If I use uppercase letters in the table editor, it works OK.
This is an error that occurs in 11g databases, as it is much more case sensitive than the 10g databases.
If I change the name by rightclicking on the column name in the editor and select Rename, it works OK.
When I write SQL using the new column testing from the table, I get an error, as the column name has become "TESTing" and not testing.
If I use uppercase letters in the table editor, it works OK.
This is an error that occurs in 11g databases, as it is much more case sensitive than the 10g databases.
If I change the name by rightclicking on the column name in the editor and select Rename, it works OK.
