|
-
Originally posted by bensr
Did u use nvl at both sides:
nvl(C1_REC.group_ofstudy, '?') = nvl(C3_REC.value,'?')
Yes, I did use NVL on both sides...
nvl(C1_REC.group_ofstudy, '*') = nvl(C3_REC.value,'*')
Moreover, the following shows existence of NULL values in both tables on the left & right of the WHERE condition.
TUNE: U_HRENG> select count(*) from d_sip_config_single where value is null;
COUNT(*)
----------
1
TUNE: U_HRENG>
Last edited by ggnanaraj; 01-20-2003 at 11:46 PM.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|
Reply With Quote