TOAD gives "ORA-00942: table or view does not exist" when updating mixed case tables or columns. For update I do not write any queries, I am trying to update data on grid (data tab). For upper case tables and columns it updates sucessfully. For some reason TOAD generates query without double quotations. Are there any workarounds for this issue?
0
votes
Are you bound to using Toad? What queries do you want to generate exactly? What tool of Toad are you using (SQL worksheet, and when you press CTRL-ENTER your query does not work?)
– Benoit
@archstanton whats the actual SQL?
– tbone
updated question. I am trying to update data on grid, not by writing query.
– rovsen
The best solution is never, ever, create cased object names. Only ever use the default. If you don't it only leads to problems, as you're discovering. I know nothing about Toad, so I can't help you with your specific problem.
– Ben
@Benoit - TOAD is so very nice.. that's why :)
– Randy
