• 2022-05-28 问题

    如果QUANTITY的值为空值(null),在执行以下哪个语句时会显示一个0 A: SELECT id_number, 100/quantity B: FROM C: inventory; D: SELECT id_number, NVL(100/quantity, 0) E: FROM F: inventory; G: SELECT id_number, NULL(100/quantity, 0) H: FROM I: inventory; J: SELECT id_number, TO_CHAR(100/quantity, 0) K: FROM L: inventory; M: SELECT id_number, NVL(100/quantity, ’999.00’) N: FROM O: inventory;

    如果QUANTITY的值为空值(null),在执行以下哪个语句时会显示一个0 A: SELECT id_number, 100/quantity B: FROM C: inventory; D: SELECT id_number, NVL(100/quantity, 0) E: FROM F: inventory; G: SELECT id_number, NULL(100/quantity, 0) H: FROM I: inventory; J: SELECT id_number, TO_CHAR(100/quantity, 0) K: FROM L: inventory; M: SELECT id_number, NVL(100/quantity, ’999.00’) N: FROM O: inventory;

  • 1