如果QUANTITY的值为空值(null),在执行以下哪个语句时会显示一个0
A.SELECT id_number, 100/quantity
FROM
inventory;
B.SELECT id_number, NVL(100/quantity, 0)
FROM
inventory;
C.SELECT id_number, NULL(100/quantity, 0)
FROM
inventory;
D.SELECT id_number, TO_CHAR(100/quantity, 0)
FROM
inventory;
E.SELECT id_number, NVL(100/quantity, ’999.00’)
FROM
inventory;