Thanks Cris,Thanks for your response I was trying like this
...
CREATE OR REPLACE TRIGGER CATEGORY_TRANS_DATA_DELETE
BEFORE DELETE ON CATEGORY_TRANS
FOR EACH ROW
BEGIN
DECLARE
TOTAL_COUNT NUMBER(10,0);
RESPONSE CHAR(2);
BEGIN
SELECT COUNT(*) INTO TOTAL_COUNT FROM CATEGORY_TRANS WHERE
BLOG_ID=:OLD.BLOG_ID;
IF TOTAL_COUNT = 1 THEN
DBMS_OUTPUT.PUT_LINE('SINGLE RECORD FOUND...DO YOU WANT TO
DELETE???? ...Y/N');
END IF;
END;
END;
..
And I made it.
Thanks once again
Regards
Arijit Chatterjee
Received on Thu Feb 24 2005 - 06:41:59 CST
