We have an ASP.NET MVC application that uses the Entity Framework. The app was built using a model-first approach. The object model was created, and then the SQL commands to generate the schema was generated from the model.
The problem is that all of the object names (tables, columns, etc.) are all case sensitive.
PL/SQL does not work with case-sensitive names unless the names are manually entered with quotes around all of the names. For example, if I right-click a table name and select menu "Query data", it won't work because PL/SQL creates a command like:
select * from Table t
(no quotations around table name)
instead of
select * from "Table" t
(with quotations around table name)
Another example: if I drag a table onto a SQL window, I get something like this:
select col1, col2 from table
which doesn't work because all of the names are forced to be in lowercase, and with no quotations around the names.
Worse, I can't use some of the Tools menu items such as exporting, because PL/SQL doesn't handle the names correctly and all I get are "table or view does not exist" errors.
I found some threads on this topic, but no solutions for it, nor details on plans to address it.
I can't believe that case-sensitive names are not yet handled by PL/SQL. Am I wrong? If I am, can someone please tell me how to get PL/SQL to work with case-sensitive names.
Thanks in advance.
The problem is that all of the object names (tables, columns, etc.) are all case sensitive.
PL/SQL does not work with case-sensitive names unless the names are manually entered with quotes around all of the names. For example, if I right-click a table name and select menu "Query data", it won't work because PL/SQL creates a command like:
select * from Table t
(no quotations around table name)
instead of
select * from "Table" t
(with quotations around table name)
Another example: if I drag a table onto a SQL window, I get something like this:
select col1, col2 from table
which doesn't work because all of the names are forced to be in lowercase, and with no quotations around the names.
Worse, I can't use some of the Tools menu items such as exporting, because PL/SQL doesn't handle the names correctly and all I get are "table or view does not exist" errors.
I found some threads on this topic, but no solutions for it, nor details on plans to address it.
I can't believe that case-sensitive names are not yet handled by PL/SQL. Am I wrong? If I am, can someone please tell me how to get PL/SQL to work with case-sensitive names.
Thanks in advance.
