单选题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 EXT
题目
单选题
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
相似考题
参考答案和解析
正确答案：
D
解析：
暂无解析