Tags

,

REGEXP_REPLACE(target_name,'(([\.]|[:])[a-z,A-Z,0-9]*)|(-[0-9]{3})’,”)

It was written to transform host entries in the table of the format “aaa-bbb-001.ccc.ddd.eeeeeee.fff” to aaa-bbb . The underlying requirement was to get one distinct entry for all RAC nodes in a cluster.

Advertisements