Hi, Dude:
I would understand why when sub query raises exception, the query can continue? given the following statement:
delete *
from A
where cntl_number in
(select cntl_number
from B)
the sub query fails because we give the wrong column name, however, to my surprise, Oracle executed the statement and delete the rows of table A completely. now we have to recover it. when I executed the sub query, it returned the ORA-00904 invalid identifier because column name was wrong. I wonder if this is due to some configuration in Oracle?
Thank you very much!
Sam