SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

using NVL function in subselect of an update

537177Apr 28 2007 — edited Apr 29 2007

Hi,

nvl is not working in my situation

Here is my select
SELECT nvl(a.id, 'WAS NULL') FROM table_1 a, table_2 b
WHERE a.id=b.id;

Now here I get NULL instead of 'WAS NULL' as I accepted.

Table a and table b do not have any identical ids, still I need to be a value returned.
Is there a way?

Thanks

Locked Post

New comments cannot be posted to this locked post.

Locked on May 27 2007

Added on Apr 28 2007

11 comments

5,905 views