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!

SQL Update command send me "ORA-00903: invalid table name" error

Hi all,
My query works well with SELECT command but, when I try to use the UPDATE command, I have the error listed above.
There is my query :
update PER_EMAIL_ADDRESSES
set EMAIL_ADDRESS='fausseAdresse@yopmail.com'
where EMAIL_ADDRESS_ID=(select CAND_EMAIL_ID
from IRC_CANDIDATES
where CANDIDATE_NUMBER=1123028
)

Could you explain me what's wrong here ?

Comments

Processing

Post Details

Added on Nov 22 2022
3 comments
366 views