0

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?

rovsen
  • 4,932
  • 5
  • 38
  • 60
  • 2
    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 Feb 28 '12 at 12:31
  • @archstanton whats the actual SQL? – tbone Feb 28 '12 at 13:39
  • updated question. I am trying to update data on grid, not by writing query. – rovsen Feb 28 '12 at 13:45
  • 4
    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 Feb 28 '12 at 14:18
  • 1
    @Benoit - TOAD is so very nice.. that's why :) – Randy Feb 28 '12 at 17:26

1 Answers1

3

There is an option in TOAD to double-quote object names. Go into the View menu, choose TOAD Options, select the Oracle/General entry, and change the Double Quote Object Names to "All".

GriffeyDog
  • 8,186
  • 3
  • 22
  • 34