Hi

I came across this post and it was the same situation as mine

My update statement kept returning an 'ORA-01407' error even though I know for definite that the value I was updating with wasn't null

I added in the extra which exists (select null.....) bit and it worked fine! Could someone please explain the logic behind how that makes it work please?


Thanks!!!
Maria