Case-sensitive oracle table names

Oracle table names are case-sensitive. oracle is not case-sensitive. It does not remove double quotation marks when creating a table. Create table TableName (id number); // although the data is written in uppercase and lowercase, It is not distinguished in the database. Select * from tablename; // You can SELECT * from tablename; // if you write this statement, SELECT * FROM TableName; // create table "TableName" ("id" number); // if this is the case when creating a TABLE, SELECT * FROM "TableName"; // SELECT * FROM "TableName" must be case sensitive and must be enclosed in double quotation marks to distinguish it FROM the third query method above. So the problem is not oracle, but that your colleagues did not remove double quotation marks when creating the table. It is better to change the table than to change the SQL statement.