试题详情
单项选择题How should the following UDF be invoked in order to convert US currency values stored in the EXPENSES table into Canadian currency?CREATE FUNCTION getratews11 ( country1 VARCHAR(100), country2 VARCHAR(100) ) RETURNS DOUBLE LANGUAGE SQL CONTAINS SQL EXTERNAL ACTION NOT DETERMINISTIC BEGIN ... END（）

A、CALL getratews11('USA','CANADA')

B、CALL expenses.getratews11('USA','CANADA')

C、SELECT getratews11('USA','CANADA') FROM expenses

D、SELECT * FROM TABLE(getratews11('USA','CANADA')) AS convert_currency

  • C

  • 关注下方微信公众号，在线模考后查看

热门试题