Skip to Main Content
Forums

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

What's wrong with this sql? SQL valid but query is invalid?

oatsMar 12 2009 — edited Mar 13 2009
What does this kind of error mean? vwKUnits is a view in the same schema, why is it not found?

SELECT KUnits_0.UNIT_SYN f, KUnits_1.UNIT_SYN t
FROM CONV, vwKUnits KUnits_0, vwKUnits KUnits_1
WHERE CONV.FROM_UNITS=KUnits_0.UNIT AND CONV.TO_UNITS=KUnits_1.UNIT

The SQL syntax is valid, however the query is invalid or uses functionality that is not supported.

Cannot find relation vwKUnits.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Apr 10 2009
Added on Mar 12 2009
6 comments
1,258 views