How to distinguish NULL and empty string on an outer join query in oracle
Posted on 2009-05-18
I have a query which has a full outer join.
The thing is, I need to distinguish which value in the joined column is really missing from the other table and which one is there but is empty.
Is there such a way to distinguish this?
FULL OUTER JOIN T2 ON T1.A = T2.B
The plan is if the T1 has the record even if the value is empty, the user can edit the value. If it is really not in the table, it is just in read only mode. To see the difference with the T2.