Which three tasks can be performed using regular expression support in Oracle Database 10g?

Which three tasks can be performed using regular expression support in Oracle Database 10g? (Choose three.)

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.



Leave a Reply 6

Your email address will not be published. Required fields are marked *


Anurag

Anurag

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

user

user

The LENGTH function can be used in Oracle. For example:

LENGTH(NULL) would return NULL
LENGTH(”) would return NULL
LENGTH(‘ ‘) would return 1

Justyna

Justyna

I think the question is about regular expressions function not just character, number etc functions so answer is correct.

X-RAY

X-RAY

format output:
Select REGEXP_REPLACE(‘aa bb cc’,'(.*) (.*) (.*)’, ‘\3,\2,\1’) FROM DUAL;
result:cc bb aa

umesh bhutada

umesh bhutada

C,D,E

networkmanagers

networkmanagers

CDE