CODEWITHSUNDEEP
oracle-databasetoadora-00942quoted-identifier
rovsen
rovsen

Reputation: 5022

"ORA-00942: table or view does not exist" for mixed case table and columns

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?

Upvotes: 0

Views: 4488

Answers (1)

GriffeyDog
GriffeyDog

Reputation: 8386

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".

Upvotes: 3

Related Questions