* if the employee name and department name has one or more than one in the same letter, then the employees of COMM 500 increase, the update my_emp a set COMM=NVL (COMM, 0) + 500 where a.e name<> (select translate (a.e name, b.d name, CRH (27)) from my_dept b where b.d eptno=a. d. eptno); - a. d. eptno and b.d eptno must have the main foreign key connection, otherwise can go wrong, why? commit;

CodePudding user response:

Under the table structure said, use the create table form,