diteps06
asked on
How can I replace a particular string pattern in a word
I have a coumn which can have values ‘aw45t/P76/002’, ‘aw45t/P54/002’,
I will like to replace any occurrence of /P##/ with /P99/
DB: Oracle 10g
I will like to replace any occurrence of /P##/ with /P99/
DB: Oracle 10g
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thanks for the fast and precise answer
REGEXP_REPLACE(column,'/P[