Need help on PL/SQL database trigger
Need help on PL/SQL database trigger I have a DB trigger before insert on emp table. I would like to add sal, comm from emp_test table and want to use those value as a default in the emp table, by trigger. Any idea how to do it? before insert on emp sal, comm from emp_test emp How do those tables look like (we need their description). What is stored in EMP_TEST? A single row? Many rows (perhaps one per employee)? How are they distinguished? Why don't you create a DEFAULT value for those EMP columns? – Littlefoot Jul 1 at 9:42 1 Answer 1 Until you provide answers to questions I posted in a comment, here's how you might do it. See if you can adjust it. EMP_TEST table contains only one row (which is kind of stupid ; you'd rather use DEFAULT v...