title: Rename multiple records oracle
body: <p>I am trying to rename multiple records in a column that contains special characters </p>
  
  <pre><code>WHERE REGEXP_LIKE(Name, '[!@#$%^&amp;*=+/&lt;&gt;?|]') ;
  </code></pre>
  
  <p>I've tried to fetch every single record that contains a special character into an array and loop through it with the update statement.
  But....when i try to change the first record , the other ones(3) also change to the new value.<br>
  I try to set the new value with an INPUT field/box , is there also a possibilty to change the line above the textbox  to the old value(te name with the special characters) </p>
  
  <pre><code>  CREATE TABLE LOCATION
     (    "ID" NUMBER PRIMARY KEY, 
          "NAME" VARCHAR2(20 BYTE)
     ) ;
  Insert into SYSTEM.LOCATION (ID,NAME) values ('2','RE#$');
  Insert into SYSTEM.LOCATION (ID,NAME) values ('3','rete%#');
  Insert into SYSTEM.LOCATION (ID,NAME) values ('4','Testjue');
  Insert into SYSTEM.LOCATION (ID,NAME) values ('5','Test#');
  </code></pre>
  
  <p>/  </p>
  
  <pre><code>DECLARE
    CURSOR name_cursor IS
      SELECT id, name
      FROM Location
      WHERE REGEXP_LIKE(name, '[!@#$%^&amp;*=+/&lt;&gt;?|]')
      FOR UPDATE OF name;
  BEGIN
    FOR loc_rec IN name_cursor LOOP
      DBMS_Output.Put_Line(loc_rec.name);
      UPDATE Location SET name = '&amp;whatever' WHERE Location.id=loc_rec.ID;
    END LOOP;
  END;
  </code></pre>
  
  <p>This changes all values in the table with special characters to the input of the prompt "whatever", but i need to set the value different for each record.<br>
  Here a picture what happens when the input was "test"
  <img src="https://i.stack.imgur.com/tIuSz.png" alt="enter image description here"></p>