advanced code snippet search

Posted By

wh0emPah on 04/02/10


Tagged


Versions (?)

mqiojfei

 / Published in: PL/SQL
 
Expand | Embed | Plain Text 
  1. UPDATE s_product
  2. SET total_in_stock = (SELECT SUM(amount_in_stock) FROM s_inventory WHERE product_id = s_product.ID);

Report this snippet  

You need to login to post a comment.