Which three tasks can be performed using regular expression support in Oracle Database 10g? (Choose three.)
A.
It can be used to concatenate two strings.
B.
It can be used to find out the total length of the string.
C.
It can be used for string manipulation and searching operations.
D.
It can be used to format the output for a column or expression having string data.
E.
It can be used to find and replace operations for a column or expression having string data.
regular expression is three function use
regexp_like()-> It can be used for string manipulation and searching operations.
regexp_substr()->It can be used to format the output for a column or expression having string data
***********************************************
regexp_instr()->It can be used to format the output for a column or expression having string data
regexp_replace()->It can be used to find and replace operations for a column or expression having string data
*******************************************************
so all these function are used to perform
The LENGTH function can be used in Oracle. For example:
LENGTH(NULL) would return NULL
LENGTH(”) would return NULL
LENGTH(‘ ‘) would return 1
I think the question is about regular expressions function not just character, number etc functions so answer is correct.
format output:
Select REGEXP_REPLACE(‘aa bb cc’,'(.*) (.*) (.*)’, ‘\3,\2,\1’) FROM DUAL;
result:cc bb aa
C,D,E
CDE