If I right click on a table in the browser to query data when the table is in another schema than the one I am logged into and that other schema starts with '#', then the resulting sql window gets ORA-00911:invalid character.
Is there something I can do to make PL/SQL Developer (6.04) double_quote and capitalise the schema name?
eg: 'select * from #user.tablename' needs to be 'select * from "#USER".tablename'
Is there something I can do to make PL/SQL Developer (6.04) double_quote and capitalise the schema name?
eg: 'select * from #user.tablename' needs to be 'select * from "#USER".tablename'