• 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;