AAA

BEGIN
INSERT INTO tt_ma_nt (ma_dvi, ma, ten, ten_xu, tc, nsd, idvung)
SELECT
rec.ma AS ma_dvi,
rec1.ma,
rec1.ten,
rec1.ten_xu,
rec1.tc,
rec1.nsd,
rec1.idvung
FROM
(SELECT ma FROM ht_ma_dvi WHERE ma <> '0800') rec
CROSS JOIN
(SELECT * FROM tt_ma_nt WHERE ma_dvi = '0800') rec1
WHERE NOT EXISTS (
SELECT 1
FROM tt_ma_nt t
WHERE t.ma_dvi = rec.ma
AND t.ma = rec1.ma
);

COMMIT;

END;
/

khai báo mã tiền tệ cho từng đơn vị