Error "ORA-00942: table or view does not exist" when using substitution variables to represent sc (4284893)

立即与支持人员聊天

反馈已提交

本文是否解决了您的问题？

选择评级

标题

Error "ORA-00942: table or view does not exist" when using substitution variables to represent sc
说明

When using a substitution variable to represent a schema (or user) object in a query, TOAD 9.0.1 throws the error "ORA-00942: table or view does not exist" even when "Prompt for substitution variable" is checked.

For example, TOAD Editor in 9.0.1 will not accept the follow code.

SELECT * FROM &X.Table_Name;
SELECT * FROM &&X.Table_Name;

&X and &&X represent some schema.
原因

Oracle syntax issue. This will not work in SQL PLUS either.
解决办法

Oracle standard requires the use of two dots (..) in substitution variables where the variables stand for some schema.

For example,

SELECT * FROM &X..Table_Name;
SELECT * FROM &&X..Table_Name;

Again &X and &&X stand for some schema. The above queries compile with Oracle standard and will work on both in SQL PLUS as well as TOAD 9.0.1 Editor.

反馈已提交

本文是否解决了您的问题？

选择评级

建议的内容

标题