Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- DECLARE
- Wrowid ROWID;
- SAL NUMBER(5);
- BEGIN
- SELECT vl_sal, ROWID
- INTO Sal,ROWID
- FROM func
- WHERE cd_mat = 150;
- /* Atualiza os valores do salário */
- UPDATE func SET vl_sal = Sal * 1.3
- WHERE ROWID = Wrowid;
- END;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement