How to replace specific values in a oracle database column?

by

Use REPLACE:

SELECT REPLACE(t.column, 'est1', 'rest1')
  FROM MY_TABLE t

If you want to update the values in the table, use:

UPDATE MY_TABLE t
   SET column = REPLACE(t.column, 'est1', 'rest1')

More Related Contents:

  1. How do I limit the number of rows returned by an Oracle query after ordering?
  2. How to create id with AUTO_INCREMENT on Oracle?
  3. When do I need to use a semicolon vs a slash in Oracle SQL?
  4. Is there an Oracle SQL query that aggregates multiple rows into one row? [duplicate]
  5. How to handle a single quote in Oracle SQL
  6. Select count(*) from multiple tables
  7. Fetch the rows which have the Max value for a column for each distinct value of another column
  8. REGEX to select nth value from a list, allowing for nulls
  9. Concatenate and group multiple rows in Oracle [duplicate]
  10. Difference between BYTE and CHAR in column datatypes
  11. How to use BOOLEAN type in SELECT statement
  12. Call a stored procedure with another in Oracle
  13. create table with sequence.nextval in oracle [duplicate]
  14. Oracle: loading a large xml file?
  15. IF EXISTS condition not working with PLSQL
  16. Group by alias (Oracle)
  17. Using pivot on multiple columns of an Oracle row
  18. Sleep function in ORACLE
  19. Split comma separated values of a column in row, through Oracle SQL query
  20. oracle — Split multiple comma separated values in oracle table to multiple rows
  21. How to query a CLOB column in Oracle
  22. update columns values with column of another table based on condition [duplicate]
  23. how to select even records from a table in oracle?
  24. Oracle : select maximum value from different columns of the same row
  25. Split varchar into separate columns in Oracle
  26. Creating or simulating two dimensional arrays in PL/SQL
  27. How to retrieve the current value of an oracle sequence without increment it?
  28. Oracle DB: How can I write query ignoring case?
  29. ORA-00942: table or view does not exist (works when a separate sql, but does not work inside a oracle function)
  30. Oracle Convert TIMESTAMP with Timezone to DATE

Leave a Comment