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;

You marked this post as solved. Did you find solution? Would you mind to share it with otheres?

I just changed the logic of my project. Therefore, i don't use it.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.