I use the query below:
update ACCOUNT_EXTERNAL_IDS
set EXTERNAL_ID = 'username:vietnt'
where ACCOUNT_ID='1000000'
and EMAIL_ADDRESS='NULL'
It shows the error:
ERROR: Column "USERNAME" not found; SQL statement:
update ACCOUNT_EXTERNAL_IDS set EXTERNAL_ID=username:vietnt where ACCOUNT_ID=1000000 and EMAIL_ADDRESS=NULL [42122-147]
I use back slash \, then, the query become:
update ACCOUNT_EXTERNAL_IDS
set EXTERNAL_ID = 'username\:vietnt'
where ACCOUNT_ID = '1000000'
and EMAIL_ADDRESS='NULL'
The error is the same.
JavaScript questions and answers, JavaScript questions pdf, JavaScript question bank, JavaScript questions and answers pdf, mcq on JavaScript pdf, JavaScript questions and solutions, JavaScript mcq Test , Interview JavaScript questions, JavaScript Questions for Interview, JavaScript MCQ (Multiple Choice Questions)