phân biệt giữa xóa và cắt ngắn

CREATE OR REPLACE PACKAGE BODY dwh AS

PROCEDURE filldwh IS

today_date DATE := SYSDATE;

BEGIN

DELETE FROM dwdimartist;

INSERT INTO dwdimartist (artistkey, name) (SELECT artistid, name FROM artist);

UPDATE dwdimartist SET added = today_date;

END filldwh;

END dwh;