469,127 Members | 1,327 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,127 developers. It's quick & easy.

Help required

1
Hi,
I want to do a comparison according to below requirement

SELECT BOM.PRODUCT_CODE PRODUCT_CODE, PART.PART_NUMBER PART_NUMBER, BOM.REV REV, BOM.MIX MIX,
DECODE(PART.REPLACEMENT_PART_NUMBER,NULL,PART.PART _NUMBER,PART.REPLACEMENT_PART_NUMBER) MASTER_PART,substr(1,material_group,null)
FROM SPT_BOM_MST BOM, SPT_PART_MST PART
WHERE BOM.PRODUCT_CODE = 'NTE-NTFP83'
AND BOM.PART_NUMBER = PART.PART_NUMBER
AND PART.MATERIAL_GROUP <> 'EXCL'


but the problem is there are some blank strings as well as nulls in material group field. can some one help me out in getting this comparison
Jan 3 '07 #1
1 931
Hi,
I want to do a comparison according to below requirement

SELECT BOM.PRODUCT_CODE PRODUCT_CODE, PART.PART_NUMBER PART_NUMBER, BOM.REV REV, BOM.MIX MIX,
DECODE(PART.REPLACEMENT_PART_NUMBER,NULL,PART.PART _NUMBER,PART.REPLACEMENT_PART_NUMBER) MASTER_PART,substr(1,material_group,null)
FROM SPT_BOM_MST BOM, SPT_PART_MST PART
WHERE BOM.PRODUCT_CODE = 'NTE-NTFP83'
AND BOM.PART_NUMBER = PART.PART_NUMBER
AND PART.MATERIAL_GROUP <> 'EXCL'


but the problem is there are some blank strings as well as nulls in material
group field. can some one help me out in getting this comparison


so the last condition write it down this way
AND (PART.MATERIAL_GROUP IS NULL or PART.MATERIAL_GROUP <> 'EXCL')
and instead of plane material_group in substr
use NVL(material_group,
Jan 4 '07 #2

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

6 posts views Thread by mike | last post: by
reply views Thread by Vish | last post: by
3 posts views Thread by Tim::.. | last post: by
11 posts views Thread by Naeem | last post: by
36 posts views Thread by aljamala | last post: by
5 posts views Thread by forest demon | last post: by
1 post views Thread by CARIGAR | last post: by
reply views Thread by Mortomer39 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.