Table SALES_TABLE contains the columns COUNTRY and SALES. unction calc_tax calculates sales tax based on input parameter SALES. Using a scripted calculation view, how can you call the calc_tax…

Question

Options

• A:v_tax = SELECT COUNTRY, CALL :calc_tax(SALES) AS TAX FROM :SALES_TABLE;
• Bv_tax = SELECT COUNTRY, calc_tax(SALES) AS TAX FROM SALES_TABLE;
• C:v_tax = CE_PROJECTION(SALES_TABLE, ["COUNTRY","CALL :calc_tax(SALES)"]);
• Dv_tax = CE_PROJECTION(SALES_TABLE, ["COUNTRY","calc_tax(SALES)"]);

• A
  14% (5)
• B
  73% (27)
• C
  3% (1)
• D
  11% (4)

No community discussion yet for this question.