My Pastes
Public Pastes
Layout Width
Share Pastebin
Guest
Public paste!

Felipe Ribeiro

By: a guest | Jul 1st, 2009 | Syntax: PL/SQL | Size: 0.25 KB | Hits: 133 | Expires: Never
Download | Raw | Embed | Report abuse
Copy text to clipboard
  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;
create new paste | create new version of this paste RAW Paste Data