Oracle Interview Q&A, SQL in Oracle, REGEXP_SUBSTR
1.1 هزار بار بازدید -
2 سال پیش
-
Oracle Real Time Scenario, SQL
Oracle Real Time Scenario, SQL in Oracle, REGEXP_SUBSTR() #sql #oracle #regexp
REGEXP_SUBSTR extends the functionality of the SUBSTR function by letting you search a string for a regular expression pattern. It is also similar to REGEXP_INSTR, but instead of returning the position of the substring, it returns the substring itself. This function is useful if you need the contents of a match string but not its position in the source string. The function returns the string as VARCHAR2 or CLOB data in the same character set as source_char.
REGEXP_SUBSTR extends the functionality of the SUBSTR function by letting you search a string for a regular expression pattern. It is also similar to REGEXP_INSTR, but instead of returning the position of the substring, it returns the substring itself. This function is useful if you need the contents of a match string but not its position in the source string. The function returns the string as VARCHAR2 or CLOB data in the same character set as source_char.
2 سال پیش
در تاریخ 1401/03/25 منتشر شده
است.
1,152
بـار بازدید شده