0

Hi,
Where is the mistake? It doesn't work. thanks

CREATE OR REPLACE TRIGGER A_ACCOUNT_EKLEME
BEFORE INSERT ON A_SIPARIS

CURSOR CURSOR_TARIH IS 
SELECT TARIH FROM A_ACCOUNT where TARIH = SYSDATE;

FOR EACH ROW
BEGIN
    
    IF CURSOR_TARIH%NOTFOUND THEN
      INSERT INTO A_ACCOUNT (TARIH, PRICE) VALUES (SYSDATE, '1');
    END IF;
END;
2
Contributors
2
Replies
3
Views
9 Years
Discussion Span
Last Post by veledrom
This question has already been answered. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.