1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27
|
DROP TABLE foustock
/
DROP TABLE stock
/
CREATE TABLE foustock
(ttc INTEGER
,fou INTEGER
,stock INTEGER)
/
CREATE TABLE stock
(code INTEGER
,fou INTEGER)
/
INSERT INTO stock VALUES (1,123);
INSERT INTO foustock VALUES (100,123,1);
SELECT *
FROM foustock
/
update foustock set ttc=round( decode(ttc,null,0,'',0,ttc)+decode(ttc,null,0,'',0,ttc)*19.6,2)
where (stock,fou) in (select code,fou from stock where foustock.stock=stock.code and foustock.fou=stock.fou)
/
SELECT *
FROM foustock
/ |
Partager