PeopleSoft Learning

Oracle - Replace string in a FIELD.

Below is the example to replace all .net is particular filed with .com;

UPDATE TABLE_NAME SET FIELD_NAME=REPLACE(FIELD_NAME,'.net','.com');

For example the above SQL will change the field value from test.net to test.com;