Which two statements are true regarding single row functions? (Choose two.)
A. They accept only a single argument.
B. They can be nested only to two levels.
C. Arguments can only be column values or constants.
D. They always return a single result row for every row of a queried table.
E. They can return a data type value different from the one that is referenced.
答案 DE
二、题目翻译
关于单行函数,下面哪两个选项是正确的?(选择两个)
A. 只接受一个参数。
B. 只能被嵌套两级。
C. 参数只能是列值或者常量。
D. 对于查询表的每一行总是返回一个结果行。
E. 返回值的数据类型可以与之前引用的数据类型不同。
Single-row functions return a single result row for every row of a queried table or view. These functions can appear in select lists, WHERE clauses, START WITH and CONNECT BY clauses, and HAVINGclauses.
Character functions that return number values can take as their argument any character data type. The character functions that return number values are:
ASCII
INSTR
LENGTH
REGEXP_COUNT
REGEXP_INSTR