• 2022-05-29 问题

    查看表INVOICE结构,下列哪个SQL语句能执行成功() A: SELEC B: inv_no,NVL2(inv_date,’Pending’,’Incomplete’)FRO C: invoice D: SELEC E: inv_no,NVL2(inv_amt,inv_date,’NotAvailable’)FRO F: invoice G: SELEC H: inv_no,NVL2(inv_date,sysdate-inv_date,sysdate)FRO I: invoice J: SELEC K: inv_no,NVL2(inv_amt,inv_amt*.25,’NotAvailable’)FRO L: invoice

    查看表INVOICE结构,下列哪个SQL语句能执行成功() A: SELEC B: inv_no,NVL2(inv_date,’Pending’,’Incomplete’)FRO C: invoice D: SELEC E: inv_no,NVL2(inv_amt,inv_date,’NotAvailable’)FRO F: invoice G: SELEC H: inv_no,NVL2(inv_date,sysdate-inv_date,sysdate)FRO I: invoice J: SELEC K: inv_no,NVL2(inv_amt,inv_amt*.25,’NotAvailable’)FRO L: invoice

  • 1