CREATE TABLE SORGU_LOG (
SIRA_NO INTEGER NOT NULL,
TARIH VARCHAR(250),
OLCUM_NOKTASI VARCHAR(250),
ACK CHAR(250)
);
CREATE trigger PcDr_sorgu_Log for sorgu
active before delete position 0
AS
begin
Insert into sorgu_log
("SIRA_NO","TARIH","OLCUM_NOKTASI","ACK"
)values(old."SIRA_NO",old."TARIH",old."OLCUM_NOKTASI",old."ACK"
);
end
|