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
答案解析:有

微信扫一扫手机做题