For MySQL table data cannot be viewed when the database or table name includes a special character like '-'. The automatically generated SQL statement does not quote the database or table name. How to solve/work around this?
My database has a name like dbu11-test and when trying to view the data of a table the generated SQL looks like this:
select * from dbu11-test.tableName
But this is invalid SQL-Syntax:
"You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '-test.tableName' at line 1"
TOra version 2.1.3