AAA

ALTER TABLE bh_phh_dk RENAME TO bh_phh_dk_old;
CREATE TABLE bh_phh_dk (
ma_dvi varchar2(10),
so_id number,
so_id_dt number,
bt number,
ma varchar2(10),
ten nvarchar2(500),
tc varchar2(1),
ma_ct varchar2(10), -- Ma cap tren
kieu varchar2(1),
tien number,
pt number,
phi number,
cap number,
ma_dk varchar2(10),
ma_dkC varchar2(10),
lh_nv varchar2(10),
t_suat number,
thue number,
ttoan number,
ptB number,
phiB number,
ptG number,
phiG number,
lkeM varchar2(1),
lkeP varchar2(1),
lkeB varchar2(1),
luy varchar2(1),
pvi_ma varchar2(10),
pvi_tc varchar2(1),
pvi_ktru varchar2(100)
);
INSERT INTO bh_phh_dk (
ma_dvi, so_id, so_id_dt, bt, ma, ten, tc, ma_ct, kieu, tien, pt, phi, cap,
ma_dk, ma_dkC, lh_nv, t_suat, thue, ttoan, ptB, phiB, ptG, phiG,
lkeM, lkeP, lkeB, luy, pvi_ma, pvi_tc, pvi_ktru
)
SELECT
ma_dvi, so_id, so_id_dt, bt, ma, ten, tc, ma_ct, kieu, tien, pt, phi, cap,
ma_dk, ma_dkC, lh_nv, t_suat, thue, ttoan, ptB, NULL, ptG, phiG, -- phiB ban đầu NULL
lkeM, lkeP, lkeB, luy, pvi_ma, pvi_tc, pvi_ktru
FROM bh_phh_dk_old;
DROP TABLE bh_phh_dk_old;