可学答题网 > 问答 > IBM(000-730)题库
目录: 标题| 题干| 答案| 搜索| 相关
问题

How should the following UDF be invoke


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()

  • ACALL getratews11('USA','CANADA')
  • BCALL expenses.getratews11('USA','CANADA')
  • CSELECT getratews11('USA','CANADA') FROM expenses
  • DSELECT * FROM TABLE(getratews11('USA','CANADA')) AS convert_currency
参考答案
参考解析:
分类:IBM(000-730)题库