Skip to Main Content

SQL & PL/SQL

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
Post Details
Added on Nov 22 2022
3 comments
94 views