Hi,
the data in my table, have a substring enclosed in parenthesis,
1. i want to replace the string with the brackets to null or any other
value.
2. remove the contents within brackets.
Example:
table name person:
name
------------------------------------
Samuel (S/o Sebastin )
-------------------------------------
remove the word within the brackets.
the output should be , Samuel.
the below one help's me to find the data within the two brackets.
SELECT name,(REGEXP_MATCHES(name, E'\\(.+?\\)'))[1] from person;
regexp_matches
------------------------------------
(S/o Sebastin )
-------------------------------------
-Nicholas I