Advertisement
Guest User

Felipe Ribeiro

a guest
Jul 1st, 2009
324
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PL/SQL 0.25 KB | None | 0 0
  1. DECLARE
  2.  
  3. Wrowid ROWID;
  4. SAL NUMBER(5);
  5.  
  6. BEGIN
  7.     SELECT vl_sal, ROWID
  8.       INTO Sal,ROWID
  9.       FROM func
  10.      WHERE cd_mat = 150;
  11.     /* Atualiza os valores do salário */
  12.      UPDATE func SET vl_sal = Sal * 1.3
  13.       WHERE ROWID = Wrowid;
  14. END;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement