130. Which three statements are true regarding single-row functions? (Choose
three.)
A. They can accept only one argument.
B. They can be nested up to only two levels.
C. They can return multiple values of more than one data type.
D. They can be used in SELECT, WHERE, and ORDER BY clauses.
E. They can modify the data type of the argument that is referenced.
F. They can accept a column name, expression, variable name, ora usersupplied
constant as arguments.
three.)
A. They can accept only one argument.
B. They can be nested up to only two levels.
C. They can return multiple values of more than one data type.
D. They can be used in SELECT, WHERE, and ORDER BY clauses.
E. They can modify the data type of the argument that is referenced.
F. They can accept a column name, expression, variable name, ora usersupplied
constant as arguments.
Answer: DEF
当行函数是用于处理数据项的。他接受一个或多个参数,并为查询返回的每个行返回一个值,参数可以是下列对象之一:
1、用户提供的常数
2、变量值
3、列名
4、表达式
单上函数具有以下特性:
作用于查询返回的每个行
为每行返回一个结果
可能会返回与引用数据类型不同的数据值
可能需要一个或多个参数
可能用在select、where和order by字句中