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
IF CURSOR_TARIH%NOTFOUND THEN
INSERT INTO A_ACCOUNT (TARIH, PRICE) VALUES (SYSDATE, '1');
If you're in one of those predicaments where cls.__private attributes just aren't enough since they can easily be accessed through inst._cls__private, and you need something a little more secure, here's ...