"ORA-00942:表或视图不存在"用于混合案例表和列 [英] "ORA-00942: table or view does not exist" for mixed case table and columns

问题描述

更新混合大小写的表或列时，TOAD给出"ORA-00942:表或视图不存在".对于更新，我不编写任何查询，我正在尝试更新网格(数据选项卡)上的数据.对于大写的表和列，它会成功更新.由于某种原因，TOAD生成不带双引号的查询.有没有解决此问题的方法?

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?

推荐答案

TOAD中有一个选项可以将对象名称双引号.进入视图"菜单，选择"TOAD选项"，选择"Oracle/常规"条目，然后将双引号对象名称"更改为全部".

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

这篇关于"ORA-00942:表或视图不存在"用于混合案例表和列的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！