CREATE OR REPLACE TRIGGER STAR_TBL_TGR AFTER INSERT ON FEEDBACK_TBL FOR EACH ROW BEGIN UPDATE STAR_TBL SET TOTAL_TASTE = (SELECT SUM(TASTE) / COUNT(TASTE) FROM FEEDBACK_TBL); END;...
태그: oracle11g, oracle12c, ORACLE, oracle10g, select, select문, TRIGGER, 문