Example of creating a change procedure

I do not know oracle at all, but in mysql it is done something like this ...
Request

\d // --устанавливаем делиметр CREATE PROCEDURE updateAdress(IN username VARCHAR(50), IN newArdess VARCHAR(50)) --тип данных IN параметров должен совпадать с типом в таблице BEGIN UPDATE staff SET adress=newAdress WHERE name=username; END; // --подверждаем операцию \d ; --возвращаем стандартный деллиметр 

Now to call, for example from PHP ..

 // подключение... $username = 'Вася'; $newAdress = 'ул.Васильковская, д.10'; mysql_query("CALL updateAdress($username, $newAdress)"); //где username имя пользователя newAdress обновляемое значение //в данном случае мы обновляем адресс Васе... 

Important notes - in your particular example, the name should be either the primary key in order to avoid changing several entries at once, or some additional parameter should be added, in general, any update operation of single records should occur either by unique index , or by primary key or by unique composite index.

Once again, I didn’t do anything with oracle, maybe it’s done differently there ... (about procedures)

You do not need a procedure, but a trigger. Trigger syntax for oracle:

 CREATE TRIGGER schema.trigger_name AFTER UPDATE ON schema.table_name pl/sql_block 

Next - google in hand, see examples and write your own.

The @AlexWindHope in oracle is almost all but without a delimiter:

 CREATE OR REPLACE PROCEDURE change_address(name in varchar2(50), new_address in varchar2(100)) is BEGIN UPDATE staff SET adress=newAdress WHERE name=username; COMMIT; END; /