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
