Skip to Main Content

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!

Take Full Advantage of the PLSQL Compiler!

Steven Feuerstein-OracleJan 29 2016 — edited Apr 29 2016

Comments

Frank Kulash

Hi, @user-e2y4b
This question was posted in the English-language space. There's a separate space for Spanish language:
Base de Datos Discusión General — oracle-tech
I'll try to move the thread there for you.

mathguy

Please note that this forum es solo en ingles. Either you state your question and accept answers in English, or look for a Spanish language forum (knowing that participation will be much more limited).
As to the error: Tables like AH135D are understood within the subquery (the join), but not outside it. The UPDATE statement only sees the result of the subquery, with its columns.
Either move the WHERE clause INSIDE the query, or give the subquery and its columns aliases and use those in the WHERE clause. (You may leave out the subquery alias - and perhaps even the column aliases, if there is no risk of confusion - but in a problem like this it is a best practice to alias the subquery and also the columns within it.)

1 - 2

Post Details

Added on Jan 29 2016
8 comments
1,115 views